Supported data types
The Amazon Redshift database for Qlik Replicate supports most Amazon Redshift data types. The following table shows the Amazon Redshift target data types that are supported when using Qlik Replicate and the default mapping from Qlik Replicate data types.
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 ReplicateData Types | Amazon Redshift Data Types |
|---|---|
|
BOOLEAN |
BOOL |
|
BYTES |
VARCHAR (Length) |
|
DATE |
DATE |
|
TIME |
VARCHAR(20) |
|
DATETIME |
If scale is => 0 and =< 6, then: TIMESTAMP (s) If scale is => 7 and =< 12, then: VARCHAR (37) |
|
INT1 |
INT2 |
|
INT2 |
INT2 |
|
INT4 |
INT4 |
|
INT8 |
INT8 |
|
NUMERIC |
If scale is => 0 and =< 37, then: NUMERIC (p,s) If scale is => 38 and =< 127, then: VARCHAR (Length) |
|
REAL4 |
FLOAT4 |
|
REAL8 |
FLOAT8 |
|
STRING |
If length is => 1 and =< 65535, then: VARCHAR (Length in Bytes) If length is => 65535 and =< 2147483647, then: VARCHAR (65535) |
|
UINT1 |
INT2 |
|
UINT2 |
INT4 |
|
UINT4 |
INT8 |
|
UINT8 |
NUMERIC (20,0) |
|
WSTRING |
If length is => 1 and =< 65535, then: NVARCHAR (Length in Bytes) If length is => 65536 and =< 2147483647, then: NVARCHAR (65535) |
|
BLOB |
VARCHAR (Max LOB Size *2) Information note
The maximum LOB size in the Metadata tab cannot exceed 31 KB. |
|
NCLOB |
NVARCHAR (Max LOB Size) Information note
The maximum LOB size in the Metadata tab cannot exceed 63 KB. |
|
CLOB |
VARCHAR (Max LOB Size) Information note
The maximum LOB size in the Metadata tab cannot exceed 63 KB. |
About Amazon Redshift LOB support:
Full LOB data types are not supported. For information on including Limited-size LOB data types in the replication, see the Metadata tab description in Customizing tasks .