Snowflake
Welcome to this step-by-step guide on connecting Snowflake to Kensu Hub.
By establishing this connection, you will be able to retrieve comprehensive information, including schemas and metrics of the tables utilized in your data processing jobs, which are processed by the Kensu collectors.
Before you begin configuring the Snowflake connection, ensure you have the following:
- A Snowflake account with specific roles granted the necessary read permissions to access concerned tables.
Follow the steps below to seamlessly integrate Snowflake with Kensu Hub and unlock advanced data insights:
1. Navigate to your Kensu Hub URL https://xxxxx-hub.kensuapp.com/
2. Upon accessing Kensu Hub, locate the Data Source Connections panel on the dashboard. Here, you'll see a list of supported data sources. Find and click on Snowflake configure to begin the process of creating a new connection.
3. Inside the Snowflake connection area, you'll find a section titled Dependencies. Click on the Configure button here to set up the prerequisites necessary for establishing a connection.
4. Look for the + icon. Clicking on this icon will open a form where you can enter the details for your new Snowflake connection.
5. Now, you'll need to fill out the form with specific information about your Snowflake account. Here's what you'll need:
- Account: This is your Snowflake account ID, which uniquely identifies your Snowflake environment.
- conn_id: A unique ID for your connection
- Database: The name of the database you wish to connect.
- Login: Your Snowflake login credentials (username).
- Password: Your Snowflake account password.
- Role: The user role that you'll be using in Snowflake.
- Schema: The schema within the database you're connecting to.
- Warehouse: The warehouse that will be used for processing queries.
6. After double-checking the information you've entered, click on the Submit button to finalize the connection. Kensu Hub will process your details and establish a connection to your Snowflake data source.
