Data Warehouse
  • Data Warehouse
  • Provisioning User Accounts
  • Updating a User Account Password
  • Deactivating a User Account
  • Accessing Data
  • Creating a Data Share
  • Credentials for external services
  • Enabling MFA on Snowflake
  • Using the Snowflake ODBC Driver
  • IP Whitelisting/Network
Powered by GitBook
On this page
  • MFA Configuration to support second factor tokens
  • Excel
  • PowerBI

Was this helpful?

Using the Snowflake ODBC Driver

PreviousEnabling MFA on SnowflakeNextIP Whitelisting/Network

Last updated 11 months ago

Was this helpful?

Once MFA has been enabled on the account being used in the connection string, review the '' steps below.

  • First step is to download and follow the instructions for installing the .

  • Open your 'ODBC Data Source Administrator' panel: From the start menu, search for ‘ODBC Data Sources’:

  • On the ‘User DSN’ tab, click ‘Add’:

  • Select ‘Snowflake DSIIDriver’:

  • Click ‘Finish’ and you’ll be presented with the following fields to complete:

  • Data Source: Reapit Snowflake ODBC

  • Role: PUBLIC

MFA Configuration to support second factor tokens

If you have MFA configured against the account you are connecting with, optionally set the Authenticator parameter in the ODBC configuration as below. This will cache the second factor tokens for a maximum of four hours, to reduce the number of prompts received when using these accounts in external applications like PowerBI.

  • Authenticator: USERNAME_PASSWORD_MFA

Example configuration completed:

  • Click ‘Test’ to verify the connection. This will prompt a notification to ‘DUO Mobile’ which you’ll need to approve.

When the connection is confirmed, you’ll see a screen similar to the following:

Now the Snowflake Driver has been configured, you will need to reconfigure your applications to use the new data source.

Excel

  • Select the ‘Data’ tab > Select ‘Get Data’ > Select ‘From Other Sources’ > Select ‘From ODBC’ > Select ‘Reapit Snowflake ODBC’ > Click ‘Ok’:

  • Enter your Username & Password’ > Click ‘Connect’:

PowerBI

  • Select ‘Get Data from Other Sources’ > Search ‘ODBC’ > Click 'Connect':

  • Select ‘Reapit Snowflake ODBC’ > Click 'OK':

  • Enter your Username & Password’ > Click ‘Connect’:

User: Your Username (as setup in the )

Password: Your Password (as set in the )

Server: The server information is the URL which is provided in the under ‘Data Shares’ > ‘Copy URL’. For example, ‘XXXXXXX.eu-west-2.aws.snowflakecomputing.com’.

Database: The ‘Database’ can be retrieved from the under ‘Data Shares’ and is dependent on which schema you are using. In the example below for the ‘Analytics Schema’, it would be ‘REAPIT’:

Schema: The schema can be retrieved from the under ‘Data Shares’ and is dependent on which schema you are using. In the example below for the 'Analytics Schema', it would be ‘ANALYTICS_RES’:

Warehouse: The Warehouse can be retrieved from the under ‘Data Shares’ and is dependent on which schema you are using. In the example below for the Analytics Schema, it would be ‘STANDARD_WH’:

Data Warehouse App
DataWarehouse App
Data Warehouse app
Data Warehouse app
Data Warehouse app
Data Warehouse app
Snowflake ODBC driver
MFA Configuration to support second factor tokens