Skip to main content

Creating queries in playground with SQL query

You can directly write SQL queries to retrieve and manipulate data from your connected data sources. This query can be saved and can be easily accessed and re-executed later.

To create a query in the playground, do the following:

  1. On the Home page, from the left navigation panel, select Playground.

  2. In the query editor on the right, you can enter your query.

    creating queries in playground

  3. From the upper right corner, click Create. Construct your SQL query according to the schema of the tables in the desired data source. You can use multiple sources in your query. For example, you can write a query that joins different data sources, warehouses and even workbooks.

    creating queries in playground1

  4. In the Create Query page, enter the following details for your query and click Create.

    creating queries in playground1

    • Name: Enter a name for your query

    • Description: provide a description about the query.
      Your query is auto-populated here.
      Your query is created and listed in the queries list. You can view this query from Playground > Queries tab. After the query is saved, you will get a quick snapshot of the multiple data sources used in the query