Snowflake data types

In Infor Stream Pipelines, tables are not created in the database automatically. When you create tables in Snowflake, the column names and data types must match the Data Fabric object properties of the corresponding objects that are used in Infor Stream Pipelines.

This table shows the object properties data types, as defined in Data Catalog, and their corresponding Snowflake data types:


Category	Data Catalog data type	Snowflake data type	Snowflake comment
Date and Time data types	Datetime: Standard American Three-character month	DATETIME	Alias for one of the TIMESTAMP variations. By default, TIMESTAMP_NTZ. TIMESTAMP_LTZ with the local time zone. The time zone, if provided, is not stored. TIMESTAMP_NTZ with no time zone. The time zone, if provided, is not stored. TIMESTAMP_TZ TIMESTAMP with the time zone.
	Datetime: Other	STRING
	Date: Standard American Basic	DATE
	Time: Other	STRING
	Time: Standard	TIME	By default, NTZ.
	Datetime: Epoch	NUMBER
Numeric data types	Number	NUMBER	Default precision and scale are (38,0). You can change precision.
	Number	FLOAT DOUBLE	Snowflake uses double-precision (64 bit) IEEE 754 floating-point numbers.
	Integer: Maximum: Less than 32767 Exclusive maximum: Less than 32768 Minimum: More than -32767 Exclusive minimum: More than -32768 Multiple of (number of digits)	NUMBER	Synonymous with NUMBER, but precision and scale cannot be specified.
	Integer: Maximum: Between 32767 and 2147483647 Exclusive maximum: Between 32768 and 2147483647 Minimum: Between -2147483647 and -32767 Exclusive minimum: Between -2147483648 and -32768 Multiple of (number of digits) None of the above is provided	NUMBER
	Integer: Maximum: More than 2147483647 Exclusive maximum: More than 2147483648 Minimum: Less than -2147483647 Exclusive minimum: Less than -2147483648 Multiple of (number of digits)	NUMBER
Logical data types	Boolean	BOOLEAN
	String	STRING	Synonymous with VARCHAR.
	Object	STRING

Note: Data Catalog object data types are supported for use with objects that have localized strings that are defined as part of the Data Catalog Locale Selections feature. Currently, Stream Pipelines processes only the first value of the object values. For example, if the localized value within the NDJSON record is {"desc": {"en_US":"Blue Car", "de_DE": "Blaues Auto", "es_ES": "Coche Azul"},, then only the first value, "Blue Car", is stored in the table column.

In Snowflake, there is a limitation for default column values. Default column values other than NULL are not supported by Snowflake's Snowpipe Streaming technology, which is used by Pipelines.