SnowConvert AI - Vertica - Operators¶

Cast coercion operator¶

Operator used to return:

• NULL instead of an error for any non-date/time data types

• NULL instead of an error after setting EnableStrictTimeCasts

( Vertica SQL Language Reference Coercion operator (https://docs.vertica.com/24.1.x/en/sql-reference/language-elements/operators/data-type-coercion-operators-cast/cast-failures/#returning-all-cast-failures-as-null))

To replicate this functionality SnowConvert AI translates this operator to the TRY_CAST function.

Sample Source Patterns¶

 SELECT
    measurement_id,
    reading::!FLOAT AS measurement_value
FROM raw_measurements;

 SELECT
    measurement_id,
    TRY_CAST(
    reading AS FLOAT) AS measurement_value
FROM
    raw_measurements;