Snowflake

Snowflake Connection Guide

Data Bridge Pro provides native connectivity to Snowflake Data Cloud, supporting all editions and regions.

Connection Settings

SettingDescriptionExample
AccountAccount identifierxy12345.us-east-1
WarehouseCompute warehouseCOMPUTE_WH
DatabaseDatabase nameANALYTICS
SchemaSchema namePUBLIC

Finding Your Account ID

Your account identifier is in your Snowflake URL:

https://xy12345.us-east-1.snowflakecomputing.com
         ^^^^^^^^^^^^^^^^
         This is your account identifier

Authentication Methods

  • Username/Password: Standard authentication
  • SSO: Okta, Azure AD, other identity providers
  • Key Pair: For automated/service accounts

Required Permissions

GRANT USAGE ON WAREHOUSE COMPUTE_WH TO ROLE analyst_role;
GRANT USAGE ON DATABASE ANALYTICS TO ROLE analyst_role;
GRANT SELECT, INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA ANALYTICS.PUBLIC TO ROLE analyst_role;

Performance Tips

  • Use a dedicated warehouse for Data Bridge Pro
  • Enable auto-suspend to save credits
  • Use query result caching