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

Vertica	Snowflake
BINARY	BINARY
VARBINARY (synonyms: BYTEA, RAW, BINARY VARYING)	BINARY (synonyms: VARBINARY, BINARY VARYING)
LONG VARBINARY	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.

BINARY

VARBINARY (synonyms: BYTEA, RAW, BINARY VARYING)

BINARY (synonyms: VARBINARY, BINARY VARYING)

LONG VARBINARY

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	BOOLEAN

Character Data Type¶

Vertica Snowflake

Vertica	Snowflake
CHAR	CHAR
VARCHAR	VARCHAR
LONG VARCHAR	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.

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	DATE Notes: Be aware of Snowflake’s recommended year range (1582-9999).
TIME	TIME
TIME WITH TIMEZONE (TIMETZ)	TIME Notes: TIME data type in Snowflake does not persist this timezone attribute. `SSC-FDM-0005` is added.
TIMESTAMP	TIMESTAMP
DATETIME	DATETIME
SMALLDATETIME	TIMESTAMP_NTZ
TIMESTAMP WITH TIMEZONE (TIMESTAMPTZ)	TIMESTAMP_TZ
TIMESTAMP WITHOUT TIME ZONE	TIMESTAMP_NTZ

Approximate Numeric Data Type¶

Vertica	Snowflake
DOUBLE PRECISION	DOUBLE PRECISION
FLOAT	FLOAT
FLOAT8	FLOAT8
REAL	REAL

Exact Numeric Data Type¶

Vertica	Snowflake
INTEGER	INTEGER
INT	INT
BIGINT	BIGINT
INT8	INTEGER
SMALLINT	SMALLINT
TINYINT	TINYINT
DECIMAL	DECIMAL
NUMERIC	NUMERIC
NUMBER	NUMBER
MONEY	NUMERIC

Spatial Data Type¶

Vertica	Snowflake
GEOMETRY	GEOMETRY
GEOGRAPHY	GEOGRAPHY

UUID Data Type¶

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