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
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.

Vertica

Snowflake

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¶

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

Character Data Type¶

Vertica	Snowflake
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.

Vertica

Snowflake

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¶

Vertica	Snowflake
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¶

Vertica	Snowflake
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¶

Vertica	Snowflake
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¶

Vertica	Snowflake
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¶

Vertica	Snowflake
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.

Vertica

Snowflake

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.