Help & Documentation
Open Support Ticket

Connecting to Snowflake MCP Server: Overview

To allow Users seamlessly interact with Snowflake Intelligence AI tool directly from Concierge, Metric Insights supports connecting them via Model Context Protocol (MCP) Server. Establishing this connection gives Users access to Snowflake's Conversational Analytic and other AI-powered tools, so Users can ask natural language questions about data from Concierge without the need to switch platforms.

Architectural Diagram for Snowflake MCP Server Integration with Concierge

In this example, Snowflake Intelligence has been configured with two Agents, Financial Data and Sales Data. These Agents correlate to their respective Domains in Metric Insights. A User can ask a financial question and Concierge will know to route that question through the correct MCP Server to the specific Domain.

Prerequisites

To perform all the steps necessary for connecting Concierge and Snowflake, you need the following:

  • In Snowflake CLI:
    • Snowflake account with ACCOUNTADMIN privileges.
    • Snow CLI installed and configured with a working profile.
    • Access to Snowsight or Snowflake CLI for executing SQL commands.
  • The server space (on the same machine where the application is running or remotely on a separate server or cloud platform) to run the MCP Server.
    • It is a lightweight API proxy that doesn't require significant resources and runs well with minimal specifications: 256MB RAM and 1 vCPU.
  • Metric Insights Admin account.

Steps to Connect Concierge and Snowflake

  1. Define the Authentication method: Define how Concierge will perform authentication when connecting to Snowflake:
    • "Defined in configuration": The authentication Token has to be created in Snowflake account and manually inserted into the Concierge configuration code. This Auth Type should be used if the Snowflake has the security model which doesn't include OAuth or has some specific features that require flexible solution.
    • "Service Account Token": The Token is requested form Snowflake and inserted into the configuration code automatically. The User only provides credentials to the service account in Snowflake. This Auth Type should be used if OAuth authentication method is used in Snowflake.
    • "User OAuth": This method is the same as the "Service Account Token" but takes into account the permissions of the User, who makes a query to Concierge. This Auth Type should be used if different users of the Snowflake have different levels of access to data and that difference has to be implemented in their Concierge queries.
  2. Configure Snowflake via Snowflake CLI: Set up the required roles, users, and permissions in Snowflake to get the MCP server working with your existing Snow CLI profile.
  3. Gather data in Snowflake account: Gather data for MCP Server setup and credentials for authentication.
  4. Set up the MCP Server: Run the MCP Server on local machine or remote resource.
  5. Configure External Resource in Metric Insights account: Set up Concierge to connect with Snowflake.