Snowflake
Overview
SLUG: SNOWFLAKE
Description
Snowflake is a cloud-based data warehouse offering elastic scaling, secure data sharing, and SQL analytics across multiple cloud environments
Authentication Details
Basic Auth
Connecting to Snowflake
Create an auth config
Use the dashboard to create an auth config for the Snowflake toolkit. This allows you to connect multiple Snowflake accounts to Composio for agents to use.
Create and Get auth config ID
Click “Create Integration”. After creation, copy the displayed ID starting with ac_
. This is your auth config ID. This is not a sensitive ID — you can save it in environment variables or a database.
This ID will be used to create connections to the toolkit for a given user.
Connect Your Account
Using Basic Auth
Tools
Executing tools
To prototype you can execute some tools to see the responses and working on the Snowflake toolkit’s playground
OpenAI (Python)
Anthropic (TypeScript)
Google (Python)
Vercel (TypeScript)
Tool List
SNOWFLAKE_DESCRIBE_TABLE
Tool Name: Describe table
Description
Action Parameters
Action Response
SNOWFLAKE_EXPLORE_COLUMNS
Tool Name: Explore Columns
Description
Action Parameters
Action Response
SNOWFLAKE_RUN_QUERY
Tool Name: Run Query
Description
Action Parameters
Action Response
SNOWFLAKE_SHOW_DATABASES
Tool Name: Show databases
Description
Action Parameters
Action Response
SNOWFLAKE_SHOW_SCHEMAS
Tool Name: Show schemas
Description
Action Parameters
Action Response
SNOWFLAKE_SHOW_TABLES
Tool Name: Show Tables
Description
Action Parameters
Action Response