Snowflake Basic

databases 6 tools available

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

Connect Snowflake Basic Visit Snowflake Basic

About this integration

Connect Snowflake Basic to Definable to automate repetitive tasks, sync data with the rest of your stack, trigger on real-world events. Personas call Snowflake Basic's 6 tools directly from chat or scheduled flows. You can wire it into any persona to read, write, and react when an event fires.

Connect Snowflake Basic to Definable and it becomes a set of typed tools your agents plan with — triggered by events, run on schedules, or invoked mid-conversation. Every write is checked by the verifier before it lands.

Auth OAuth2 · 2 clicks

Tools 6 exposed

Plans All, incl. Free

Data Never trained on

Snowflake Basic · in workflows

What teams actually run.

Three patterns teams run with Snowflake Basic on day one. Each one is a plain-English prompt — no canvas, no glue code — and you can remix them into anything.

Trigger on event

│ Listen for a new event

│ Parse and validate the payload

└ Take an action with the linked tool

Daily summary

│ Pull yesterday's activity

│ Summarise with the model of your choice

└ Send the digest via email or Slack

Cross-tool sync

│ Read records from one app

│ Transform with a persona

└ Write the result back via this integration

6 tools available

The Snowflake Basic toolbox.

Every Snowflake Basic capability your agents can call, each with a typed schema the planner reads. The router picks the right tool per step; the verifier checks the result.

Describe table

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

Explore Columns

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

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.

Show databases

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

Show schemas

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

Show Tables

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

See it run

One prompt, start to finish.

A real prompt, the Snowflake Basic tools it calls, and what comes back. This is the whole interface — describe the outcome, agents handle the rest.

❯

Run a real Snowflake Basic task end-to-end — plan it, execute across the API, and hand back a verified result.

snowflake_basic.describe_table Retrieves detailed information for each column (including name, data type, kind, nullabili

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

snowflake_basic.run_query Executes the given SQL query in Snowflake within the specified database and schema (which · verified

done

Done. Snowflake Basic responded across 3 calls, the verifier signed off, and the result is logged with every payload.

FAQ · Snowflake Basic

Questions, answered.

What teams ask before connecting Snowflake Basic.

01 What can I automate with Snowflake Basic on Definable?

Anything Snowflake Basic exposes through its API. Common databases workflows on Definable include automate repetitive tasks, sync data with the rest of your stack, trigger on real-world events. Personas can call any of the 6 Snowflake Basic tools directly, then chain the result into another integration without you writing code.

02 How does Snowflake Basic authentication work?

Snowflake Basic uses BASIC on Definable. You connect once from the integrations page, scoped to the permissions you choose, and from then on any persona that has the integration enabled can act on your behalf. Tokens are encrypted at rest and rotated automatically.

03 Is the Snowflake Basic integration included in my Definable plan?

Yes — every Definable plan, including Starter, includes access to all 6 Snowflake Basic tools. You only need a separate Snowflake Basic subscription if Snowflake Basic itself charges per seat or per API call.

04 Is using Snowflake Basic through Definable secure?

Every call from a persona to Snowflake Basic is logged with the user, persona, prompt, and response. Tokens never leave Definable's secrets vault, scopes are configurable per persona, and you can revoke access at any time from the integration page.

05 How do I get started with Snowflake Basic on Definable?

Sign up for Definable, open the integrations page, find Snowflake Basic, and connect via OAuth or API key. You can immediately attach Snowflake Basic to any persona and start running workflows. The free Starter plan includes 5,000 credits/month.

06 What Snowflake Basic actions does Definable expose?

Definable exposes all 6 Snowflake Basic actions as callable tools — including `Describe table`, `Explore Columns`, `Run Query`, plus 3 more. Each tool gets a typed parameter schema so personas know exactly how to call it.