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

SAP HANA Source and Snowflake Target

SAP HANA Source and Snowflake Target

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

0 COMMENTS

We’d like to hear from you!