Editing the Dataset Type

When you edit a dataset, you can change the underlying table or query that it points to. This allows you to iterate and develop against a smaller test dataset, then switch to the full dataset when you are ready to deploy the project.

To use this functionality, you must either:

Use a table that has the same schema, column names, column order, etc. as the original table.
Use a query dataset that is limit query on the original table.

Change the type from a table to a query

To switch the basis of the dataset from a physical table to a query:

In the Repo Browser, click the menu icon for the dataset you want to edit and select Edit. The Edit Dataset panel opens.
Under Dataset Type, select Query.
In the Selection SQL field, enter the SQL query you want to use.
(Optional) Click Preview SQL to see the rows that the query returns.
Click Apply.

Change the type from a query to a table

To switch the basis of the dataset from a query to a physical dataset:

In the Repo Browser, click the menu icon for the dataset you want to edit and select Edit. The Edit Dataset panel opens.
Under Dataset Type, select Table.
Select a new Schema and Table.
Click Apply.