Snowflake

How to Add a Snowflake Connector

1. Access Connectors Page

- Go to the application menu and navigate to the Connectors section.

2. Configure Connection

- Click the button to add a new connection.

3. Enter Connection Details

- Connection Name: Provide a name for the connection, e.g., Snowflake.

- Host: Enter the host URL. Example: dz68640.us-east-2.aws.snowflakecomputing.com.

- Port: Specify the port, usually 443.

4. Authentication

- User Name: Enter your Snowflake user name.

- Password: Enter the corresponding password.

- Role (Optional): Specify a role if necessary.

5. Database Information

- Warehouse: Input your virtual warehouse name. Example: DEV.

- Default Database: Enter the default database you wish to use. Example: DEV.

- Default Schema (Optional): Provide a default schema if needed.

6. Test Connection

- Click the Test connection button to ensure all details are correct and the connection can be established.

7. Save Configuration

- Once the test is successful, click the Save and test button to save your connector settings.

8. FAQs and Troubleshooting

- Make sure your host allows connections from your local IP.

- Verify that the database user has the necessary privileges: SELECT, USAGE, CONNECT.

- If the schema field is left empty, a default will be used but can be changed later.

By following these steps, you will successfully add and configure a Snowflake connector within your application.