# Snowflake Basic AI integration on Definable

> Snowflake is a cloud-based data warehouse offering elastic scaling, secure data sharing, and SQL analytics across multiple cloud environments

## What this connects

Snowflake is a cloud-based data warehouse offering elastic scaling, secure data sharing, and SQL analytics across multiple cloud environments

Vendor: https://www.snowflake.com/en/

## Tools available

**6** tools available. First 6:

- `SNOWFLAKE_BASIC_DESCRIBE_TABLE` — Describe table — Retrieves detailed information for each column (including name, data type, kind, nullability, default value, and key status) in a specified Snowflake table.
- `SNOWFLAKE_BASIC_EXPLORE_COLUMNS` — Explore Columns — Retrieves a sample of distinct values for specified columns from a Snowflake table.
- `SNOWFLAKE_BASIC_RUN_QUERY` — 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.
- `SNOWFLAKE_BASIC_SHOW_DATABASES` — Show databases — Retrieves a list of all databases available in the Snowflake account.
- `SNOWFLAKE_BASIC_SHOW_SCHEMAS` — Show schemas — Retrieves a list of all schemas within a specified Snowflake database.
- `SNOWFLAKE_BASIC_SHOW_TABLES` — Show Tables — Retrieves a list of tables, including their row counts and sizes in bytes, from a specified schema within a Snowflake database.

## Auth

Auth schemes: `BASIC`.

## How agents use Snowflake Basic

Inside a Definable workflow, Snowflake Basic is one of the tools the **Distributor specialist** can call. Example coordination patterns:

- **Researcher → Snowflake Basic** — the Researcher (GPT-5.5) pulls context from Snowflake Basic (records, threads, documents), synthesises findings, and briefs the rest of the team.
- **Writer → Distributor → Snowflake Basic** — the Writer (Claude Opus 4.7) drafts copy in brand voice, the Verifier passes it, then the Distributor writes the result into Snowflake Basic (create record, post message, draft email).
- **Designer / Engineer → Distributor → Snowflake Basic** — the Designer ships an asset or the Engineer ships a code change, the Distributor delivers it via Snowflake Basic (attach file, open PR comment, post status).

The Verifier checks every Snowflake Basic call. On rate limit, schema drift, or auth refresh it self-heals and retries — the workflow completes without manual intervention.

## Categories

- databases — https://definable.ai/apps/category/databases/
- analytics — https://definable.ai/apps/category/analytics/

## Related

- HTML page: https://definable.ai/apps/snowflake_basic/
- Same category (databases): https://definable.ai/apps/category/databases/
- All integrations: https://definable.ai/apps/
- Workflow (multi-agent loop): https://definable.ai/workflow/
- Apps llms.txt index: https://definable.ai/llms-apps.txt