Normalisation and SQL

The live transformation workflow is destination-scoped.

Normalisation

Use the Normalisation tab for rename and cast rules. Example:

Rule	Table	Column	Target
Rename	`public.orders`	`status`	`order_status`
Cast	`public.orders`	`total_amount`	`numeric`

SQL Layer

Use the SQL Layer tab for SQL models. Models read from temporary raw tables:

SELECT
  id,
  customer_id,
  order_status,
  total_amount,
  created_at,
  updated_at
FROM {{ source('raw', 'public__orders') }}

Set each model’s final delivery table as schema.table, such as analytics.orders_live.

Multiple outputs

When multiple source streams are selected, configure a SQL model and final delivery table for each stream you intend to deliver. Each final destination table must already exist.

​Normalisation

​SQL Layer

​Multiple outputs

Normalisation

SQL Layer

Multiple outputs