SAP HANA Source and Databricks Target

The following table identifies the recommended data-type mappings for Database Ingestion and Replication configurations with an SAP HANA or SAP HANA Cloud source and a Databricks target:

SAP HANA Source Data Type	Databricks Target Data Type
alphanum(precision), 1 <= p <= 127	string
array	binary
bigint	long
binary(size), 1 <= size <= 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 <= size <= 2000	string
nvarchar(size), 1 <= size <= 5000	string
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 <= size <= 5000	binary
varchar(size), 1 <= size <= 5000	string