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

( Vertica SQL Language Reference Coercion operator )

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;
Copy

Snowflake¶

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