Data Ingestion and Replication
- Data Ingestion and Replication
- All Products
SAP HANA Source Data Type
| Snowflake Target Data Type
|
---|---|
alphanum( precision ), 1 <= p <= 127
| char( size ), 1 <= s <= 127
|
array
| binary
|
bigint
| integer
|
binary( size ), 1 <= s <= 2000
| binary( size ), 1 <= s <= 2000
|
boolean
| boolean
|
char( size ), 1 <= s <= 2000
| char( size ), 1 <= s <= 2000
|
date
| date
|
decimal
| char(255)
|
decimal(38,38)
| char(41)
|
decimal(p,s), 1 <= p <= 38, 0 <= s <= 37
| number(p,s), 1 <= p <= 38, 0 <= s <= 37
|
double
| float
|
float
| float
|
integer
| integer
|
nchar( size ), 1 <= s <= 2000
| char( size ), 4 <= s <= 8000
|
nvarchar( size ), 1 <= s <= 5000
| varchar( size ), 4 <= s <= 20000
|
real
| float
|
real
| float
|
seconddate
| timestamp_ntz(0)
|
shorttext( precision ), 1 <= p <= 5000
| varchar( size ), 1 <= s <= 5000
|
smalldecimal
| char(255)
|
smallint
| integer
|
st_geometry
| binary
|
st_point
| binary
|
time
| time(0)
|
timestamp
| timestamp_ntz( precision ), 0 <= p <= 7
|
tinyint
| integer
|
varbinary( size ), 1 <= s <= 5000
| binary( size ), 1 <= s <= 5000
|
varchar( size ), 1 <= s <= 5000
| varchar( size ), 1 <= s <= 5000
|