# Snowflake

#### Tutorial: how to create a 30-day trial Snowflake account and register it in Tabula

{% embed url="<https://www.youtube.com/watch?v=56sl1x6UHqs>" %}

## 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.