Db2 for LUW Source Data Type | Snowflake Target Data Type |
|---|---|
bigint | integer |
binary(size), 1 <= size <= 255 | binary(size), 1 <= size <= 255 |
blob | binary(size), 1 <= size <= max |
boolean | boolean |
char for bit data | binary(1) |
char(size) for bit data, 2 <= size <= 255 | binary(size), 2 <= size <= 255 |
character(size), 1 <= size <= 255 | char(size), 4 <= size <= 1020 |
clob | varchar( size ), 4 <= size <= max |
date | date |
dbclob | varchar( size ), 4 <= size <= max |
decfloat(precision), 16 <= p <= 34 | char(255) |
decimal(p,s), 1 <= p <= 31, 0 <= s <= 31 | number(p,s), 1 <= p <= 31, 0 <= s <= 31 |
double | float |
integer | integer |
long varchar | varchar(size), 4 <= size <= 130800 |
long varchar for bit data | binary(size), 1 <= size <= 32700 |
long vargraphic | varchar( size ), 4 <= size <= 65400 |
real | float |
smallint | integer |
time | time(0) |
timestamp(precision), 0 <= p <= 9 | timestamp_ntz(precision), 0 <= p <= 9 |
timestamp(precision), 10 <= p <= 12 | char(size), 30 <= size <= 32 |
varbinary(size), 1 <= size <= 32672 | binary(size), 1 <= size <= 32672 |
varchar(size) for bit data, 1 <= size <= 32672 | binary(size), 1 <= size <= 32672 |
varchar(size), 1 <= size <= 32672 | varchar(size), 4 <= size <= 130688 |
xml | varchar(size), 4 <= size <= max |