Data Ingestion and Replication
- Data Ingestion and Replication
- All Products
ASK INFAPreview
Please log in to access Ask INFA.
ASK INFAPreview
Netezza Source Data Type | Amazon Redshift Target Data Type |
|---|---|
bigint | bigint |
boolean | boolean |
byteint | smallint |
char( size ), 1 <= s <= 4096 | character( size ), 1 <= s <= 4096 |
char( size ), 4097 <= s <= 64000 | character varying( size ), 4097 <= s <= 64000 |
date | date |
double | double precision |
integer | integer |
interval | character varying(55) |
nchar( size ), 1 <= s <= 16000 | character varying( size ), 4 <= s <= 64000 |
numeric(38,38) | character varying(41) |
numeric( precision ), 1 <= p <= 38 | numeric(p,1), 38 <= p <= 0 |
numeric(p,s), 1 <= p <= 38, 1 <= s <= 37 | numeric(p,s), 1 <= p <= 38, 1 <= s <= 37 |
nvarchar( size ), 1 <= s <= 16000 | character varying( size ), 4 <= s <= 64000 |
real | real |
smallint | smallint |
st_geometry( precision ), 1 <= p <= 63001 | character varying( size ), 2 <= s <= 65535 |
time | time without time zone |
timestamp | timestamp without time zone |
timetz | time with time zone |
varbinary( size ), 1 <= s <= 64000 | character varying( size ), 2 <= s <= 65535 |
varchar( size ), 1 <= s <= 64000 | character varying( size ), 1 <= s <= 64000 |
