clean_cast
Cast columns to specified data types using TRY_CAST, converting non-castable values to NULL instead of failing.
Instructions
New source with columns TRY_CAST to new dtypes per mapping.
Uses `TRY_CAST` so non-castable values become NULL rather than erroring
— appropriate for the type-drift workflow where a few outliers are fine.
Common casts: 'DOUBLE', 'INTEGER', 'BIGINT', 'VARCHAR', 'BOOLEAN', 'DATE'.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| alias | No | ||
| mapping | Yes | ||
| source_id | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||