# Snowflake

## Configure Snowflake connection

#### Accessing the Snowflake Connector

* Navigate to the **Connectors Page** from the main menu.
* Select **Add Storage** and choose **Snowflake** from the list of available connectors.

#### Connection Settings

* **Connection name.** Enter a unique name for this connection
* **Host.** Specify the hostname or IP address of your Snowflake account. Follow the format `accountname.snowflakecomputing.com`.
* **Port.** **Port**: Enter the port number. The default port for Snowflake is `443`.
* **Username.** Enter the username that will be used to connect to your Snowflake instance.
* **Password.** Enter the password associated with the provided username.
* **Role**. Specify the role that should be assumed when connecting to Snowflake. If left blank, the default role associated with the username will be used.
* **Warehouse.** Enter the name of the warehouse to use when executing queries. This field is required.
* **Database.** Provide the name of the database you wish to connect to within your PostgreSQL server.
* **Schema (optional).** Enter the schema name here to set a specific schema as default. You can leave this field blank or select another schema in the Source node in the Flow Designer.&#x20;

#### Additional Parameters

By default, Tabula will create a new schema in the execution database when executing queries. If you have restricted access to the default database or are working within a shared Snowflake environment, you may need to specify alternative database and schema names. This is especially useful for shared Snowflake databases where multiple users or applications share the same resources.

* **Database.** Specify an alternative database name if you cannot use the default execution database.
* **Schema.** Specify an alternative schema name if you cannot use the default schema.

#### Test and Save

* **Test connection.** Click this button to verify that the connection settings are correct. If successful, you will see a confirmation message. If there are issues, you will receive an error message detailing what needs to be corrected.
* **Save and Test.** This button allows you to save your settings and immediately test the connection. If the connection test is successful, the connector will be saved and ready for use.


---

# 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://docs.tomat.ai/integrations/connectors/data-storages/snowflake.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.
