# Snowflake

## Navigate to Warehouse Section in Daasity App

<figure><img src="https://content.gitbook.com/content/amTMWiPne1v1V3L7mbuj/blobs/lokDXm2zJImMl2dUKVdi/Screen%20Shot%202024-03-20%20at%201.00.00%20PM.png" alt=""><figcaption><p>Click Warehouse</p></figcaption></figure>

## Choose First "Recommended" Snowflake Option

## Choose I Already Have a Snowflake Account and click Continue Setup.

<figure><img src="https://content.gitbook.com/content/amTMWiPne1v1V3L7mbuj/blobs/57ku5dacTaSHbMlcRU8S/1snow.png" alt=""><figcaption><p>Already Have Snowflake</p></figcaption></figure>

## Enter Your Snowflake Account Information

<figure><img src="https://content.gitbook.com/content/amTMWiPne1v1V3L7mbuj/blobs/BNQ2ma7WsyRT9uXrdXLV/snow2.png" alt=""><figcaption><p>Complete Information</p></figcaption></figure>

### Account URL:<br>

<br>

<figure><img src="https://content.gitbook.com/content/amTMWiPne1v1V3L7mbuj/blobs/e6m63V0ddTgDVpCa9HZW/snow3.png" alt=""><figcaption><p>URL</p></figcaption></figure>

### Account Locator:<br>

<figure><img src="https://content.gitbook.com/content/amTMWiPne1v1V3L7mbuj/blobs/9l8rOEtbiIDeGLHAs5tH/snow4.png" alt=""><figcaption><p>Locator</p></figcaption></figure>

### Account Edition:

<figure><img src="https://content.gitbook.com/content/amTMWiPne1v1V3L7mbuj/blobs/NRzxJJf21IzoMta9TsMy/snow5.png" alt=""><figcaption><p>Edition</p></figcaption></figure>

{% hint style="success" %}
If you have an Enterprise account, choose the Enterprise edition option so you may take advantage of the Snowflake automatic cluster scaling.
{% endhint %}

### Enter Setup Credentials

### These are the credentials of a user that has been granted the ACCOUNTADMIN role. &#x20;

{% hint style="success" %}
**NOTE:** This credential information is ONLY required during setup and will NOT be used again. &#x20;

**Daasity uses these credentials to set up the roles, users, etc required for Daasity.**
{% endhint %}

<figure><img src="https://content.gitbook.com/content/amTMWiPne1v1V3L7mbuj/blobs/GJWEbzTnvnenyjHRESpO/snow6.png" alt=""><figcaption><p>Credentials</p></figcaption></figure>

### Test the Credentials

The last step is to validate the credentials / settings are working properly.  By clicking the T**est Connection** button, it will verify the Admin Credentials along with Access to the initial Compute Warehouse.

<figure><img src="https://content.gitbook.com/content/amTMWiPne1v1V3L7mbuj/blobs/z8wCAB26J3Q1DC79GooQ/snow7.png" alt=""><figcaption><p>Test Connection</p></figcaption></figure>

### Review Settings

{% hint style="success" %}
If the credentials work, you will be prompted to move along to the next step to **Review the settings.**
{% endhint %}

<br>

<figure><img src="https://content.gitbook.com/content/amTMWiPne1v1V3L7mbuj/blobs/OiFNJrrQpOgaAuj3Bqjw/snow8.png" alt=""><figcaption><p>Success</p></figcaption></figure>

### Credentials did NOT work

<figure><img src="https://content.gitbook.com/content/amTMWiPne1v1V3L7mbuj/blobs/jkANmo5T6QEmlZIqEyRH/snow9.png" alt=""><figcaption><p>Failed</p></figcaption></figure>

Typical mistakes which cause the validation to fail are:

* Invalid credentials - username / password
* Password or username must NOT contain the curly brace characters { or }
* User does not have access to the compute warehouse
* The Snowflake account may not be publicly accessible. If not, you will need to add the Daasity servers to the whitelist.

**Once you have troubleshooted and Passed the Test Connection**

## We suggest using the Default Settings

<figure><img src="https://content.gitbook.com/content/amTMWiPne1v1V3L7mbuj/blobs/VG7PKFp5lIMYwbf7Uy4s/snnow10.png" alt=""><figcaption><p>Default</p></figcaption></figure>

### Modify Settings (NOT Recommended)

<figure><img src="https://content.gitbook.com/content/amTMWiPne1v1V3L7mbuj/blobs/JO7GIZ6PZ3VKjkt96ALx/snow11.png" alt=""><figcaption><p>Modify</p></figcaption></figure>

\
Create Warehouse - Start the setup process
------------------------------------------

### Click the \[Create] button to start the setup process

The setup screen will show the progress:

<figure><img src="https://content.gitbook.com/content/amTMWiPne1v1V3L7mbuj/blobs/r0BWHhoPyUweDfSnyK3F/snow12.png" alt=""><figcaption><p>Setup</p></figcaption></figure>

When complete:

<figure><img src="https://content.gitbook.com/content/amTMWiPne1v1V3L7mbuj/blobs/3hBRetIfxt2bOha8rYkc/snow13.png" alt=""><figcaption><p>Completed</p></figcaption></figure>

<br>
