Manage Data
Transforms
Transforms turn a query result into a permanent, reusable table. Save a one-off query as a table in a few clicks, or set up a saved transform that reruns on a schedule — adding only the new rows each time — and keep the source of every table traceable back to where it came from.
Quick Start
- 1
Run a query in Query Studio
Write a SELECT statement and click Run to confirm the result looks right.
- 2
Click "Save as Table"
Give the destination table a name — letters, digits, and underscores only, and it can't start with a digit.
- 3
Choose a write mode
Create (fail if it already exists), Overwrite (replace everything), Append (add new rows only), or Merge (update existing rows by a primary key).
- 4
Save and confirm
In a few seconds you'll see how many rows were written and how many lineage links were recorded.
- 5
View it in the Catalog
Click "View in catalog" to see the new table and trace it back to the source it came from.
- 6
(Optional) Make it recurring
Open the Transforms page, create a saved transform from the same logic, and set a schedule so it refreshes automatically.
- Deleting a saved transform stops its schedule but keeps the destination table and its data intact.
- Only queries that read data (no changes to the source) can be saved as a table.
- You'll need transform permissions to save or run a transform — ask your admin if a button looks unavailable.