Snowflake
Last updated
Last updated
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.