Skip to main content

Setup ODBC Connection to Snowflake Reader Node

Distributor steps for setting up a Windows ODBC data source (DSN) for the Encompass Snowflake data warehouse reader node, for tools like Power BI. Needs the Snowflake ODBC driver, Setting 558 set by Encompass, v23.01+.

B
Written by Bailey Naas-Thornton

Minimum Version Required: 23.01

Pre-Conditions

Required Setup
​
​

Required Information
​
​

  • Data Warehouse Share Node Login Credentials
    ​
    ​

  • Data Warehouse Share Node URL
    ​
    ​

  • Data Warehouse Name (setup in Data Warehouse Share Node)
    ​
    ​

  • Data Warehouse Schema Name (usually "PUBLIC")
    ​
    ​

  • Data Warehouse Database Name (usually EncompassID + "Data"; CASE-SENSITIVE)

Steps

Step 1: Open ODBC Data Sources/Confirm Driver Installation
​
​

  1. A 32-bit and 64-bit version exists; Open the version that matches the Snowflake ODBC Driver installed
    ​
    ​

  2. Go to "Drivers" Tab
    ​
    ​

  3. Confirm "SnowflakeDSIIDriver" is in the list
    ​
    ​

If you do not see "SnowflakeDSIIDriver", try opening the other version of ODBC Data Sources and checking there. If you still do not see anything, refer to Pre-Condtions for installation.
​
​
​
​
​Step 2: Setup Data Source Name (DSN)
​
​

  1. Click User DSN or System DSN
    ​
    ​

  2. Click "Add..." Button
    ​
    ​

  3. Select "SnowflakeDSIIDriver" from the Driver List
    ​
    ​

  4. Fill in information
    ​
    ​

  5. Click the "OK" Button
    ​
    ​
    ​
    ​

Step 3: Test Connection
​
​

  1. Select the newly created DSN
    ​
    ​

  2. Click the "Configure" Button (if in DSN list)
    ​
    ​

  3. Click "Test..."
    ​
    ​

You can now find the new connection as available to connect to within 3rd Party Applications, such as Microsoft's Power BI.
​


​
`

Additional Resources

Snowflake - Installing and Configuring the ODBC Driver for Windows

*This template file is built by Encompass to streamline data setup in Power BI. For any inquiries or support around the Power BI and Snowflake tools, please reference the documentation provided by Microsoft and Snowflake.

Fields And Definitions

  • Setting 558 (Name for Data Warehouse Share Node): Share Node set by Encompass to allow access to the Data Warehouse by 3rd Party Applications
    ​
    ​

  • Data Warehouse Share Node Login Credentials: Username and Password to login to the Snowflake Reader Node; setup by admin of Data Warehouse Reader Node
    ​
    ​

  • Data Warehouse Share Node URL: URL to access the Data Warehouse Share Node; provided by Encompass after Setting 558 is set up
    ​
    ​

  • Data Warehouse Name: Name of the Warehouse in the Data Warehouse Share Node; this is setup by logging into the Data Warehouse Share Node directly by the admin
    ​
    ​

  • Data Warehouse Database Name: Name of the Database in the Data Warehouse Share Node within the selected Schema; usually EncompassID + "Data" (ex. TestDatabaseData)
    ​
    ​

  • Data Warehouse Schema: The Schema that contains the Database to access; usually is "PUBLIC"

Did this answer your question?