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.
Boolean Data Type
Bytes Data Type
BigQuery | Snowflake | Notes |
---|---|---|
BYTES data type is not supported in Snowflake. BINARY is used instead. For more information, please refer to the BYTES data type documentation. |
Datetime Data Types
BigQuery | Snowflake | Notes |
---|---|---|
Supported data type in Snowflake. DATE accepts dates in the most common forms ( | ||
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. | ||
A time value represents a time of day, as might be displayed on a clock, independent of a specific date and time zone |
Geography Data Type
BigQuery | Snowflake | Notes |
---|---|---|
Supported data type in Snowflake. For more information, please refer to the GEOGRAPHY data type documentation. |
Interval Data Type
BigQuery | Snowflake | Notes |
---|---|---|
INTERVAL data type is not supported in Snowflake. VARCHAR is used instead. For more information, please refer to the INTERVAL data type documentation. |
Json Data Type
JSON data type is not supported in Snowflake. VARIANT is used instead. For more information, please refer to the JSON data type documentation. |
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). | ||
BIGNUMERIC data type is not supported in Snowflake. NUMERIC is used instead. The precision and scale maximum was reduced to NUMBER(38,37). | ||
BIGNUMERIC data type is not supported in Snowflake. DECIMAL is used instead. The precision and scale maximum was reduced to NUMBER(38,37). | ||
FLOAT64 data type convert to FLOAT data type in Snowflake. Snowflake uses double-precision (64 bit) IEEE 754 floating-point numbers. |
String Data Types
Last updated