Snowflake on AWS data types
The Snowflake on AWS endpoint for Qlik Replicate supports most Snowflake data types. The following table shows the Snowflake on AWS target data types that are supported when using Qlik Replicate and the default mapping from Qlik Replicate data types.
Snowflake on AWS does not support applying changes to binary data types in Batch optimized apply mode. For more information on Batch optimized apply mode, see Change Processing Tuning.
For information on how to view the data type that is mapped from the source, see the section for the source database you are using. For additional information about Qlik Replicate data types, see Replicate data types.
Qlik Replicate Data Types | Snowflake on AWS Data Types |
---|---|
BOOL |
BOOLEAN |
BYTES |
If length is => 1 and =< 8388608, then: BINARY (Length in Bytes) If length is => 8388609 and =< 2147483647, then: BINARY (8388608) |
DATE |
DATE |
TIME |
TIME |
DATETIME |
TIMESTAMP (precision) |
INT1 |
NUMBER |
INT2 |
NUMBER |
INT4 |
NUMBER |
INT8 |
NUMBER |
NUMERIC |
If scale is => 0 and =< 37, then: NUMBER (p,s) If scale is => 38 and =< 127, then: NUMBER (Length) |
REAL4 |
FLOAT4 |
REAL8 |
FLOAT8 |
UINT1 |
BYTEINT |
UINT2 |
INTEGER |
UINT4 |
INTEGER |
UINT8 |
BIGINT |
STRING |
If length is => 1 and =< 16777216, then: VARCHAR (Length in Bytes) If length is => 16777217 and =< 2147483647, then: VARCHAR (16777216) If subtype is JSON or XML, then: VARIANT Information noteThe XML subtype is not supported when the Loading method in the endpoint settings is set to Snowpipe Streaming.
|
WSTRING |
If length is => 1 and =< 21845, then: VARCHAR (Length in Bytes) If length is => 21846 and =< 2147483647, then: VARCHAR (65535) If subtype is JSON or XML, then: VARIANT Information noteThe XML subtype is not supported when the Loading method in the endpoint settings is set to Snowpipe Streaming.
|
BLOB |
If length is => 1 and =< 8388608, then: BINARY (Length in Bytes) If length is => 8388609 and =< 2147483647, then: BINARY (8388608) |
NCLOB |
NVARCHAR (Max LOB Size) If subtype is JSON or XML, then: VARIANT Information noteThe XML subtype is not supported when the Loading method in the endpoint settings is set to Snowpipe Streaming.
|
CLOB |
VARCHAR (Max LOB Size) If subtype is JSON or XML, then: VARIANT Information noteThe XML subtype is not supported when the Loading method in the endpoint settings is set to Snowpipe Streaming.
|