Connecting to Snowflake Database

RT Designer supports connection with the Snowflake databases, which are available at a cloud resource, such as AWS Cloud, Google Cloud, and Microsoft Azure.

To connect RT Designer with your Snowflake database, you must first configure the Snowflake on your windows machine.

Prerequisites

Before you begin, make sure that following prerequisites are adhered to.

  • Operating System - For a list of the operating systems supported by Snowflake clients, see Operating System Support.

  • Administrator privileges to install the ODBC driver.

  • Visual C++ Redistributable for Visual Studio 2015 is installed on windows machine.

Install and Configure Snowflake ODBC Driver

  1. Download the Snowflake ODBC driver and install it. Install the applicable ODBC driver, as given below:

    • snowflake64_odbc-<version>.msi

    • snowflake32_odbc-<version>.msi

  2. Configure the Snowflake ODBC driver

    1. On your windows machine, launch the ODBC Data Source Administrator tool.

    2. Select Drivers tab. Make sure that Snowflake driver is listed.

      If not listed, Snowflake ODBC driver was not installed successfully. Install the Snowflake ODBC driver again.

    3. Select User DSN tab and click Add....

    4. Select SnowflakeDSIIDriver from the list and click Finish.

    5. In the Snowflake Configuration Dialog, enter these details:

      • Data Source - Name of the Snowflake data source

      • User/Password - User name and password for connecting to the server. The Password field accepts a value, but does not store the value in the driver.

      • Server - FQDN of the target server

      • Database - Name of the Snowflake database

    6. To verify the connection with the provided data source, click Test. A dialog box with success message, as shown in the sample below, appears. Click OK.

    7. On Snowflake Configuration Dialog, click OK.

    8. On the ODBC Data Source Administrator tool, a new User DSN is created.

  3. Create a New Local Connection in RT Designer.

    1. Open RT Designer and navigate to Physical Objects > Database.

    2. Click Add New Connection and select Add Local Connection.

    3. Click the Data Base Provider drop-down and select ODBC.

    4. Under Data Source Specification, select Use user or system data source name option.

    5. Click the drop-down and select the listed snowflake DSN.

      If you do not see the required DSN, click Refresh and try again.

    6. Under Login Information, enter the username and password for the snowflake data source and click Test.

      Make sure that the test is successful.

    7. Create a New Local Command and run a query to check that the required data from the data table is fetched.