Skip to main content
The live transformation flow happens in the Destination panel.
LayerLocationPurpose
NormalisationDestination panelRename and cast columns before the SQL model
SQL LayerDestination panelSQL model that selects final output columns

​
Normalisation

Use Normalisation for small structural changes such as renaming status to order_status or casting a string amount to numeric.

​
SQL Layer

Use SQL for business logic:
  • filtering rows
  • deriving columns
  • selecting the exact destination shape
  • extracting JSON fields
  • joining staged tables when available
Example: 
SELECT
  id,
  customer_id,
  LOWER(order_status) AS order_status,
  total_amount,
  created_at,
  updated_at
FROM {{ source('raw', 'public__orders') }}
WHERE order_status IS NOT NULL
The model output must match the pre-created destination table.