Snowflake Sources for Replication Flows
You can use Snowflake as a source connection in replication flows to replicate data into supported targets. This feature uses the Connectivity Framework and supports the Initial Only load type.
Prerequisites
-
Make sure you have created a Snowflake connection in Connection Management and that it is available in your space. For more information, see Snowflake Connections
-
Only standard tables with primary keys and hybrid tables are supported (Views are not supported). Ensure that the defined primary keys comply with Snowflake constraints to avoid replication flow failures. For more information, refer to the Snowflake documentation.
-
GCP regional endpoints are not supported.
-
Only the Initial Only load type is supported. Initial and Delta and Delta Only load types are not supported.
Replicating Source Objects Without Primary Keys
Replicating source objects without a primary key is not supported. Only source objects that have a primary key defined can be used as source objects in a replication flow.
Data Types
|
Snowflake Source |
SAP Datasphere |
|---|---|
|
ARRAY |
Not Supported |
|
BINARY |
varbinary(8388608) |
|
BINARY(n), 1<=n<=5000 |
binary(n) |
|
BINARY(n), n > 5000 |
varbinary(n) |
|
BOOLEAN |
bool |
|
BYTEINT |
varbinary(8,0) |
|
CHAR(n), 1<=n<=5000 |
string(n) |
|
CHAR VARYING(n), 1<=n<=5000 |
string(n) |
|
CHARACTER(n), 1<=n<=5000 |
string(n) |
|
CHARACTER VARYING(n), 1<=n<=5000 |
string(n) |
|
CLOB |
string |
|
DATE |
date |
|
DATETIME |
timestamp |
|
DECIMAL(p,s) |
varbinary(p,s) |
|
DOUBLE |
float64 |
|
DOUBLE PRECISION |
float64 |
|
FLOAT |
float64 |
|
FLOAT4 |
float32 |
|
FLOAT8 |
float64 |
|
GEOGRAPHY |
Not Supported |
|
GEOMETRY |
Not Supported |
|
INT |
varbinary(38,0) |
|
INTEGER |
varbinary(38,0) |
|
NCHAR(n), 1<=n<=5000 |
string(n) |
|
NCHAR VARYING(n), 1<=n<=5000 |
string(n) |
|
NUMBER |
varbinary(38,0) |
|
NUMBER(p,s) |
varbinary(p,s) |
|
NUMERIC(p,s) |
varbinary(p,s) |
|
NVARCHAR |
string |
|
NVARCHAR(n), 1<=n<=5000 |
string(n) |
|
NVARCHAR2(n), 1<=n<=5000 |
string(n) |
|
OBJECT |
Not Supported |
|
REAL |
float32 |
|
SMALLINT |
varbinary(38,0) |
|
STRING |
string |
|
STRING(n), 1<=n<=5000 |
string(n) |
|
STRING(n), n > 5000 |
Not Supported |
|
TEXT |
string |
|
TEXT(n), 1<=n<=5000 |
string(n) |
|
TEXT(n), n > 5000 |
Not Supported |
|
TIME |
time |
|
TIMESTAMP |
timestamp |
|
TIMESTAMP_LTZ |
timestamp |
|
TIMESTAMP_NTZ |
timestamp |
|
TIMESTAMP_TZ |
timestamp |
|
TINYINT |
varbinary(38,0) |
|
VARBINARY |
varbinary(8388608) |
|
VARBINARY(n), 1<=n<=5000 |
binary(n) |
|
VARBINARY(n), n > 5000 |
Not Supported |
|
VARCHAR |
string |
|
VARCHAR(n), 1<=n<=5000 |
string(n) |
|
VARCHAR(n), n > 5000 |
Not Supported |
|
VARCHAR2(n), 1<=n<=5000 |
string(n) |
|
VARIANT |
Not Supported |
|
VECTOR |
Not Supported |