Snowflake

Snowflake

Cloud data warehouse — execute SQL, manage databases/schemas/tables, and read service status via the Snowflake SQL API.

OAuth14 tools

Three ways to use Snowflake

Chat with Geni

Ask Geni to pull data, take actions, or answer questions using this integration in a conversation.

Build a workflow

Create automated workflows that trigger on events, run on a schedule, or chain multiple tools together.

Power an app

Use this integration as a data source or action layer behind a dashboard, form, or internal tool.

Supported tools

Actions your AI agents can perform with Snowflake.

Cancel Statement Execution

Cancel a running SQL statement by its statement handle.

Tool

Check Statement Status

Poll the status of an async SQL statement and fetch additional result-set partitions.

Tool

Execute SQL Statement

Run a SQL statement (SELECT, DDL, or DML) and get the result set or statement handle.

Tool

Fetch Catalog Integration

Get configuration for an external Apache Iceberg catalog integration (Glue, Polaris, or REST).

Tool

Get Active Scheduled Maintenances

List scheduled maintenances currently in progress or being verified.

Tool

Get All Scheduled Maintenances

List the 50 most recent scheduled maintenances including completed ones.

Tool

Get started automating Snowflake

01Connect your accountLink your account securely with OAuth or an API key.
02Choose a trigger or toolPick the events and actions your workflow should use.
03Configure the workflowDescribe what you want and Geni wires it up for you.
04Refine the processTest runs, review output, and tweak until it's right.
05Turn it onSet it live and it runs on a schedule or on events.

Ready-to-use workflows

Prompts using Snowflake

Browse all

A searchable data catalog your business teams actually open

Every dbt model gets a page with a plain-English description, clickable lineage, and live freshness, so nobody has to ask what a table means.

dbt CloudSnowflake

Fivetran spend review board with pause and downgrade actions

Open one board to see which Fivetran connectors are driving your bill, get an agent's audit of the tables behind the rows, and pause or slow them on the spot.

FivetranSnowflakeGoogle Sheets

SQL Crafter: draft, explain, and review queries from your schema

Upload your schema, metric definitions, and sample rows. Geni drafts queries, explains the joins and grain, and flags risky assumptions before you run.

SnowflakePostgreSQLMySQLSQL Server

Sharpen and ship any data analysis

An assistant that turns a fuzzy data question into a clear, defensible answer with sound SQL, dataset checks, and a final quality pass before sharing.

PostgreSQLSnowflakeAirtableGoogle SheetsGoogle Drive+5

Daily Snowflake churn risk scores on every HubSpot contact

Each morning, score your active customers for churn risk from warehouse usage data and write the tier, score, and reason onto their HubSpot contact.

SnowflakeHubSpotSlack

Hourly Snowflake task failure tickets in Linear and Slack

Sweep Snowflake every hour for failed tasks, open a Linear ticket for each one, and post a Slack summary so nothing rots silently in the warehouse.

SnowflakeLinearSlack

Slack data Q&A bot powered by Snowflake

Let your team ask data questions in Slack and get answers from your Snowflake warehouse, with the SQL shown for review.

SnowflakeSlack

Daily Snowflake cost watchdog in Slack

Catch runaway warehouses, expensive queries, and budget overruns every morning before the Snowflake bill lands.

SnowflakeSlack Bot
+1Browse all prompts