...
JDBC protocol is used to connect to Snowflake. Snowflake JDBC driver needs to be manually copied to the operating system and accessible to the connector. Download Snowflake JDBC driver. The latest version of the Snowflake JDBC driver is recommended, except for the Snowpipe Streaming storage connection - the streaming scenario currently requires JDBC driver version 3.13.33 in combination with snowflake-ingest-sdk-2.0.x.jar.
It is recommended to store the drivers in a directory shared between application servers, organized in sub-directories to avoid possible conflicts (some customers connect to multiple different platforms/services).
It is recommended to store the drivers in a directory shared between application servers, organized in sub-directories to avoid possible conflicts (some customers connect to multiple different platforms/services).
The default directory used to store drivers needed for communication with remote storages/services is:
...
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.Use Transient tables: When enabled, only transient tables will be created on the storage.Use Snowflake App for data merge: When enabled, the /wiki/spaces/GLUE/pages/4275929102 will be used. Snowflake App name: Name of the existing Snowflake native App to be used.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-2311) Data Delivery Guarantee.
3.2.3 Snowpipe Streaming Storage (SNOWSTREAM)
...