The dataset editor has recently been revamped. The old version looked like this:
The updated dataset editor is now on the left configuration panel. You can navigate to it by clicking on the “Datasets” Tab.
You can perform the following actions from the datasets panel:
Once a dataset has been selected, you can use the editor to create, edit, execute, and save a query. You can also format the data generated.
This is where you write your raw SQL query to be executed. You can perform the following actions on the query:
Once a query has been run, you can see the executed version of it. Read more about how to use the executed query for debugging here.
This section shows a data table with the result of the executed query. If there are errors with your query, they will be displayed here.
If you have AI
enabled for your account, you can get error resolution suggestions here as well.
This section shows the available columns in each of the tables present in the selected schema. You can also swap schemas here, but doing so may cause your charts to load different data.
This section displays the variables that are available for use in the query. Read more about how to use variables here.
Once the query has been executed, you can use the formatting tab to modify and style the table shown in the underlying data modal. Read more about exposing the underlying data on your charts here.