> For the complete documentation index, see [llms.txt](https://datawarehouse-foundations.reapit.cloud/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://datawarehouse-foundations.reapit.cloud/using-the-snowflake-odbc-driver.md).

# Using the Snowflake ODBC Driver

{% hint style="info" %}
Once MFA has been enabled on the account being used in the connection string, review the '[MFA Configuration to support second factor tokens](#mfa-configuration-to-support-second-factor-tokens)' steps below.
{% endhint %}

* First step is to download and follow the instructions for installing the [Snowflake ODBC driver](https://developers.snowflake.com/odbc/).
* Open your 'ODBC Data Source Administrator' panel: From the start menu, search for ‘ODBC Data Sources’: 

<figure><img src="https://3632868340-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MklUh4JWyjd6jJi6Rvm%2Fuploads%2FglNbXopTPpJD5Qc2aZz1%2Fimage.png?alt=media&amp;token=586e1ba1-fa93-4fa3-a401-52c3dad3b59d" alt=""><figcaption></figcaption></figure>

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

<figure><img src="https://3632868340-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MklUh4JWyjd6jJi6Rvm%2Fuploads%2F4x3H1wXnHQJqIFLCUkAn%2FDWH1.png?alt=media&amp;token=411f1139-a7e9-488b-a606-8cad41adb063" alt=""><figcaption></figcaption></figure>

* Select ‘Snowflake DSIIDriver’:

<figure><img src="https://3632868340-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MklUh4JWyjd6jJi6Rvm%2Fuploads%2F1UajLaiwDWNXZnkDMcQS%2FDWH2.png?alt=media&amp;token=dacf2460-362a-4913-9408-c7f60d5b74ea" alt=""><figcaption></figcaption></figure>

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

<figure><img src="https://3632868340-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MklUh4JWyjd6jJi6Rvm%2Fuploads%2FjuafLcH3xHkNybNkqLT1%2FDWH3.png?alt=media&amp;token=9381497f-3be1-4a78-98de-9e6845e11e67" alt=""><figcaption></figcaption></figure>

* **Data Source**: Reapit Snowflake ODBC
* **User**: Your Username (as setup in the [Data Warehouse App](https://data-warehouse-app.reapit.cloud/user-accounts))
* **Password**: Your Password (as set in the [DataWarehouse App](https://data-warehouse-app.reapit.cloud/user-accounts))
* **Server**: The server information is the URL which is provided in the [Data Warehouse app](https://data-warehouse-app.reapit.cloud/data) under ‘Data Shares’ > ‘Copy URL’. For example, ‘XXXXXXX.eu-west-2.aws.snowflakecomputing.com’.

<figure><img src="https://3632868340-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MklUh4JWyjd6jJi6Rvm%2Fuploads%2Fuw3JQKWTbHDrgvHvmBjR%2FDWH123.jpg?alt=media&amp;token=e7856516-5ce3-48d3-a4d6-31b817171146" alt=""><figcaption></figcaption></figure>

* **Database**: The ‘Database’ can be retrieved from the [Data Warehouse app](https://data-warehouse-app.reapit.cloud/data) under ‘Data Shares’ and is dependent on which schema you are using. In the example below for the ‘Analytics Schema’, it would be ‘REAPIT’: &#x20;

<figure><img src="https://3632868340-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MklUh4JWyjd6jJi6Rvm%2Fuploads%2FBItkiAYVy08kn1UzhGFs%2FDWH4.jpg?alt=media&amp;token=e49256d3-7856-41c9-a6db-dc86275c563b" alt=""><figcaption></figcaption></figure>

&#x20;

* **Schema**: The schema can be retrieved from the [Data Warehouse app](https://data-warehouse-app.reapit.cloud/data) 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’: &#x20;

<figure><img src="https://3632868340-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MklUh4JWyjd6jJi6Rvm%2Fuploads%2FvMCYTQnjCw1gwniuC9so%2FDWH5.jpg?alt=media&amp;token=02bf07b5-60fa-4dda-a7de-404cffe4dc88" alt=""><figcaption></figcaption></figure>

* **Warehouse**: The Warehouse can be retrieved from the [Data Warehouse app](https://data-warehouse-app.reapit.cloud/data) 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’: &#x20;

<figure><img src="https://3632868340-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MklUh4JWyjd6jJi6Rvm%2Fuploads%2FFDHkcX1BJ6Ds84B3kTaR%2FDWH6.jpg?alt=media&amp;token=a438ce9b-1f3a-4709-9590-550db359ed92" alt=""><figcaption></figcaption></figure>

* **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&#x20;

**Example configuration completed:**

<figure><img src="https://3632868340-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MklUh4JWyjd6jJi6Rvm%2Fuploads%2FcQWCs1Ic1HHAXtuTV2fN%2FDWH15.png?alt=media&amp;token=89123d96-b079-4662-a457-d94120bc35c6" alt=""><figcaption></figcaption></figure>

* 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:

<figure><img src="https://3632868340-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MklUh4JWyjd6jJi6Rvm%2Fuploads%2FToFAF2pF0R1D8BbVd4qu%2FDWH8.png?alt=media&amp;token=414a6416-eb22-420c-a88a-cb20814a6668" alt=""><figcaption></figcaption></figure>

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

### Excel&#x20;

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

<figure><img src="https://3632868340-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MklUh4JWyjd6jJi6Rvm%2Fuploads%2FUK70yt5aCnCvDtvQcREF%2FDWH9.png?alt=media&amp;token=00f1bee8-65a1-48bb-aa98-a7a2acc7968a" alt=""><figcaption></figcaption></figure>

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

<figure><img src="https://3632868340-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MklUh4JWyjd6jJi6Rvm%2Fuploads%2F4LAbujwPQXboAZMaH1GO%2FDWH10.png?alt=media&amp;token=1d71376c-9822-4f41-aca7-1510c10b8461" alt=""><figcaption></figcaption></figure>

### PowerBI&#x20;

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

<figure><img src="https://3632868340-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MklUh4JWyjd6jJi6Rvm%2Fuploads%2FghcQP0B4bEmOZJOSUUu8%2FDWH11.png?alt=media&amp;token=28f990cf-689b-473e-87b4-c0781362380d" alt=""><figcaption></figcaption></figure>

* Select ‘Reapit Snowflake ODBC’ > Click 'OK':&#x20;

<figure><img src="https://3632868340-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MklUh4JWyjd6jJi6Rvm%2Fuploads%2FnxGicAlxOu7x8o9rbb3i%2FDWH12.png?alt=media&amp;token=ceda480e-5c9d-49b7-84ee-e08e94254272" alt=""><figcaption></figcaption></figure>

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

<figure><img src="https://3632868340-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MklUh4JWyjd6jJi6Rvm%2Fuploads%2FfwqW3r3HzjgYhyzz0yqq%2FDWH13.png?alt=media&amp;token=801f8f16-1cca-4220-9ee3-a47a6a2e98e7" alt=""><figcaption></figcaption></figure>

&#x20;

&#x20;