Snowflake requirements - 7.3

Talend Change Data Capture Installation Guide

Version
7.3
Language
English
Product
Talend Change Data Capture
Module
Talend Change Data Capture
Content
Data Governance > Third-party systems > Database components (Integration) > Change Data Capture
Data Quality and Preparation > Third-party systems > Database components (Integration) > Change Data Capture
Design and Development > Third-party systems > Database components (Integration) > Change Data Capture
Last publication date
2023-10-05

This section covers the installation of the Snowflake driver, its application and its connector program (SnowSQL).

Before you begin

Make sure you know the directory destination path where Talend Change Data Capture files are installed. This path is called <DestinationPath> in the following steps.

About this task

Procedure

  1. Create an account on Snowflake.
  2. Download SnowSQL and Snowflake ODBC driver.
    Note: The SnowSQL installer and the ODBC driver can be downloaded from the Snowflake Client Repository. No authentication is required. This version of the SnowSQL installer enables auto-upgrade for patches.
  3. Launch the driver setup to install it.
  4. Create the DSN name:
    1. From the ODBC Data Source Administrator, click Add. Select the driver and click Finish.
    2. The Snowflake Configuration Dialog screen is displayed.
    Enter the following mandatory settings:
    • Server: address of the Snowflake account
    • Database: name of the target database created on Snowflake
    • Schema: name of the database schema created for the project
    • Warehouse: storage location of the buffer
    • Tracing: log level from 0 to 6
  5. Copy snowsql.exe file in <DestinationPath>\.snowsql\.
  6. Install Snowflake connector: after the installation of Talend Change Data Capture, launch the following command: <DestinationPath>\.snowsql\snow-update.cmd.
    The program will install the necessary .exe and .dll programs.
    Details about the batch files in .snowsql:
    • snow-version.cmd: to know the version of SnowSQL installed.
    • snow-version-available.cmd: to get the list of available versions.
    • snow-update.cmd: to install a xxxx version. Default version is 1.2.2. To change the version, edit the file and modify the version number.
    Note: If your target machine does not have an Internet connection:
    1. Copy the folder Talend Change Data Capture\.snowsql on a server connected to Internet and perform the updates with snow-update.cmd (\.snowsql\x.y.z is created).
    2. When the update has been done, copy the folder x.y.z on the Talend Change Data Capture server in <DestinationPath>\.snowsql\.