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

VerticaSnowflake
BINARY (https://docs.vertica.com/25.1.x/en/sql-reference/data-types/binary-data-types-binary-and-varbinary/)BINARY
VARBINARY (synonyms: BYTEA, RAW, BINARY VARYING) (https://docs.vertica.com/25.1.x/en/sql-reference/data-types/binary-data-types-binary-and-varbinary/)BINARY (synonyms: VARBINARY, BINARY VARYING)
LONG VARBINARY (https://docs.vertica.com/25.1.x/en/sql-reference/data-types/long-data-types/)

BINARY

Notes: Vertica’s LONG VARBINARY supports up to 32,000,000 bytes (~30.5MB), while Snowflake’s BINARY is limited to (8,388,608 bytes) 8MB. This size difference means you might need an alternative solution for mapping larger LONG VARBINARY data.

Boolean Data Type

VerticaSnowflake
BOOLEAN (https://docs.vertica.com/25.1.x/en/sql-reference/data-types/boolean-data-type/)BOOLEAN

Character Data Type

VerticaSnowflake
CHAR (https://docs.vertica.com/25.1.x/en/sql-reference/data-types/character-data-types-char-and-varchar/)CHAR
VARCHAR (https://docs.vertica.com/25.1.x/en/sql-reference/data-types/character-data-types-char-and-varchar/)VARCHAR
LONG VARCHAR (https://docs.vertica.com/25.1.x/en/sql-reference/data-types/long-data-types/)

VARCHAR

Notes: Vertica’s LONG VARCHAR supports up to 32,000,000 bytes (~30.5MB), while Snowflake’s VARCHAR is limited to 16,777,216 bytes (16MB). This size difference means you might need an alternative solution for mapping larger LONG VARCHAR data.

Date/Time Data Type

VerticaSnowflake
DATE (https://docs.vertica.com/25.1.x/en/sql-reference/data-types/datetime-data-types/date/)

DATE

Notes: Be aware of Snowflake’s recommended year range (1582-9999).

TIME (https://docs.vertica.com/25.1.x/en/sql-reference/data-types/datetime-data-types/timetimetz/)TIME
TIME WITH TIMEZONE (TIMETZ) (https://docs.vertica.com/25.1.x/en/sql-reference/data-types/datetime-data-types/timestamptimestamptz/)

TIME

Notes: TIME data type in Snowflake does not persist this timezone attribute. SSC-FDM-0005 is added.

TIMESTAMP (https://docs.vertica.com/25.1.x/en/sql-reference/data-types/datetime-data-types/timestamptimestamptz/)TIMESTAMP
DATETIME (https://docs.vertica.com/25.1.x/en/sql-reference/data-types/datetime-data-types/datetime/)DATETIME
SMALLDATETIME (https://docs.vertica.com/25.1.x/en/sql-reference/data-types/datetime-data-types/smalldatetime/)TIMESTAMP_NTZ
TIMESTAMP WITH TIMEZONE (TIMESTAMPTZ) (https://docs.vertica.com/25.1.x/en/sql-reference/data-types/datetime-data-types/timestamptimestamptz/)TIMESTAMP_TZ
TIMESTAMP WITHOUT TIME ZONE (https://docs.vertica.com/25.1.x/en/sql-reference/data-types/datetime-data-types/timestamptimestamptz/)TIMESTAMP_NTZ

Approximate Numeric Data Type

VerticaSnowflake
DOUBLE PRECISION (https://docs.vertica.com/25.1.x/en/sql-reference/data-types/numeric-data-types/double-precision-float/)DOUBLE PRECISION
FLOAT (https://docs.vertica.com/25.1.x/en/sql-reference/data-types/numeric-data-types/double-precision-float/)FLOAT
FLOAT8 (https://docs.vertica.com/25.1.x/en/sql-reference/data-types/numeric-data-types/double-precision-float/)FLOAT8
REAL (https://docs.vertica.com/25.1.x/en/sql-reference/data-types/numeric-data-types/double-precision-float/)REAL

Exact Numeric Data Type

VerticaSnowflake
INTEGER (https://docs.vertica.com/25.1.x/en/sql-reference/data-types/numeric-data-types/integer/)INTEGER
INT (https://docs.vertica.com/25.1.x/en/sql-reference/data-types/numeric-data-types/integer/)INT
BIGINT (https://docs.vertica.com/25.1.x/en/sql-reference/data-types/numeric-data-types/integer/)BIGINT
INT8 (https://docs.vertica.com/25.1.x/en/sql-reference/data-types/numeric-data-types/integer/)INTEGER
SMALLINT (https://docs.vertica.com/25.1.x/en/sql-reference/data-types/numeric-data-types/integer/)SMALLINT (https://docs.vertica.com/25.1.x/en/sql-reference/data-types/numeric-data-types/integer/)
TINYINT (https://docs.vertica.com/25.1.x/en/sql-reference/data-types/numeric-data-types/integer/)TINYINT (https://docs.vertica.com/25.1.x/en/sql-reference/data-types/numeric-data-types/integer/)
DECIMAL (https://docs.vertica.com/25.1.x/en/sql-reference/data-types/numeric-data-types/numeric/)DECIMAL
NUMERIC (https://docs.vertica.com/25.1.x/en/sql-reference/data-types/numeric-data-types/numeric/)NUMERIC
NUMBER (https://docs.vertica.com/25.1.x/en/sql-reference/data-types/numeric-data-types/numeric/)NUMBER
MONEY (https://docs.vertica.com/25.1.x/en/sql-reference/data-types/numeric-data-types/numeric/)NUMERIC

Spatial Data Type

VerticaSnowflake
GEOMETRY (https://docs.vertica.com/25.1.x/en/sql-reference/data-types/spatial-data-types/)GEOMETRY
GEOGRAPHY (https://docs.vertica.com/25.1.x/en/sql-reference/data-types/spatial-data-types/)GEOGRAPHY

UUID Data Type

VerticaSnowflake
UUID (https://docs.vertica.com/25.1.x/en/sql-reference/data-types/uuid-data-type/)

VARCHAR(36)

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 UUID_STRING() function.