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.