How to Cast a Column in Snowflake

Last updated July 24, 2026 · By the SaturnSQL team

Use CAST(col AS TYPE) or the :: shorthand. TRY_CAST returns NULL instead of erroring on bad values, which is the safe choice for messy string data.

SELECT CAST(amount AS INTEGER), amount::VARCHAR
FROM orders;

TRY_CAST for dirty data

SELECT TRY_CAST(user_input AS DATE) FROM raw_events; -- NULL when unparseable

Run this in SaturnSQL

SaturnSQL is a browser-based SQL editor for teams: shared query library, schema-aware autocomplete, and scheduled exports to Google Sheets and Slack.

Related Snowflake guides