> ## Documentation Index
> Fetch the complete documentation index at: https://docs.mantrixflow.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Transformation workflow

> Create destination-owned SQL drafts and release validated, previewed revisions.

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](/pipelines/dbt-layer).

After publishing, open the destination editor to assign the model to its final
table and configure Upsert keys or Airtable field mappings.