01
Trigger on event
- Listen for a new event
- Parse and validate the payload
- Take an action with the linked tool
Snowflake Basic
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 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.
Common workflows with Snowflake Basic
02
Daily summary
- Pull yesterday's activity
- Summarise with the model of your choice
- Send the digest via email or Slack
03
Cross-tool sync
- Read records from one app
- Transform with a persona
- Write the result back via this integration
Snowflake Basic actions 6
Every Snowflake Basic action below is a callable tool any Definable persona can invoke.
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.
Airtable
Airtable merges spreadsheet functionality with database power, enabling teams to organize projects, track tasks, and collaborate through customizable views, automation, and integrations for data management
Baserow
Baserow is an open-source database tool that lets teams build no-code data applications, collaborate on records, and integrate with other services for data management
Bonsai
Bonsai is a fully managed Elasticsearch and OpenSearch hosting service, providing scalable search infrastructure with automatic backups, security, and monitoring.
Census Bureau
The Census Bureau Data API provides developers with access to a wide range of statistical data collected by the U.S. Census Bureau, facilitating integration into applications and data visualizations.
ClickHouse
ClickHouse is a fast open-source column-oriented database management system for real-time analytics and big data processing with SQL support
Elasticsearch
Elasticsearch is a distributed, RESTful search and analytics engine capable of addressing a growing number of use cases. It provides real-time search and analytics for all types of data.
Frequently asked questions
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.
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.
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.
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.
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.
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.
Ready to automate with Snowflake Basic?
Wire it up in minutes. No coding required.