Snowflake Requirements - DSS 6 | Data Source Solutions Documentation
Documentation: Snowflake Requirements - DSS 6 | Data Source Solutions Documentation
Snowflake Requirements
This section describes the requirements, access privileges, and other features of Data Source Solutions DSS when using Snowflake for replication.
Supported Platforms
- Learn about the Snowflake versions compatible with DSS on our Platform Support Matrix page (6.1.0, 6.1.5, 6.2.0, and 6.2.5).
Supported Capabilities
- Discover what DSS offers for Snowflake on our Capabilities for Snowflake page (6.1.0, 6.1.5, 6.2.0, and 6.2.5).
Data Management
-
Learn how DSS maps data types between source and target DBMSes or file systems on the Data Type Mapping page. For the list of the supported Snowflake data types and their mapping, see Data Type Mapping for Snowflake.
-
Understand the character encodings DSS supports for Snowflake on the Supported Character Encodings page.
Due to technical limitations, external staging on Azure for Snowflake is not supported in the DSS releases since 6.1.5/3 to 6.1.5/9.
ODBC Connection
DSS requires that the Snowflake ODBC driver is installed on the machine from which DSS connects to Snowflake. For more information on downloading and installing Snowflake ODBC driver, see Snowflake Documentation. For information about the supported ODBC driver version, refer to the DSS release notes (dss.rel) available in the DSS_HOME directory or the download page.
After installing the Snowflake ODBC driver, configure the LogLevel configuration parameter as specified in ODBC Configuration and Connection Parameters of the Snowflake Documentation.
Snowflake Authentication
DSS supports both username/password and certificate-based authentication for Snowflake.
For certificate-based authentication, Snowflake requires a Key Pair, which includes a private key (Database_Client_Private_Key) and password (Database_Client_Private_Key_Password). Steps to create a Key Pair are described in the Snowflake Documentation.