# 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="/files/sbT3fns6hOePBFO7HR7y" alt=""><figcaption></figcaption></figure>

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

<figure><img src="/files/ZiJTRF7IOoH3r2iFFtlM" alt=""><figcaption></figcaption></figure>

* Select ‘Snowflake DSIIDriver’:

<figure><img src="/files/RQzVbptz1e8MPv35WLzg" alt=""><figcaption></figcaption></figure>

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

<figure><img src="/files/SVmaPRdk3784rGlQAZOH" 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="/files/Kq9u3LoKZQJD1eiLRBVe" 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="/files/LIaefHVJS7csG9eVyMIP" 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="/files/VjJMZdRc642UAExVrpdY" 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="/files/XaVjXUPFJnrkwflOAha1" 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="/files/MFNqNNfFdMooLjtvic2Z" 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="/files/Nv3BI9tFpt8T6v4XQMbR" 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="/files/p7hbjD2Dmqs6z7FEx5lO" alt=""><figcaption></figcaption></figure>

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

<figure><img src="/files/qBCWsfIVNkUxoAIyO9Ak" alt=""><figcaption></figcaption></figure>

### PowerBI&#x20;

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

<figure><img src="/files/W1iwKgXsSsPUiY3rLY6Q" alt=""><figcaption></figcaption></figure>

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

<figure><img src="/files/nukBZd7GpG0kw9hMlmOC" alt=""><figcaption></figcaption></figure>

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

<figure><img src="/files/L3J0wGVRzasfsQEj8fHZ" alt=""><figcaption></figcaption></figure>

&#x20;

&#x20;


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://datawarehouse-foundations.reapit.cloud/using-the-snowflake-odbc-driver.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.