SnowConvert AI - Vertica - Data types¶
Snowflake supports most basic SQL data types (with some restrictions) for use in columns, local variables, expressions, parameters, and any other appropriate/suitable locations.
Binary Data Type¶
Vertica |
Snowflake |
---|---|
Notes: Vertica’s |
Boolean Data Type¶
Vertica |
Snowflake |
---|---|
Character Data Type¶
Vertica |
Snowflake |
---|---|
Notes: Vertica’s |
Date/Time Data Type¶
Vertica |
Snowflake |
---|---|
Notes: Be aware of Snowflake’s recommended year range (1582-9999). |
|
Notes: TIME data type in Snowflake does not persist this timezone attribute. |
|
Approximate Numeric Data Type¶
Vertica |
Snowflake |
---|---|
Exact Numeric Data Type¶
Vertica |
Snowflake |
---|---|
Spatial Data Type¶
Vertica |
Snowflake |
---|---|
UUID Data Type¶
Vertica |
Snowflake |
---|---|
Notes: Snowflake doesn’t have a native UUID data type. Instead, UUIDs are usually stored as either VARCHAR(36) (for string format) or BINARY(16) (for raw byte format). You can generate RFC 4122-compliant UUIDs in Snowflake using the built-in |