Rename and cast in SQL

​

Rename a column

SELECT
  id,
  status AS order_status
FROM {{ source('raw', 'public__orders') }}

​

Cast a column

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

​

Release the change

1. Open Transformations and select the destination.
2. Open the transformation editor.
3. Update SQL and click Save draft.
4. Validate draft, Preview output, and Publish revision.
5. Confirm the published output still matches the destination table contract.