SQL transformations

​

Create or open a model

1. Open the pipeline’s Transformations tab.
2. Select a destination.
3. Click New transformation or open an existing row.
4. Choose input streams, enter a stable key and output model, and write SQL.

​

Source references

{{ source('raw', 'public__orders') }}

​

Example

SELECT
  id,
  customer_id,
  LOWER(order_status) AS order_status,
  CAST(total_amount AS DECIMAL(12, 2)) AS total_amount,
  created_at,
  updated_at
FROM {{ source('raw', 'public__orders') }}
WHERE order_status IS NOT NULL

​

Draft and publish lifecycle

1. Save draft stores the SQL without affecting runs.
2. Validate draft checks the SQL and output model.
3. Preview output executes the valid draft for inspection.
4. Publish revision makes it the destination’s active run input.

​

Delivery assignment