Database Ingestion and Replication > Default data-type mappings > Netezza Source and Databricks Target
  

Netezza Source and Databricks Target

The following table identifies the recommended data-type mappings for Database Ingestion and Replication configurations with a Netezza source and a Databricks target:
Netezza Source Data Type
Databricks Target Data Type
bigint
long
boolean
boolean
byteint
integer
char(size), 1 <= size <= 64000
string
date
string
double
double
integer
integer
interval
string
nchar(size), 1 <= size <= 16000
string
numeric(p,s), 1 <= p <= 38, 1 <= s <= 38
decimal(p,s), 1 <= p <= 38, 1 <= s <= 38
nvarchar(size), 1 <= size <= 16000
string
real
float
smallint
integer
st_geometry(precision), 1 <= p <= 63001
binary
time
string
timestamp
timestamp
timetz
string
varbinary(size), 1 <= size <= 64000
binary
varchar(size), 1 <= size <= 64000
string
Unsupported source data types
Database Ingestion and Replication does not support the following Netezza data type:
Note: Even though this data type appears in the default mappings, database ingestion and replication jobs either fail to deploy or propagate nulls for columns that have this data type.