Snowflake Basic

Overview

Snowflake is a cloud-based data warehouse offering elastic scaling, secure data sharing, and SQL analytics across multiple cloud environments. With the Snowflake integration in SquadOS, your agents can run SQL queries, list databases and schemas, explore columns, and describe tables directly in your Snowflake account — without leaving the agent workflow.

• Official website: https://www.snowflake.com/
• Composio documentation: docs.composio.dev/toolkits/snowflake_basic

Authentication

This tool uses Basic auth (username/password) (BASIC) to connect.

You will need the following fields:

Field	Required	Description
username	Yes	Your Snowflake account username.
password	Yes	Your Snowflake account password.
account	Yes	Your Snowflake account identifier in the format orgname-accountname (e.g. myorg-myaccount). Found under Admin → Accounts in Snowflake.

See the Composio documentation to confirm the full list of required connection fields.

How to get credentials

1. Go to app.snowflake.com and log in with a user that has query access to the desired data.
2. To find your account identifier, go to Admin → Accounts and copy the value shown in the Account column. The format is orgname-accountname.
3. Make sure the user has the necessary privileges (USAGE on the warehouse, database, and schema that will be queried).

Tip

Create a dedicated user for SquadOS with read-only access (a custom role with SELECT on the relevant tables, or the SYSADMIN role scoped appropriately). This limits the access scope and simplifies usage auditing.

How to connect in SquadOS

1. Go to Tools in the side menu (/admin/tools).
2. Open the Available tab and search for Snowflake Basic.
3. Click the card to open the details modal and hit Connect.
4. You’re taken to the secure connection page hosted by Composio, where you enter the credentials obtained above.
5. Once done, you’re sent back to SquadOS with the account connected and the tool available to your agents. (Connection-flow details in Organization Tools.)

Available actions

Describe table

SNOWFLAKE_BASIC_DESCRIBE_TABLE

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

Input parameters

Name	Type	Required	Description
database	string	Yes	The name of the Snowflake database containing the table.
table_name	string	Yes	The name of the table to describe.
schema_name	string	Yes	The name of the schema within the database that contains the table.

Output

Name	Type	Required	Description
data	string	Yes	Data from the action execution.
error	string	No	Error if any occurred during the execution of the action.
successful	boolean	Yes	Whether or not the action execution was successful.

Explore columns

SNOWFLAKE_BASIC_EXPLORE_COLUMNS

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

Input parameters

Name	Type	Required	Description
limit	integer	No	The maximum number of distinct values to return for each specified column.
database	string	Yes	The name of the Snowflake database.
table_name	string	Yes	The name of the table within the specified schema.
schema_name	string	Yes	The name of the schema within the specified database.
column_names	array	No	A list of specific column names to explore. If left empty, all columns in the table will be explored.

Output

Name	Type	Required	Description
data	string	Yes	Data from the action execution.
error	string	No	Error if any occurred during the execution of the action.
successful	boolean	Yes	Whether or not the action execution was successful.

Run query

SNOWFLAKE_BASIC_RUN_QUERY

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

Input parameters

Name	Type	Required	Description
query	string	Yes	SQL query to execute; runs within the context of the specified database and schema.
database	string	Yes	Name of the Snowflake database.
schema_name	string	Yes	Name of the schema within the specified database.

Output

Name	Type	Required	Description
data	string	Yes	Data from the action execution.
error	string	No	Error if any occurred during the execution of the action.
successful	boolean	Yes	Whether or not the action execution was successful.

Show databases

SNOWFLAKE_BASIC_SHOW_DATABASES

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

Output

Name	Type	Required	Description
data	string	Yes	Data from the action execution.
error	string	No	Error if any occurred during the execution of the action.
successful	boolean	Yes	Whether or not the action execution was successful.

Show schemas

SNOWFLAKE_BASIC_SHOW_SCHEMAS

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

Input parameters

Name	Type	Required	Description
database	string	Yes	The name of the database for which to list schemas.

Output

Name	Type	Required	Description
data	string	Yes	Data from the action execution.
error	string	No	Error if any occurred during the execution of the action.
successful	boolean	Yes	Whether or not the action execution was successful.

Show tables

SNOWFLAKE_BASIC_SHOW_TABLES

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

Input parameters

Name	Type	Required	Description
database	string	Yes	The name of the database containing the schema from which to list tables.
schema_name	string	Yes	The name of the schema within the specified database for which to list tables.

Output

Name	Type	Required	Description
data	string	Yes	Data from the action execution.
error	string	No	Error if any occurred during the execution of the action.
successful	boolean	Yes	Whether or not the action execution was successful.