Snowflake

Learn how to use Snowflake with Composio

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

username
stringRequired
password
stringRequired
subdomain
stringRequired

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.

1

Select App

Navigate to the Snowflake toolkit page and click “Setup Integration”.

2

Configure Auth Config Settings

Select among the supported auth schemes of and configure them here.

3

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

1from composio import Composio
2from composio.types import auth_scheme
3
4# Replace these with your actual values
5snowflake_auth_config_id = "ac_YOUR_SNOWFLAKE_CONFIG_ID"
6user_id = "user@example.com"
7username = "your_snowflake_username"
8password = "your_snowflake_password"
9
10composio = Composio()
11
12# Create a new connected account for Snowflake using Basic Auth
13connection_request = composio.connected_accounts.initiate(
14 user_id=user_id,
15 auth_config_id=snowflake_auth_config_id,
16 config=auth_scheme.basic_auth(
17 username=username,
18 password=password
19 )
20)
21
22# Basic authentication is immediate - no redirect needed
23print(f"Successfully connected Snowflake for user {user_id}")
24
25# You can verify the connection using:
26# connected_account = composio.connected_accounts.get(user_id=user_id, app_id="SNOWFLAKE")

Tools

Executing tools

To prototype you can execute some tools to see the responses and working on the Snowflake toolkit’s playground

Python
1from composio import Composio
2from openai import OpenAI
3import json
4
5openai = OpenAI()
6composio = Composio()
7
8# User ID must be a valid UUID format
9user_id = "0000-0000-0000" # Replace with actual user UUID from your database
10
11tools = composio.tools.get(user_id=user_id, toolkits=["SNOWFLAKE"])
12
13print("[!] Tools:")
14print(json.dumps(tools))
15
16def invoke_llm(task = "What can you do?"):
17 completion = openai.chat.completions.create(
18 model="gpt-4o",
19 messages=[
20 {
21 "role": "user",
22 "content": task, # Your task here!
23 },
24 ],
25 tools=tools,
26 )
27
28 # Handle Result from tool call
29 result = composio.provider.handle_tool_calls(user_id=user_id, response=completion)
30 print(f"[!] Completion: {completion}")
31 print(f"[!] Tool call result: {result}")
32
33invoke_llm()

Tool List

Tool Name: Describe table

Description

Retrieves detailed information for each column (including name, data type, kind, nullability, default value, and key status) in a specified snowflake table.

Action Parameters

database
stringRequired
schema_name
stringRequired
table_name
stringRequired

Action Response

data
objectRequired
error
string
successful
booleanRequired

Tool Name: Explore Columns

Description

Retrieves a sample of distinct values for specified columns from a snowflake table.

Action Parameters

column_names
array
database
stringRequired
limit
integerDefaults to 10
schema_name
stringRequired
table_name
stringRequired

Action Response

data
objectRequired
error
string
successful
booleanRequired

Tool Name: Run Query

Description

Executes the given sql query in snowflake within the specified database and schema (which must exist and be accessible), automatically setting context first.

Action Parameters

database
stringRequired
query
stringRequired
schema_name
stringRequired

Action Response

data
array
error
string
successful
booleanRequired

Tool Name: Show databases

Description

Retrieves a list of all databases available in the snowflake account.

Action Parameters

Action Response

data
objectRequired
error
string
successful
booleanRequired

Tool Name: Show schemas

Description

Retrieves a list of all schemas within a specified snowflake database.

Action Parameters

database
stringRequired

Action Response

data
objectRequired
error
string
successful
booleanRequired

Tool Name: Show Tables

Description

Retrieves a list of tables, including their row counts and sizes in bytes, from a specified schema within a snowflake database.

Action Parameters

database
stringRequired
schema_name
stringRequired

Action Response

data
objectRequired
error
string
successful
booleanRequired