Snowflake

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

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.

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.