...
Storage ID
: Logical name of the storage connection.Storage type
: SNOWFLAKE (Snowflake transparent storage).Referenced storage
: Storage ID of Snowflake stage area for temporary file upload/download.Java connector RFC
: RFC Destination used for communication with JCo.Account name
: <account name>.<region>.<platform> (more information can be found in Snowflake account name doc).Warehouse
: Optional parameter, you can select the existing warehouse in the Snowflake account to be used.Database
: Name of an existing database in Snowflake.Database schema
: Name of an existing database schema in Snowflake.User role
: User's role used for data insertion.Driver path
: Snowflake driver directory.Hints
: Additional string added to connection string when JDBC driver establishes a connection.Connection pool size
: Number of connections that can be kept open in the pool, reducing resource-expensive establishment of JDBC connections.Table name prefix
: Optional text value for naming prefix of all Glue tables created within this storage.Wrap values in staged CSV files
: Depending on table content, it may be necessary to encapsulate field values to avoid errors during INSERT into the Snowflake table from staging CSV files.Data delivery guarantee
: Data transfer behavior. More information can be found in the chapter (SM-2308) Data Delivery Guarantee.
3.2.3 Snowpipe Streaming Storage (SNOWSTREAM)
...
Storage ID
: Logical name of the storage connection.Storage type
: SNOWSTREAM (Snowflake transparent storage - Streaming).Java connector RFC
: RFC Destination used for communication with JCo.Account name
: <account name>.<region>.<platform> (more information can be found in Snowflake account name doc).Warehouse
: Optional parameter, you can select the existing warehouse in the Snowflake account to be used.Database
: Name of an existing database in Snowflake.Database schema
: Name of an existing database schema in Snowflake.User role
: User's role used for data insertion.Driver path
: Snowflake driver directory. It’s required to include also Snowflake Ingest SDK jar file in this directory. The SDK is available for download from the Snowflake Maven Central Repository.Hints
: Additional string added to connection string when JDBC driver establishes a connection.Connection pool size
: Number of connections that can be kept open in the pool, reducing resource-expensive establishment of JDBC connections.Username
: Snowflake user.Private Key file location:
Path to Private Key file.Private Key Encrypted:
When enabled, a Password input field will be displayed.Password:
Password to Private key.Use Snowflake App for data merge:
When enabled, the SNP Native app will be used. Table name prefix
: Optional text value for naming prefix of all tables created within this storage.Data delivery guarantee
: Data transfer behavior. More information can be found in the chapter
...