Configuring Connections: Snowflake (Versions: 9.0+)

Versions: 8.0+

Configuring QuerySurge Connections: Snowflake

When you create a QuerySurge Connection, the Connection Wizard will guide you through the process. Different types of QuerySurge connections require different types of information.

For a Snowflake Connection, you will need the following information (check with a DBA or other knowledgeable resource in your organization):

• Your full Snowflake account name. This may include additional details such as the region and cloud platform where your Snowflake account is hosted. This information will come from your Snowflake URL, which generally follows the format of:
  

  https://<YourAccountName>.snowflakecomputing.com

• The username and password that you use to login to Snowflake
• The warehouse, database, and schema that you want to associate with the connection

Launch the Connection Wizard

1. Download the Snowflake JDBC driver. The driver download can be found here (only deploy the snowflake-jdbc-x.x.x.jar).
   
   
2. Deploy the Snowflake JDBC driver jar to your Agent(s). The procedure for deploying a driver to a QuerySurge Agent is here (for Agents on Windows) and here (for Agents on Linux).
   
   
3. Log into QuerySurge as a QuerySurge Admin user.
   
   
4. To configure a Connection, select Configuration > Connection in the Administrative View tree (at the left).
   
   
5. Click on the Add button at the bottom left of the page to launch the Connection Wizard. Click Next.
   
   
6. Provide a name for your connection. Select Snowflake as the Data Source. Click Next.
   
   
   
   
7. Once you have selected your Data Source, the Wizard will tell you what information you are likely to need in order to create your Connection. Once you have collected this information, you are ready to click Next.
   
   
   
   
8. Provide the connection information to your Snowflake instance. This includes your Snowflake account name and the login credentials you use to access Snowflake. Click Next.
   
   Required fields for your Connection are marked by an *.
   
   
   
   
9. Provide the database details for your Snowflake Connection. These include the warehouse, database, and schema that your Connection should point to. Click Next.
   
   
   
   
10. Click on Test Connection.
    
    Note: You must have an Agent running with the driver for this Connection deployed in order to test the Connection.
    
    
    
    
11. Save the Connection.
    
    
    
    
12. Congratulations! You’ve created a QuerySurge Connection. Make sure that you have deployed the driver for this Connection to all your QuerySurge Agents. (See Adding a JDBC Driver to your QuerySurge Agent for instructions.)