Snowflake Cortex

​

Prerequisites

• A Snowflake data connection authenticated with a key pair (password-auth connections are not accepted by Snowflake’s Cortex REST API).
• The connection’s role needs Cortex access (the SNOWFLAKE.CORTEX_USER database role, granted to PUBLIC by default).

​

Configure in Datafold

1. Navigate to Settings → Integrations, click Add New Integration, and choose Snowflake Cortex.
2. Select the Data connection for the account that serves Cortex.
3. Models — Datafold lists the account’s Cortex models via SHOW CORTEX BASE MODELS. Select the ones to expose, or add ids manually (e.g. claude-4-sonnet, mistral-large2).
4. Click Save.

​

Enabling the automatic model listing

-- Populate SNOWFLAKE.MODELS (one-time; re-run occasionally as new models ship)
CALL SNOWFLAKE.MODELS.CORTEX_BASE_MODELS_REFRESH();

-- Make all current and future models visible to the connection's role
GRANT APPLICATION ROLE SNOWFLAKE."CORTEX-MODEL-ROLE-ALL" TO ROLE <your_role>;