10.3.3 Snowflake

• About Snowflake Connections
  
• Before You Begin
  
• Create and Validate an Snowflake Connection
  
• Use a Snowflake Connection in Replicat
  

10.3.3.1 About Snowflake Connections

A Snowflake connection stores the information that Oracle GoldenGate for DAA uses to connect to a Snowflake account.

You can use the connection with Extract to capture transactional changes from Snowflake as a source and with Replicat to deliver transactional changes to Snowflake as a target. After you create and validate the connection, you can reuse it across multiple Oracle GoldenGate for DAA processes.

The connection stores the Snowflake account information, authentication settings, and optional runtime settings independently of the process configuration.

10.3.3.2 Before You Begin

Before creating a Snowflake connection, ensure that you have the following:

• An Oracle GoldenGate for Distributed Applications and Analytics deployment.
• Network connectivity between the Oracle GoldenGate for Distributed Applications and Analytics deployment and the Snowflake account.
• The Snowflake account identifier.
• The Snowflake warehouse.
• The Snowflake database.
• The Snowflake role.
• A Snowflake user configured for key pair authentication.
• A private key associated with the Snowflake user.
• The private key password, if the private key is encrypted.
• The required Snowflake JDBC driver. For instructions on downloading the supported JDBC driver and required dependencies, see Dependency Downloader for Snowflake.
• Common runtime settings, such as the runtime classpath, configured to reference the downloaded JDBC driver.
• Proxy information if the Oracle GoldenGate for Distributed Applications and Analytics deployment accesses Snowflake through an HTTP proxy.

10.3.3.3 Create and Validate an Snowflake Connection

Use the Add Connection page to create a Snowflake connection.

Procedure

1. In the navigation menu, select DB Connections.
2. Click Add Connection.
3. In Connection Alias, enter a unique name for the connection.
4. From Technology Type, select Snowflake.
5. In the Technology Settings section, provide the Snowflake connection information.

   Configure the following technology settings:

   • Account Code – Specifies the Snowflake account identifier used to establish the connection. This field is required.
   • Warehouse – Specifies the Snowflake virtual warehouse used for the connection. This field is required.
   • User Role – Specifies the Snowflake role used during the session. This field is required.
   • Database – Specifies the target Snowflake database. This field is required.
   • Schema – Specifies the default Snowflake schema. This field is optional.
6. Configure the Authentication Settings section.

   Configure the following authentication settings:

   • Authentication Type – Specifies the authentication method. The supported value is KEY_PAIR. This field is required.
   • Username – Specifies the Snowflake user name used for key pair authentication. Required when Authentication Type is KEY_PAIR.
   • Private Key – Specifies the private key associated with the Snowflake user. This field is required for key pair authentication and is treated as sensitive information.
   • Private Key Password – Specifies the password protecting the private key, when the uploaded private key is encrypted.

   Note:

   This connection supports key pair authentication only.
7. Configure Common Settings if additional runtime configuration is required.

   Classpath: (Required) Specify the full path to client libraries are required by the replicat type. You can use Dependency Downloader to download client libraries.

8. (Optional) Configure Proxy Settings if the Oracle GoldenGate for Distributed Applications and Analytics deployment accesses Snowflake through an HTTP proxy.
   • Proxy URL – Specifies the URL or host name of the proxy server used to access Snowflake.
   • Proxy Port – Specifies the port number of the proxy server.
   • Proxy Username – Specifies the user name for proxy authentication, if required.
   • Proxy Password – Specifies the password for proxy authentication. This field is treated as sensitive information.
   • Truststore – Specifies the Java truststore file that contains the certificate authority (CA) certificates used to validate the proxy server certificate, when required.
   • Truststore Password – Specifies the password associated with the truststore.
   • Keystore – Specifies the Java keystore file containing the client certificate and private key used for client authentication, when required.
   • Keystore Password – Specifies the password associated with the keystore.
   • SSL Key Password – Specifies the password protecting the private key stored in the keystore when it differs from the keystore password.

   Note:

   If Oracle GoldenGate for Distributed Applications and Analytics has direct network connectivity to the Snowflake account, leave the Proxy Settings blank.
9. Click Submit.
10. On the DB Connections page, click DB Login to validate the connection.

    Note:

    A successful DB Login validates only the saved connection information. It does not validate the Extract or Replicat configuration. After successful validation, the connection is available for selection during Extract or Replicat creation.

10.3.3.4 Use a Snowflake Connection in Replicat

After the Snowflake connection has been successfully validated:

1. Create or edit an Extract or Replicat.
2. Select Snowflake as the source or target technology, as applicable.
3. Select the validated Snowflake connection.
4. Complete the remaining process configuration.
5. Create and start the Extract or Replicat.