Connect Snowflake Cortex

• Cortex Code — Snowflake’s AI coding assistant in Snowsight
• Snowflake Intelligence — Cortex Agents for data exploration and orchestration

​

Prerequisites

• Snowflake account with ACCOUNTADMIN role
• Prometheux credentials (username, organization, API token)
• MCP Connectors enabled on your account (supports Cortex Code and Cortex Agents)
• Cross-region inference enabled (required if no models are available in your region)

ALTER ACCOUNT SET CORTEX_ENABLED_CROSS_REGION = 'ANY_REGION';

​

Setup

​

Step 1 — Create the API Integration

USE ROLE ACCOUNTADMIN;

CREATE API INTEGRATION prometheux_mcp_integration
  API_PROVIDER = external_mcp
  API_ALLOWED_PREFIXES = ('https://api.prometheux.ai/px-remote-mcp-server')
  API_USER_AUTHENTICATION = (
    TYPE = OAUTH2
    OAUTH_CLIENT_ID = 'prometheux'
    OAUTH_CLIENT_SECRET = 'unused'
    OAUTH_TOKEN_ENDPOINT = 'https://api.prometheux.ai/px-remote-mcp-server/oauth/token'
    OAUTH_AUTHORIZATION_ENDPOINT = 'https://api.prometheux.ai/px-remote-mcp-server/oauth/authorize'
    OAUTH_CLIENT_AUTH_METHOD = CLIENT_SECRET_POST
  )
  ENABLED = TRUE;

​

Step 2 — Create the External MCP Server

CREATE DATABASE IF NOT EXISTS PROMETHEUX;
CREATE SCHEMA IF NOT EXISTS PROMETHEUX.INTEGRATION;

USE DATABASE PROMETHEUX;
USE SCHEMA INTEGRATION;

CREATE EXTERNAL MCP SERVER prometheux_mcp_server
  WITH DISPLAY_NAME = 'Prometheux'
  URL = 'https://api.prometheux.ai/px-remote-mcp-server/mcp'
  API_INTEGRATION = prometheux_mcp_integration;

​

Step 3 — Connect and Authenticate

1. In Snowsight, go to the MCP Connectors page (or open it from Cortex Code / Snowflake Intelligence)
2. Find Prometheux in the list of connectors
3. Click Connect — Snowflake will redirect you to the Prometheux OAuth login page
4. Enter your credentials:
   • Username: Your Prometheux username
   • Organization: Your Prometheux organization
   • API Token: Your Prometheux authentication token
5. Submit the form — Snowflake will receive your session token automatically

​

Using with Cortex Code

@MCP list all of my ontologies

​

Using with Snowflake Intelligence

CREATE AGENT PROMETHEUX.INTEGRATION.prometheux_agent
  COMMENT = 'Agent with Prometheux MCP connector'
  FROM SPECIFICATION
  $$
  models:
    orchestration: "auto"
  mcp_servers:
    - server_spec:
        name: "PROMETHEUX.INTEGRATION.PROMETHEUX_MCP_SERVER"
  $$;

​

Alternative Setup via Snowsight UI

1. Go to AI & ML → Agents → Settings → Tools and Connectors
2. Click Add custom
3. Select Standard OAuth and fill in:

4. Select a database and schema, then click Add

​

Disconnecting

1. Go to the MCP Connectors page in Snowsight
2. Select the Prometheux connector and click Disconnect

​

Cleanup

DROP AGENT PROMETHEUX.INTEGRATION.PROMETHEUX_AGENT;
DROP EXTERNAL MCP SERVER PROMETHEUX.INTEGRATION.PROMETHEUX_MCP_SERVER;
DROP API INTEGRATION PROMETHEUX_MCP_INTEGRATION;

​

Troubleshooting

​

”Invalid redirect_uri” error

• This occurs if the Prometheux remote MCP server doesn’t recognize Snowflake’s OAuth callback. Ensure you’re connecting to the latest version of the remote server at https://api.prometheux.ai/px-remote-mcp-server.

​

”Model not authorized” error

• Enable cross-region inference on your account:
  ALTER ACCOUNT SET CORTEX_ENABLED_CROSS_REGION = 'ANY_REGION';
  
• Alternatively, check which models are available in your region and set a specific model in the agent specification instead of "auto".

​

Connector shows “Connected” but tools don’t work

• If the remote MCP server was restarted, session tokens are invalidated. Disconnect and reconnect via the Sources panel in Snowflake Intelligence.
• Verify your Prometheux credentials are still valid.

​

”Failed to add MCP connector” in the UI

• Use the SQL-based setup instead. The Snowsight UI may fail silently if the server is temporarily unreachable.
• Ensure the MCP server URL is accessible from Snowflake’s network.

​

Agent can’t find the MCP server object

• Verify the fully qualified name matches exactly (e.g. PROMETHEUX.INTEGRATION.PROMETHEUX_MCP_SERVER).
• Ensure the ACCOUNTADMIN role has USAGE on the database and schema.