Supported data types
The following table shows the Google Cloud BigQuery database 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 Replicate Data Types | Google Cloud BigQuery database data types |
|---|---|
|
BYTES |
BYTES |
|
DATE |
DATE |
|
TIME |
TIME |
|
DATETIME |
If fraction <=6: TIMESTAMP If fraction >6: STRING |
|
INT1 |
INT64 |
|
INT2 |
IINT64 |
|
INT4 |
INT64 |
|
INT8 |
INT64 |
|
NUMERIC |
Scale between 0-9: NUMERIC If not, then: BIGNUMERIC |
|
REAL4 |
FLOAT64 |
|
REAL8 |
FLOAT64 |
|
STRING |
STRING If subtype is JSON, then: JSON |
|
UINT1 |
INT64 |
|
UINT2 |
INT64 |
|
UINT4 |
INT64 |
|
UINT8 |
INT64 |
|
WSTRING |
STRING If subtype is JSON, then: JSON |
|
BLOB |
BYTES |
|
NCLOB |
STRING If subtype is JSON, then: JSON |
|
CLOB |
STRING If subtype is JSON, then: JSON |
|
BOOLEAN |
BOOL |