Data types

Snowflake provides support for the majority of fundamental SQL data types, with specific restrictions, across various SQL constructs including columns, local variables, expressions, and parameters.

Boolean Data Type

BigQuery
Snowflake
Notes

Bytes Data Type

BigQuery
Snowflake
Notes

Datetime Data Types

BigQuery
Snowflake
Notes

DATETIME is an alias for TIMESTAMP_NTZ in Snowflake.

TIMESTAMP data type is converted to TIMESTAMP_TZ. For more information, please refer to the TIMESTAMP data type documentation.

Geography Data Type

BigQuery
Snowflake
Notes

Interval Data Type

BigQuery
Snowflake
Notes

Json Data Type

BigQuery
Snowflake
Notes

Numeric Data Types

BigQuery
Snowflake
Notes

INT is an alias for the NUMBER data type in Snowflake. The maximum precision and scale is NUMBER(38,37).

INT is an alias for the NUMBER data type in Snowflake. The maximum precision and scale is NUMBER(38,37).

SMALLINT is an alias for the NUMBER data type in Snowflake. The maximum precision and scale is NUMBER(38,37).

INTEGER is an alias for the NUMBER data type in Snowflake. The maximum precision and scale is NUMBER(38,37).

BIGINT is an alias for the NUMBER data type in Snowflake. The maximum precision and scale is NUMBER(38,37).

TINYINT is an alias for the NUMBER data type in Snowflake. The maximum precision and scale is NUMBER(38,37).

BYTEINT is an alias for the NUMBER data type in Snowflake. The maximum precision and scale is NUMBER(38,37).

NUMERIC is an alias for the NUMBER data type in Snowflake. The maximum precision and scale is NUMBER(38,37).

DECIMAL is an alias for the NUMBER data type in Snowflake. The maximum precision and scale is NUMBER(38,37).

Snowflake does not support the BIGNUMERIC data type. Use NUMERIC instead. BIGNUMERIC's precision 76,76 exceeds Snowflake's limit (38), resulting in truncation or rounding, which can introduce significant inaccuracies.

Snowflake does not support the BIGDECIMAL data type. Use NUMERIC instead. BIGDECIMAL's precision 76,76 exceeds Snowflake's limit (38), resulting in truncation or rounding, which can introduce significant inaccuracies.

String Data Types

BigQuery
Snowflake
Notes

STRING is an alias for the VARCHAR data type in Snowflake. VARCHAR holds Unicode UTF-8 characters.

Last updated