> ## 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.

# Rename and cast in SQL

> Replace the former Normalisation panel with explicit rename and cast expressions in destination-owned SQL.

The current pipeline workspace does not expose a separate **Normalisation** tab
or panel. Older documentation that instructs you to add rename/cast rules there
is obsolete.

Perform structural changes in the destination-owned SQL transformation instead.

## Rename a column

```sql theme={"theme":{"light":"github-light","dark":"github-dark"}}
SELECT
  id,
  status AS order_status
FROM {{ source('raw', 'public__orders') }}
```

## Cast a column

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

Explicit SQL keeps rename/cast behavior versioned with the same revision used by
the run.