Mass Ingestion

Back Next

SAP HANA Source and Databricks Delta Target

The following table identifies the recommended data-type mappings for Mass Ingestion Databases configurations with a SAP HANA source and a Databricks Delta target:

SAP HANA Source Data Type	Databricks Delta Target Data Type
alphanum(`precision`), 1 <= p <= 127	string
array	binary
bigint	long
binary(`size`), 1 <= s <= 2000	binary
boolean	boolean
char(`size`), 1 <= s <= 2000	string
date	string
decimal	string
decimal(p,s), 1 <= p <= 38, 0 <= s <= 38	decimal(p,s), 1 <= p <= 38, 0 <= s <= 38
double	double
float	double
integer	integer
nchar(`size`), 1 <= s <= 2000	string
nvarchar(`size`), 1 <= s <= 5000	string
real	float
real	float
seconddate	timestamp
shorttext(`precision`), 1 <= p <= 5000	string
smalldecimal	string
smallint	integer
st_geometry	binary
st_point	binary
time	string
timestamp	string
timestamp	timestamp
tinyint	integer
varbinary(`size`), 1 <= s <= 5000	binary
varchar(`size`), 1 <= s <= 5000	string