Skip to main content
Connect Adapt to Snowflake to query your data warehouse using natural language. Adapt can write and execute SQL queries against your Snowflake tables.

​
Setup

1

Get your Snowflake credentials

You’ll need:
  • Account identifier (e.g., abc12345.us-east-1)
  • Warehouse name
  • Database and schema
  • Username and password (or key pair)
2

Go to Settings

Navigate to Settings > Integrations in Adapt
3

Add secrets

Add the following secrets:
Secret NameValue
SNOWFLAKE_ACCOUNTYour account identifier
SNOWFLAKE_WAREHOUSEWarehouse name
SNOWFLAKE_DATABASEDatabase name
SNOWFLAKE_SCHEMASchema name
SNOWFLAKE_USERUsername
SNOWFLAKE_PASSWORDPassword
4

Test the connection

Ask Adapt to query your Snowflake data
For key pair authentication, use SNOWFLAKE_PRIVATE_KEY instead of SNOWFLAKE_PASSWORD.

​
Security

  • Credentials are encrypted at rest with AES-256
  • We recommend using a read-only Snowflake user
  • Consider using a dedicated warehouse for Adapt queries
  • All queries are logged for audit purposes

​
Capabilities

Adapt can query your Snowflake data warehouse. Run SQL queries using natural language to analyze your data.

​
Examples

Explore data: 
What tables are available in Snowflake?
Query data: 
Show me the top 10 customers by revenue from the sales table
Analyze trends: 
Analyze trends in the orders table over the past year
Generate reports: 
Create a summary of our key metrics from Snowflake