# Supported Snowflake data types

The following table shows the Snowflake target data types that are supported when using Qlik Replicate and the default mapping from Qlik Replicate data types.

Information note

The INT , INTEGER , BIGINT , SMALLINT , TINYINT , BYTEINT data types will always be represented as NUMBER(38, 0) on Snowflake. For more information, see the [Snowflake Help](https://docs.snowflake.com/en/sql-reference/data-types-numeric.html#int-integer-bigint-smallint-tinyint-byteint).

For information on how to view the data type that is mapped from the source, see the section for the source endpoint you are using. For additional information about Qlik Replicate data types, see [Replicate data types](https://help.qlik.com/en-US/replicate/May2026/Content/Replicate/Main/Endpoints/att_rep_data_types.htm).

Replicate and Snowflake data types

| Qlik Replicate data types | Snowflake data types |
| --- | --- |
| BOOL | BOOLEAN |
| BYTES | If length is =&gt; 1 and =&lt; 8388608, then:<br><br>BINARY (Length in Bytes)<br><br>If length is =&gt; 8388609 and =&lt; 2147483647, then:<br><br>BINARY (8388608) |
| DATE | DATE |
| TIME | TIME |
| DATETIME | TIMESTAMP (precision) |
| INT1 | NUMBER |
| INT2 | NUMBER |
| INT4 | NUMBER |
| INT8 | NUMBER |
| NUMERIC | If scale is =&gt; 0 and =&lt; 37, then:<br><br>NUMBER (p,s)<br><br>If scale is =&gt; 38 and =&lt; 127, then:<br><br>NUMBER (Length) |
| REAL4 | FLOAT4 |
| REAL8 | FLOAT8 |
| UINT1 | BYTEINT |
| UINT2 | INTEGER |
| UINT4 | INTEGER |
| UINT8 | BIGINT |
| STRING | If length is =&gt; 1 and =&lt; 16777216, then:<br><br>VARCHAR (Length in Bytes)<br><br>If length is =&gt; 16777217 and =&lt; 2147483647, then:<br><br>VARCHAR (16777216)<br><br>If subtype is JSON or XML, then:<br><br>VARIANT<br><br>Information noteThe XML subtype is not supported when the Loading method in the endpoint settings is set to Snowpipe Streaming. |
| WSTRING | If length is =&gt; 1 and =&lt; 21845, then:<br><br>VARCHAR (Length in Bytes)<br><br>If length is =&gt; 21846 and =&lt; 2147483647, then:<br><br>VARCHAR (16777216)<br><br>If subtype is JSON or XML, then:<br><br>VARIANT<br><br>Information noteThe XML subtype is not supported when the Loading method in the endpoint settings is set to Snowpipe Streaming. |
| BLOB | BINARY (8388608) |
| NCLOB | NVARCHAR (16777216)<br><br>If subtype is JSON or XML, then:<br><br>VARIANT<br><br>Information noteThe XML subtype is not supported when the Loading method in the endpoint settings is set to Snowpipe Streaming. |
| CLOB | VARCHAR (16777216)<br><br>If subtype is JSON or XML, then:<br><br>VARIANT<br><br>Information noteThe XML subtype is not supported when the Loading method in the endpoint settings is set to Snowpipe Streaming. |

Information noteFull LOB data types are not supported. For information on including Limited-size LOB data types in the replication, see the [Metadata](https://help.qlik.com/en-US/replicate/May2026/Content/Global_Common/Content/SharedEMReplicate/Customize%20Tasks/tasks_metadata.htm) tab description in [Customizing tasks](https://help.qlik.com/en-US/replicate/May2026/Content/Global_Common/Content/SharedEMReplicate/Customize%20Tasks/cust_tasks.htm).