Hi, I'm Ask INFA!
What would you like to know?
ASK INFAPreview
Please to access Bolo.

Table of Contents

Search

  1. Introducing Mass Ingestion
  2. Getting Started with Mass Ingestion
  3. Connectors and Connections
  4. Mass Ingestion Applications
  5. Mass Ingestion Databases
  6. Mass Ingestion Files
  7. Mass Ingestion Streaming
  8. Monitoring Mass Ingestion Jobs
  9. Asset Management
  10. Troubleshooting

Mass Ingestion

Mass Ingestion

PostgreSQL Source and Databricks Delta Target

PostgreSQL Source and Databricks Delta Target

The following table identifies the recommended data-type mappings for Mass Ingestion Databases configurations with a PostgreSQL source and a Databricks Delta target:
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

0 COMMENTS

We’d like to hear from you!