Only an admin can set up the Snowflake integration.
Connecting Soal to your Snowflake instance allows users to run sql queries in notebooks and allows Soal to suggest queries using AI.
Step 1. Create a Snowflake user
You can run the following script. Make sure you fill out your database name, warehouse and a password in the script:
use role ACCOUNTADMIN;set database_name = '--YOUR DATABASE NAME--';set warehouse_name = '--YOUR WAREHOUSE NAME--';set soal_user = 'SOAL_USER';set soal_role = 'SOAL_ROLE';create user if not exists identifier($soal_user) password='--YOUR PASSWORD--';create role if not exists identifier($soal_role);grant role identifier($soal_role) to user identifier($soal_user);-- grant Soal role access to warehousegrant USAGE on warehouse identifier($warehouse_name)to role identifier($soal_role);-- grant Soal access to databasegrant MONITOR, USAGE on database identifier($database_name) to role identifier($soal_role);grant USAGE on all schemas in database identifier($database_name) to role identifier($soal_role);grant SELECT on all tables in database identifier($database_name) to role identifier($soal_role);grant SELECT on future tables in database identifier($database_name) to role identifier($soal_role);
Step 2. Whitelist Soal’s IP Addresses
Soal will connect to your database from the following IP addresses. Please make sure to allow traffic from these IPs by editing the Network Policies in your Snowflake Account:
00.000.000.000
Step 3. Create a Snowflake database connection in Soal
First, go to your Soal DB Connections (Workspace -> Integrations) page using the left side panel.Click Create + and fill out the fields below
Name: What you would like to call this specific database connection.
Account: Your snowflake account identifier(opens in a new tab) is provided by Snowflake and included in the start of the URL you use to login to Snowflake: <account_identifier>.snowflakecomputing.com.
User: The Snowflake user. Best practice is to have a service user specifically dedicated to Soal.
Password: The password used to login to Snowflake.
Database: The Snowflake database to use. Databases correspond with logical groupings of tables and views in Snowflake.
Schema: optional If you provide a schema, we will limit listed tables in the model builder to this schema. If you need to limit permissions to a specific schema, you should do this with Snowflake permissions.
Warehouse: The warehouse to use in Snowflake. Warehouses correspond with compute resources.
Role: You must specify a role to be assumed when connecting from Soal. See Snowflake’s roles(opens in a new tab) documentation.
Account identifier format may differ based on Snowflake account age. For example, older Snowflake accounts often have identifiers that look like <account_locator>.<region>.<cloudprovider>, whereas newer Snowflake accounts have identifiers that look like <orgname>-<account_name>. For more details, visit Snowflake’s account identifier docs.
{"docsConfig":{"$schema":"https://mintlify.com/docs.json","theme":"mint","name":"Soal Documentation","colors":{"primary":"#FFFFFF","light":"#FFFFFF","dark":"#FFFFFF"},"favicon":"/favicon.png","logo":{"light":"https://mintcdn.com/soalinc/39krj8Vh14GGxpzC/logo/light.svg?fit=max\u0026auto=format\u0026n=39krj8Vh14GGxpzC\u0026q=85\u0026s=390eb3e18fdd1d6630e4a020a9289c66","dark":"https://mintcdn.com/soalinc/39krj8Vh14GGxpzC/logo/dark.svg?fit=max\u0026auto=format\u0026n=39krj8Vh14GGxpzC\u0026q=85\u0026s=6f5329c8a062f915c3da7ef52ab3f283","href":"https://getsoal.com"},"appearance":{"default":"dark","strict":true},"background":{"decoration":null,"color":{"light":null,"dark":"#000000"}},"footer":{"socials":{"linkedin":"https://www.linkedin.com/company/getsoal/"}},"navigation":{"global":{"anchors":[{"anchor":"Blog","href":"https://getsoal.com/blog","icon":"newspaper"}]},"pages":[]}},"deployment":{"deploymentMetadataValue":{"subdomain":"soalinc","hasAudioNarration":false,"actualSubdomain":"soalinc","customDomains":[],"gitSource":{"type":"github","owner":"soalinc","repo":"docs","deployBranch":"main","contentDirectory":"","isPrivate":true,"mountPath":"","label":""},"entitlements":{},"buildId":"6ae91a1099e24e524bebc9e1:success","clientVersion":"0.0.4143","searchFilterCounts":[{"language":"default","tag":"Documentation","count":23},{"language":"default","tag":"🔌 Integrations","count":7},{"language":"default","tag":"🏅 Essentials","count":6},{"language":"default","tag":"🔐 Security and Compliance","count":5},{"language":"default","tag":"⚙️ Setup","count":5},{"language":"default","tag":"Business Intelligence","count":3},{"language":"default","tag":"Cloud Data Warehouse","count":2},{"language":"default","tag":"Issue Tracker","count":1},{"language":"default","tag":"Messaging System","count":1}]},"assistantConfig":{},"basePath":"","hasChatPermissions":false,"hasWebMcpPermissions":false,"toggles":[{"name":"kill-isr","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"custom-rbac-roles","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"agent-mintlify-slack","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"agent-integrations-settings","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"rbac-expansion","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automations-pr-grouping","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"custom-prefix","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"analytics-v7","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"user-flows-analytics","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"no-publish-flow","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-onboarding","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"snapshot-serving-live","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"stripTemperatureMiddleware","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"support-platform-pylon-zendesk","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"snapshot-serving","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"instant-rollback","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"granular-notifications-server","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"granular-notifications","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automations-fable","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"fixed-ai-action-pricing","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automation-resolve-merge-conflict","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"scoped-publishing","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"mintql","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"page-level-analytics","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-version-history-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"billing-page-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"full-page-search","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workspace-projects","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"assistant-v5","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"fork-pr-previews","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"revalidation-jwt","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-sso-scim","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"hobby-abuse-scan","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"dashboard-inbox","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-signup","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"turbopuffer-dual-write","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-enabled","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"approve-review-flow","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-metadata","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"sso-setup-deadline-banner","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"turbopuffer-serve","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"live-agents","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"llms-txt-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false}],"googleFontsInlined":false},"customCss":[],"page":{"pagePath":"integrations/snowflake","slug":"/integrations/snowflake","pageMetadata":{"title":"Snowflake","description":null,"href":"/integrations/snowflake"},"pageType":"default","mdx":{"mdxSource":{"compiledSource":"\"use strict\";const{Fragment:_Fragment,jsx:_jsx,jsxs:_jsxs}=arguments[0];const{useMDXComponents:_provideComponents}=arguments[0];function _createMdxContent(props){const _components={a:`a`,code:`code`,em:`em`,li:`li`,p:`p`,pre:`pre`,span:`span`,strong:`strong`,ul:`ul`,..._provideComponents(),...props.components},{CodeBlock,Heading,Tip,Warning}=_components;if(!CodeBlock)_missingMdxReference(`CodeBlock`,true);if(!Heading)_missingMdxReference(`Heading`,true);if(!Tip)_missingMdxReference(`Tip`,true);if(!Warning)_missingMdxReference(`Warning`,true);return _jsxs(_Fragment,{children:[_jsx(Warning,{children:` Only an admin can set up the Snowflake integration. `}),`\n`,_jsxs(_components.p,{children:[`Connecting Soal to your Snowflake instance allows users to run sql queries in `,_jsx(_components.a,{href:`/essentials/notebooks`,children:`notebooks`}),` and allows Soal to `,_jsx(_components.a,{href:`/essentials/generated_queries`,children:`suggest queries`}),` using AI.`]}),`\n`,_jsx(Heading,{level:`3`,id:`step-1-create-a-snowflake-user`,children:`Step 1. Create a Snowflake user`}),`\n`,_jsx(_components.p,{children:`You can run the following script. Make sure you fill out your database name, warehouse and a password in the script:`}),`\n`,_jsx(CodeBlock,{filename:``,numberOfLines:`20`,language:`sql`,children:_jsx(_components.pre,{className:`shiki shiki-themes github-light-default dark-plus`,style:{backgroundColor:`#ffffff`,\"--shiki-dark-bg\":`#0B0C0E`,color:`#1f2328`,\"--shiki-dark\":`#D4D4D4`},language:`sql`,children:_jsxs(_components.code,{language:`sql`,numberOfLines:`20`,children:[_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`use`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` role`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` ACCOUNTADMIN;`})]}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` `})}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`set`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` database_name`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#D4D4D4`},children:` =`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` '--YOUR DATABASE NAME--'`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`;`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`set`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` warehouse_name `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#D4D4D4`},children:`=`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` '--YOUR WAREHOUSE NAME--'`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`;`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`set`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` soal_user `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#D4D4D4`},children:`=`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` 'SOAL_USER'`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`;`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`set`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` soal_role `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#D4D4D4`},children:`=`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` 'SOAL_ROLE'`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`;`})]}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` `})}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`create`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` user`}),_jsx(_components.span,{style:{color:`#8250DF`,\"--shiki-dark\":`#DCDCAA`},children:` if`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` not`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` exists`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` identifier($soal_user) `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`password`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#D4D4D4`},children:`=`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`'--YOUR PASSWORD--'`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`;`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`create`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` role`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` if`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` not`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` exists`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` identifier($soal_role);`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`grant`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` role`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` identifier($soal_role) `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`to`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` user identifier($soal_user);`})]}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` `})}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#6E7781`,\"--shiki-dark\":`#6A9955`},children:`-- grant Soal role access to warehouse`})}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`grant`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` USAGE `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`on`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` warehouse identifier($warehouse_name)`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`to`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` role`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` identifier($soal_role);`})]}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` `})}),`\n`,_jsx(_components.span,{className:`line`,children:_jsx(_components.span,{style:{color:`#6E7781`,\"--shiki-dark\":`#6A9955`},children:`-- grant Soal access to database`})}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`grant`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` MONITOR, USAGE `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`on`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` database`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` identifier($`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`database_name`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`) `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`to`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` role`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` identifier($soal_role);`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`grant`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` USAGE `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`on`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` all schemas `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`in`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` database`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` identifier($`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`database_name`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`) `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`to`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` role`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` identifier($soal_role);`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`grant`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` SELECT`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` on`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` all tables `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`in`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` database`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` identifier($`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`database_name`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`) `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`to`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` role`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` identifier($soal_role);`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`grant`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` SELECT`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` on`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` future tables `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`in`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` database`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` identifier($`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`database_name`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:`) `}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:`to`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#569CD6`},children:` role`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#D4D4D4`},children:` identifier($soal_role);`})]}),`\n`]})})}),`\n`,_jsx(Heading,{level:`3`,id:`step-2-whitelist-soal’s-ip-addresses`,children:`Step 2. Whitelist Soal’s IP Addresses`}),`\n`,_jsx(_components.p,{children:`Soal will connect to your database from the following IP addresses. Please make sure to allow traffic from these IPs by editing the Network Policies in your Snowflake Account:`}),`\n`,_jsxs(_components.ul,{children:[`\n`,_jsx(_components.li,{children:_jsx(_components.code,{children:`00.000.000.000`})}),`\n`]}),`\n`,_jsx(Heading,{level:`3`,id:`step-3-create-a-snowflake-database-connection-in-soal`,children:`Step 3. Create a Snowflake database connection in Soal`}),`\n`,_jsx(_components.p,{children:`First, go to your Soal DB Connections (Workspace -> Integrations) page using the left side panel.`}),`\n`,_jsxs(_components.p,{children:[`Click `,_jsx(_components.code,{children:`Create +`}),` and fill out the fields below`]}),`\n`,_jsxs(_components.ul,{children:[`\n`,_jsxs(_components.li,{children:[_jsx(_components.strong,{children:`Name`}),`: What you would like to call this specific database connection.`]}),`\n`,_jsxs(_components.li,{children:[_jsx(_components.strong,{children:`Account`}),`: Your snowflake account identifier(opens in a new tab) is provided by Snowflake and included in the start of the URL you use to login to Snowflake: `,_jsx(_components.code,{children:`\u003caccount_identifier>.snowflakecomputing.com`}),`.`]}),`\n`,_jsxs(_components.li,{children:[_jsx(_components.strong,{children:`User`}),`: The Snowflake user. Best practice is to have a service user specifically dedicated to Soal.`]}),`\n`,_jsxs(_components.li,{children:[_jsx(_components.strong,{children:`Password`}),`: The password used to login to Snowflake.`]}),`\n`,_jsxs(_components.li,{children:[_jsx(_components.strong,{children:`Database`}),`: The Snowflake database to use. Databases correspond with logical groupings of tables and views in Snowflake.`]}),`\n`,_jsxs(_components.li,{children:[_jsx(_components.strong,{children:`Schema`}),`: `,_jsx(_components.em,{children:`optional`}),` If you provide a schema, we will limit listed tables in the model builder to this schema. If you need to limit permissions to a specific schema, you should do this with Snowflake permissions.`]}),`\n`,_jsxs(_components.li,{children:[_jsx(_components.strong,{children:`Warehouse`}),`: The warehouse to use in Snowflake. Warehouses correspond with compute resources.`]}),`\n`,_jsxs(_components.li,{children:[_jsx(_components.strong,{children:`Role`}),`: You must specify a role to be assumed when connecting from Soal. See Snowflake’s roles(opens in a new tab) documentation.`]}),`\n`]}),`\n`,_jsxs(Tip,{children:[` Account identifier format may differ based on Snowflake account age. For example, older Snowflake accounts often have identifiers that look like `,_jsx(_components.code,{children:`\u003caccount_locator>.\u003cregion>.\u003ccloudprovider>`}),`, whereas newer Snowflake accounts have identifiers that look like `,_jsx(_components.code,{children:`\u003corgname>-\u003caccount_name>`}),`. For more details, visit Snowflake’s account identifier docs. `]})]})}function MDXContent(props={}){const{wrapper:MDXLayout}={..._provideComponents(),...props.components};return MDXLayout?_jsx(MDXLayout,{...props,children:_jsx(_createMdxContent,{...props})}):_createMdxContent(props)}return{default:MDXContent};function _missingMdxReference(id,component){throw new Error(`Expected `+(component?`component`:`object`)+\" `\"+id+\"` to be defined: you likely forgot to import, pass, or provide it.\")}","frontmatter":{},"scope":{"config":{},"pageMetadata":{"title":"Snowflake","description":null,"href":"/integrations/snowflake"}}},"mdxSourceWithNoJs":null},"mdxExtracts":{"tableOfContents":[{"title":"Step 1. Create a Snowflake user","slug":"step-1-create-a-snowflake-user","depth":3,"children":[]},{"title":"Step 2. Whitelist Soal’s IP Addresses","slug":"step-2-whitelist-soal’s-ip-addresses","depth":3,"children":[]},{"title":"Step 3. Create a Snowflake database connection in Soal","slug":"step-3-create-a-snowflake-database-connection-in-soal","depth":3,"children":[]}],"codeExamples":{}},"jsLinks":[],"subdomain":"soalinc","siteName":"Soal Documentation","title":"Snowflake - Soal Documentation","navMaps":{"firstHrefInVersion":{},"firstHrefInLanguage":{}},"lastModified":"2026-01-06T22:57:59.215Z","originalFileLocation":"integrations/snowflake.mdx"},"headHtml":"\u003cscript data-mint-head>(function(){var d=document.documentElement,p=\"dark\";if(!p){try{p=localStorage.getItem(\"isDarkMode\")}catch(e){}if(p==='true')p='dark';else if(p==='false')p='light';if(p!=='light'\u0026\u0026p!=='dark'\u0026\u0026p!=='system')p=\"dark\"}var r=p==='system'?(matchMedia(\"(prefers-color-scheme: dark)\").matches?'dark':'light'):p;d.classList.remove(r==='dark'?'light':'dark');d.classList.add(r);d.setAttribute(\"data-theme-preference\",p)})();\u003c/script>\u003cmeta data-mint-head name=\"application-name\" content=\"Soal Documentation\">\u003cmeta data-mint-head name=\"generator\" content=\"Mintlify\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/mintlify-assets/_mintlify/favicons/soalinc/4u1ftEIw9BAC4ppo/_generated/favicon/android-chrome-192x192.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"apple-touch-icon\" type=\"image/png\" sizes=\"180x180\" href=\"/mintlify-assets/_mintlify/favicons/soalinc/4u1ftEIw9BAC4ppo/_generated/favicon/apple-touch-icon.png\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/mintlify-assets/_mintlify/favicons/soalinc/4u1ftEIw9BAC4ppo/_generated/favicon/favicon-16x16.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/mintlify-assets/_mintlify/favicons/soalinc/4u1ftEIw9BAC4ppo/_generated/favicon/favicon-32x32.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/mintlify-assets/_mintlify/favicons/soalinc/4u1ftEIw9BAC4ppo/_generated/favicon/favicon.ico\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/mintlify-assets/_mintlify/favicons/soalinc/4u1ftEIw9BAC4ppo/_generated/favicon-dark/android-chrome-192x192.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/mintlify-assets/_mintlify/favicons/soalinc/4u1ftEIw9BAC4ppo/_generated/favicon-dark/favicon-16x16.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/mintlify-assets/_mintlify/favicons/soalinc/4u1ftEIw9BAC4ppo/_generated/favicon-dark/favicon-32x32.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/mintlify-assets/_mintlify/favicons/soalinc/4u1ftEIw9BAC4ppo/_generated/favicon-dark/favicon.ico\" media=\"(prefers-color-scheme: dark)\">\u003cmeta data-mint-head property=\"og:title\" content=\"Snowflake - Soal Documentation\">\u003cmeta data-mint-head property=\"og:site_name\" content=\"Soal Documentation\">\u003cmeta data-mint-head property=\"og:url\" content=\"https://soalinc.mintlify.app/integrations/snowflake\">\u003cmeta data-mint-head property=\"og:type\" content=\"website\">\u003cmeta data-mint-head property=\"og:image\" content=\"https://soalinc.mintlify.site/_mintlify/api/og/v2?division=Cloud+Data+Warehouse\u0026amp;title=Snowflake\u0026amp;theme=2dba92377bd6ce43959fab8e\u0026amp;signature=90d46e043b7a9530709643b7f4d9dd553ab295f43e81735630c1935315c50cc6\">\u003cmeta data-mint-head property=\"og:image:width\" content=\"1200\">\u003cmeta data-mint-head property=\"og:image:height\" content=\"630\">\u003cmeta data-mint-head name=\"twitter:card\" content=\"summary_large_image\">\u003cmeta data-mint-head name=\"twitter:title\" content=\"Snowflake - Soal Documentation\">\u003cmeta data-mint-head name=\"twitter:image\" content=\"https://soalinc.mintlify.site/_mintlify/api/og/v2?division=Cloud+Data+Warehouse\u0026amp;title=Snowflake\u0026amp;theme=2dba92377bd6ce43959fab8e\u0026amp;signature=90d46e043b7a9530709643b7f4d9dd553ab295f43e81735630c1935315c50cc6\">\u003cmeta data-mint-head name=\"twitter:image:width\" content=\"1200\">\u003cmeta data-mint-head name=\"twitter:image:height\" content=\"630\">\u003cmeta data-mint-head name=\"msapplication-config\" content=\"/mintlify-assets/_mintlify/favicons/soalinc/4u1ftEIw9BAC4ppo/_generated/favicon/browserconfig.xml\">\u003cmeta data-mint-head name=\"apple-mobile-web-app-title\" content=\"Soal Documentation\">\u003cmeta data-mint-head name=\"msapplication-TileColor\" content=\"#FFFFFF\">\u003clink data-mint-head rel=\"canonical\" href=\"https://soalinc.mintlify.app/integrations/snowflake\">\u003clink data-mint-head rel=\"alternate\" type=\"application/xml\" href=\"/sitemap.xml\">\u003clink data-mint-head rel=\"alternate\" type=\"text/markdown\" href=\"/integrations/snowflake.md\">\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https://soalinc.mintlify.app/#organization\",\"name\":\"Soal Documentation\",\"url\":\"https://soalinc.mintlify.app\",\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https://mintcdn.com/soalinc/39krj8Vh14GGxpzC/logo/light.svg?fit=max\u0026auto=format\u0026n=39krj8Vh14GGxpzC\u0026q=85\u0026s=390eb3e18fdd1d6630e4a020a9289c66\"}},{\"@type\":\"WebSite\",\"@id\":\"https://soalinc.mintlify.app#website\",\"name\":\"Soal Documentation\",\"url\":\"https://soalinc.mintlify.app\",\"publisher\":{\"@id\":\"https://soalinc.mintlify.app/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https://soalinc.mintlify.app/integrations/snowflake#webpage\",\"url\":\"https://soalinc.mintlify.app/integrations/snowflake\",\"name\":\"Snowflake\",\"dateModified\":\"2026-01-06T22:57:59.215Z\",\"isPartOf\":{\"@id\":\"https://soalinc.mintlify.app#website\"},\"breadcrumb\":{\"@id\":\"https://soalinc.mintlify.app/integrations/snowflake#breadcrumb\"}},{\"@type\":\"BreadcrumbList\",\"@id\":\"https://soalinc.mintlify.app/integrations/snowflake#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Soal Documentation\",\"item\":\"https://soalinc.mintlify.app\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Snowflake\",\"item\":\"https://soalinc.mintlify.app/integrations/snowflake\"}]},{\"@type\":[\"Article\",\"TechArticle\"],\"@id\":\"https://soalinc.mintlify.app/integrations/snowflake#article\",\"headline\":\"Snowflake\",\"name\":\"Snowflake\",\"url\":\"https://soalinc.mintlify.app/integrations/snowflake\",\"mainEntityOfPage\":{\"@id\":\"https://soalinc.mintlify.app/integrations/snowflake#webpage\"},\"dateModified\":\"2026-01-06T22:57:59.215Z\",\"publisher\":{\"@id\":\"https://soalinc.mintlify.app/#organization\"},\"isPartOf\":{\"@id\":\"https://soalinc.mintlify.app#website\"}}]}\u003c/script>\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@type\":\"WebSite\",\"name\":\"Soal Documentation\",\"publisher\":{\"@type\":\"Organization\",\"name\":\"Soal Documentation\"},\"provider\":{\"@type\":\"Organization\",\"name\":\"Mintlify\",\"url\":\"https://mintlify.com\"}}\u003c/script>","agentPointerHref":"/integrations/snowflake.md","siteName":"Soal Documentation","nav":{"global":{"anchors":[{"anchor":"Blog","href":"https://getsoal.com/blog","icon":"newspaper"}]},"anchors":[{"anchor":"Documentation","icon":"book-open","groups":[{"group":"⚙️ Setup","pages":[{"title":"Getting Started","href":"/setup/getting_started"},{"title":"Invite Users","href":"/setup/invite_users"},{"title":"Create Teams","href":"/setup/create_teams"},{"title":"Create Tags","href":"/setup/create_tags"},{"title":"Create Intake Forms","href":"/setup/create_intake_forms"}]},{"group":"🏅 Essentials","pages":[{"title":"Questions","href":"/essentials/questions"},{"title":"Notebooks","href":"/essentials/notebooks"},{"title":"Playbooks","href":"/essentials/playbooks"},{"title":"Recommendation Engine","href":"/essentials/recommendation_engine"},{"title":"Generated Queries","href":"/essentials/generated_queries"},{"title":"Analytics","description":null,"href":"/essentials/analytics"}]},{"group":"🔌 Integrations","pages":[{"group":"Cloud Data Warehouse","pages":[{"title":"Snowflake","href":"/integrations/snowflake"},{"title":"Redshift","description":null,"href":"/integrations/redshift"}]},{"group":"Messaging System","pages":[{"title":"Slack","href":"/integrations/slack"}]},{"group":"Business Intelligence","pages":[{"title":"Mode","href":"/integrations/mode"},{"title":null,"href":"/integrations/powerbi"},{"title":null,"href":"/integrations/tableau"}]},{"group":"Issue Tracker","pages":[{"title":"Jira","href":"/integrations/jira"}]}]},{"group":"🔐 Security and Compliance","pages":[{"title":null,"href":"/legal/terms_of_service"},{"title":null,"href":"/legal/privacy_policy"},{"title":null,"href":"/legal/data_retention_policy"},{"title":null,"href":"/legal/data_processing_agreement"},{"title":null,"href":"/legal/cookie_policy"}]}]}]},"basePath":"","title":"Snowflake - Soal Documentation","buildId":"dpl_Fyv1NbzwP68g2bEH2Roy98uY1zmE","deploymentId":"dpl_Fyv1NbzwP68g2bEH2Roy98uY1zmE","dynamics":[],"chunks":[]}