SQL transformations and revisions

​

Create a transformation

1. Open Transformations.
2. Select a destination in the left navigator.
3. Click New transformation.
4. Enter a name, stable key, and output model.
5. Select one or more source input streams.
6. Write the SQL model.
7. Click Save draft.

​

Release a revision

1. Validate draft checks SQL and the output model.
2. Preview output runs the valid draft and shows its result.
3. Publish revision makes that revision available to the owning destination’s next run.

​

Rename and cast values

SELECT
  id,
  status AS order_status,
  CAST(total_amount AS DECIMAL(12, 2)) AS total_amount
FROM {{ source('raw', 'public__orders') }}

​

Assign the published output