SQL based Datasets take SQL queries and turn them into reusable data sources that people can use as the basis for additional analysis. Datasets can also be materialized to your database, helping speed up queries.
Any changes made to the Dataset will be propagated forward to all of the worksheets built on the Dataset.
Create a SQL Based Dataset
- Open the SQL Runner. You can open the SQL Runner from the home page or from the left-hand navigation menu
- Write your SQL query
- Run your SQL query and check that you are getting the data you want.
- Click ‘Create Dataset’