SnowConvert AI - Vertica - Operators¶
Operators¶
Vertica Operators
Cast coercion operator¶
Operator use if want to return:
NULL instead of an error for any non-date/time data types
NULL instead of an error after setting EnableStrictTimeCasts
To replicate this functionality SnowConvert AI translates this operator to the TRY_CAST
function.
Sample Source Patterns¶
Vertica¶
SELECT
measurement_id,
reading::!FLOAT AS measurement_value
FROM raw_measurements;
Snowflake¶
SELECT
measurement_id,
TRY_CAST(
reading AS FLOAT) AS measurement_value
FROM
raw_measurements;