Data Ingestion and Replication
- Data Ingestion and Replication
- All Products
PostgreSQL Source Data Type | Databricks Delta Target Data Type |
---|---|
bigint | long |
bit varying( precision ), 1 <= p <= 83700001 | binary |
bit( precision ), 1 <= p <= 83886080 | binary |
boolean | boolean |
box | binary |
character varying( size ), 1 <= s <= 10485760 | string |
character( size ), 1 <= s <= 10485760 | string |
cidr | string |
circle | binary |
date | string |
daterange | string |
double precision | double |
inet | string |
int4range | string |
int8range | string |
integer | integer |
line | binary |
lseg | binary |
macaddr | string |
macaddr8 | string |
money | decimal(19,2) |
numeric(p,s), 1 <= p <= 38, 0 <= s <= 38 | decimal(p,s), 1 <= p <= 38, 0 <= s <= 38 |
numeric(p,s), 39 <= p <= 999, 39 <= s <= 998 | string |
numrange | string |
path | binary |
point | binary |
polygon | binary |
real | float |
smallint | integer |
time( precision ) with time zone, 0 <= p <= 6 | string |
time( precision ) without time zone, 0 <= p <= 6 | string |
timestamp( precision ) with time zone, 0 <= p <= 6 | timestamp |
timestamp( precision ) without time zone, 0 <= p <= 6 | timestamp |
tsrange | string |
tstzrange | string |
uuid | string |