Data Ingestion and Replication
- Data Ingestion and Replication
- All Products
ASK INFAPreview
Please log in to access Bolo.
ASK INFAPreview
Netezza Source Data Type | Snowflake Target Data Type |
|---|---|
bigint | integer |
boolean | boolean |
byteint | integer |
char( size ), 1 <= s <= 64000 | char( size ), 1 <= s <= 64000 |
date | date |
double | float |
integer | integer |
interval | varchar(55) |
nchar( size ), 1 <= s <= 16000 | char( size ), 4 <= s <= 64000 |
numeric(38,38) | char(41) |
numeric( precision ), 1 <= p <= 38 | integer |
numeric(p,s), 1 <= p <= 38, 1 <= s <= 37 | number(p,s), 1 <= p <= 38, 1 <= s <= 37 |
nvarchar( size ), 1 <= s <= 16000 | varchar( size ), 4 <= s <= 64000 |
real | float |
smallint | integer |
st_geometry( precision ), 1 <= p <= 63001 | binary( size ), 1 <= s <= 63001 |
time | time(6) |
timestamp | timestamp_ntz(6) |
timetz | timestamp_tz(6) |
varbinary( size ), 1 <= s <= 64000 | binary( size ), 1 <= s <= 64000 |
varchar( size ), 1 <= s <= 64000 | varchar( size ), 1 <= s <= 64000 |
