# Snowflake

Allows you to configure Snowflake as a destination for Inforiver writeback. 

After navigating to the add destination page, the following details must be entered, if you choose **Basic Authentication.**

* Account
* Database
* Schema
* Username
* Password
* Warehouse
* Role - ensure the role has 'UASGE' and 'CREATE TABLE' permission
* Encrypted Connection (Y/N)
* Table Name

<figure><img src="https://3062809325-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FEbkCXCUXmtUq5tcnUtZE%2Fuploads%2FyEqDG7D2Xc3tJGN1PPwe%2Fimage.png?alt=media&#x26;token=532177c0-e349-4261-9a20-12bfa7400bd1" alt=""><figcaption><p>Configuring snowflake destinations</p></figcaption></figure>

You can also log in using OAuth-type authentication, which ensures a simple and secure login process. The example below illustrates adding a Snowflake destination to an existing integration using OAuth-type authentication. [Learn more about setting up OAuth](https://docs.inforiver.com/working-with-inforiver/12.-data-writeback/destinations/snowflake/setting-up-snowflake-oauth).

<figure><img src="https://3062809325-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FEbkCXCUXmtUq5tcnUtZE%2Fuploads%2FF2RhUyPCYHuOHsFQbanJ%2F1.3.%20Snowflake%20OAuth-updated.png?alt=media&#x26;token=5cab4562-c246-462d-90fd-d2cdaab06e8b" alt=""><figcaption><p>OAuth-type authentication for Snowflake destination</p></figcaption></figure>

#### - Fetching the role

<figure><img src="https://3062809325-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FEbkCXCUXmtUq5tcnUtZE%2Fuploads%2FcS7vuVqjsCOIlQXJ9oX4%2Fimage.png?alt=media&#x26;token=286e5054-3b0a-4afd-92df-a2f201bac2a4" alt=""><figcaption><p>Fetching the role</p></figcaption></figure>

#### - Fetching the warehouse

<figure><img src="https://3062809325-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FEbkCXCUXmtUq5tcnUtZE%2Fuploads%2FQw9FSCx1oWbpBC6T0WhN%2Fimage.png?alt=media&#x26;token=f061f66c-5c68-42b9-9309-c7ddd95743b4" alt=""><figcaption><p>Fetching the warehouse</p></figcaption></figure>