Snowflake

Connecting to Snowflake

To connect Semaphor to your Snowflake instance, you need to use a connection string in the following format:

Connection String Format

snowflake://username:password@organization-account/database

• username – Your database username.
• password – The password for the specified user.
• organization-account – Your Snowflake organization and account separated by a dash.
• database – The name of the database you want to connect to.

SELECT CURRENT_ACCOUNT();

SELECT CURRENT_ORGANIZATION();

Example Connection String

If your database username is admin, password is mypassword, hosted on TestingSnowflake1@DDKMDHX-YI75508 using the default Snowflake port (5432), and the database name is analytics_db, your connection string would be:

snowflake://admin:mypassword@TestingSnowflake1@DDKMDHX-YI75508/analytics_db

Prerequisites

To successfully connect Semaphor to your Snowflake instance, ensure the following requirements are met:

Database Permissions

• The user account must have read-only access to the required database.
• The user must have the ability to create session-specific temp tables.

Network Access

• If your database is private, whitelist the Semaphor IP: 44.199.53.142 to allow connections.
• Ensure that firewall rules and security group settings permit network access for Semaphor.

Troubleshooting

If you encounter issues connecting to Snowflake, consider the following:

• Invalid Credentials: Verify your username and password.
• Network Restrictions: Ensure your firewall or security group allows connections to the Snowflake instance.
• Incorrect Connection String: Double-check the format of your connection string.
• Database Permissions: Ensure your user has the required privileges to access the database.