Skip to main content
Normalisation is configured in the Destination panel. It runs after extraction and before the SQL Layer.

​
Live rule types

RuleUse it for
RenameChange a source column name before the SQL model reads it
CastCoerce a staged value to a destination-friendly type
Rules can be scoped to a source stream such as public.orders.

​
Example

If the source stream is public.orders, you can add:
RuleTableColumnTarget
Renamepublic.ordersstatusorder_status
Castpublic.orderstotal_amountnumeric
The SQL model should then reference the post-normalisation names: 
SELECT
  id,
  customer_id,
  order_status,
  total_amount,
  created_at,
  updated_at
FROM {{ source('raw', 'public__orders') }}

​
When to use SQL models instead

Use the SQL Layer for filtering rows, deriving fields, joining, aggregating, or reshaping output columns. Normalisation is intentionally small and structural.