Data Ingestion and Replication
- Data Ingestion and Replication
- All Products
Oracle Source Data Type | Databricks Delta Target Data Type |
---|---|
binary_double | double |
binary_float | float |
char(s byte), 1 <= s <= 2000 | string |
char(s char), 1 <= s <= 2000 | string |
date | timestamp |
float( precision ), 1 <= p <= 126 | string |
integer | string |
long raw | binary |
long(2147483648 byte) | string |
nchar(s char), 1 <= s <= 2000 | string |
number | string |
number(*,s), -84 <= s <= 127 | string |
number(p,s), 1 <= p <= 38, -37 <= s <= 38 | decimal(p,s), 1 <= p <= 38, 0 <= s <= 38 |
number(p,s), 1 <= p <= 38, -84 <= s <= 127 | string |
nvarchar2(s char), 1 <= s <= 4000 | string |
raw( size ), 1 <= s <= 4000 | binary |
rowid | string |
timestamp( precision ) with time zone, 0 <= p <= 6 | timestamp |
timestamp( precision ) with time zone, 7 <= p <= 9 | string |
timestamp( precision ), 1 <= p <= 6 | timestamp |
timestamp( precision ), 7 <= p <= 9 | string |
varchar2(s byte), 1 <= s <= 4000 | string |
varchar2(s char), 1 <= s <= 4000 | string |