Data Ingestion and Replication
- Data Ingestion and Replication
- All Products
ASK INFAPreview
Please log in to access Ask INFA.
ASK INFAPreview
Cannot serve request to /content/informaticadita-com/en_us/integration-cloud/cloud-mass-ingestion/current-version/_mass-ingestion_cloud-mass-ingestion_current-version_ditamap/mass_ingestion_databases/default_data_type_mappings/postgresql_source_and_databricks_delta_target/_jcr_content/header/menupage.nocache.html/informaticadita-com/components/content/menu-hover on this server
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 |
