> ## Documentation Index
> Fetch the complete documentation index at: https://docs.mantrixflow.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Normalisation and SQL

> Shape data with destination-scoped Normalisation and SQL models in the current builder.

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:

```sql theme={"theme":{"light":"github-light","dark":"github-dark"}}
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.