SQL Based Dataset

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

  1. Click the + button in the left hand navigation panel to open the Create New / Explore Data menu. Select Write SQL to open SQL Runner. 
    Screen_Shot_2020-10-28_at_4.05.14_PM.png
  2. Select a connection.
  3. Write your SQL query in the text editor. 
    Screen_Shot_2020-10-28_at_4.09.19_PM.png
  4. Click the Run button to run your SQL query and check that you are getting the data you want.
  5. In the page header, click Save as Dataset.