Skip to main content
Transformations are owned by a destination and managed from the Transformations tab. The current workspace does not use canvas nodes or a Destination panel.

​
Ownership model

Each destination has an isolated set of SQL models and revisions. Editing or publishing a transformation for one delivery target does not change another destination.

​
Release workflow

  1. Select a destination in Transformations.
  2. Create or open a transformation.
  3. Choose input streams and write SQL.
  4. Click Save draft.
  5. Click Validate draft.
  6. Click Preview output.
  7. Click Publish revision.
Runs continue using the last published revision until a newer draft completes all release steps.

​
SQL responsibilities

Use SQL to rename and cast columns, filter rows, derive fields, extract JSON, join streams, aggregate values, and select the final output contract. See SQL transformations. After publishing, open the destination editor to assign the model to its final table and configure Upsert keys or Airtable field mappings.