Data Ingestion and Replication
- Data Ingestion and Replication
- All Products
ASK INFAPreview
Please log in to access Bolo.
ASK INFAPreview
Oracle Source Data Type | Snowflake Target Data Type |
|---|---|
binary_double | float |
binary_float | float |
char(s byte), 1 <= s <= 2000 | char( size ), 4 <= s <= 2000 |
char(s char), 1 <= s <= 2000 | char( size ), 4 <= s <= 8000 |
date | timestamp_ntz(0) |
float( precision ), 1 <= p <= 126 | char(255) |
integer | char(255) |
long raw | binary |
long(2147483648 byte) | char(16777216) |
nchar(s char), 1 <= s <= 2000 | char( size ), 4 <= s <= 8000 |
number | char(255) |
number(*,s), -84 <= s <= 127 | char(255) |
number(p,s), 1 <= p <= 38, -37 <= s <= 37 | number(p,s), 1 <= p <= 38, 0 <= s <= 37 |
number(p,s), 1 <= p <= 38, -84 <= s <= 127 | char( size ), 40 <= s <= 130 |
nvarchar2(s char), 1 <= s <= 4000 | char( size ), 4 <= s <= 16000 |
raw( size ), 1 <= s <= 4000 | binary( size ), 1 <= s <= 4000 |
rowid | varchar(18) |
timestamp( precision ) with time zone, 0 <= p <= 9 | timestamp_tz( precision ), 0 <= p <= 9 |
timestamp( precision ), 1 <= p <= 9 | timestamp_ntz( precision ), 1 <= p <= 9 |
varchar2(s byte), 1 <= s <= 4000 | varchar( size ), 4 <= s <= 4000 |
varchar2(s char), 1 <= s <= 4000 | varchar( size ), 4 <= s <= 16000 |
