Snowflake Integration
Connect Snowflake to Arahi's no-code AI developers and automate workflows in minutes.
About the Snowflake integration
A data warehouse built for the cloud With Arahi AI, you can connect Snowflake to Airtable, Directus, Fauna and 1,500+ other apps using AI-powered workflows. No coding required — set up triggers, actions, and intelligent automation in minutes.
- Category
- Databases
- Authentication
- keys
Snowflake automation use cases
- Form → row insertion
- Insert new rows into Snowflake from every form submission, webhook, or email with fields mapped.
- Scheduled archival
- Archive Snowflake rows older than N days to cold storage on a weekly cron.
- Change-data-capture broadcast
- Post Slack or email alerts when rows in Snowflake change specific columns or cross thresholds.
- CRM sync
- Keep Snowflake and your CRM in lockstep — two-way sync with conflict resolution rules.
Snowflake workflow examples
- Nightly BI dashboard refresh
Use Execute SQL on Snowflake each night and push the result rows into a Google Sheets tab powering the exec dashboard.
Nightly cron -> Snowflake Execute SQL -> Google Sheets refresh.
- Anomaly alert to Slack
Run Execute SQL on a metrics view, compare to last week's baseline, and post anomalies to Slack #data-alerts.
Hourly Execute SQL -> anomaly detected -> Slack #data-alerts.
- Warehouse status reporting
Call Get Status Summary on Snowflake and write outage notices to a Notion incident log plus an email to data engineering.
Snowflake Get Status Summary -> Notion log + Gmail to data team.
Snowflake actions
- Cancel Statement Execution","slug":"SNOWFLAKE_CANCEL_STATEMENT_EXECUTION
- Cancels the execution of a running SQL statement. Use this action to stop a long-running query.
- Check Statement Status","slug":"SNOWFLAKE_CHECK_STATEMENT_STATUS
- Retrieves the status of a previously submitted SQL statement. Replace '{statementHandle}' with the unique identifier of the statement.
- Execute SQL","slug":"SNOWFLAKE_EXECUTE_SQL
- Tool to execute a SQL statement and return the resulting data. Use when you need to query data from Snowflake.
- Fetch Catalog Integration","slug":"SNOWFLAKE_FETCH_CATALOG_INTEGRATION
- Fetches details of a specific catalog integration.
- Get Active Scheduled Maintenances","slug":"SNOWFLAKE_GET_ACTIVE_SCHEDULED_MAINTENANCES
- Retrieves a list of any active scheduled maintenances currently in the In Progress or Verifying state.
- Get All Scheduled Maintenances","slug":"SNOWFLAKE_GET_ALL_SCHEDULED_MAINTENANCES
- Retrieves a list of the 50 most recent scheduled maintenances, including those in the Completed state.
- Get Component Status","slug":"SNOWFLAKE_GET_COMPONENT_STATUS
- Retrieves the status of individual components, each listed with its current status.
- Get Status Rollup","slug":"SNOWFLAKE_GET_STATUS_ROLLUP
- Retrieves the status rollup for the entire page, including indicators and human-readable descriptions of the blended component status.
- Get Status Summary","slug":"SNOWFLAKE_GET_STATUS_SUMMARY
- Retrieves a summary of the status page, including status indicators, component statuses, unresolved incidents, and upcoming or in-progress scheduled maintenances.
- Get Unresolved Incidents","slug":"SNOWFLAKE_GET_UNRESOLVED_INCIDENTS
- Retrieves a list of any unresolved incidents currently in the Investigating, Identified, or Monitoring state.
- Get Upcoming Scheduled Maintenances","slug":"SNOWFLAKE_GET_UPCOMING_SCHEDULED_MAINTENANCES
- Retrieves a list of any upcoming scheduled maintenances still in the Scheduled state.
- Show Databases","slug":"SNOWFLAKE_SHOW_DATABASES
- Lists all databases for which you have access privileges. Shows database metadata including name, creation date, owner, retention time, and more. Can filter results and include dropped databases within Time Travel retention period.
- Show Schemas","slug":"SNOWFLAKE_SHOW_SCHEMAS
- Lists all schemas for which you have access privileges. Shows schema metadata including name, creation date, owner, database, retention time, and more. Can filter results and include dropped schemas within Time Travel retention period.
- Show Tables","slug":"SNOWFLAKE_SHOW_TABLES
- Lists all tables for which you have access privileges. Shows table metadata including name, creation date, owner, database, schema, row count, size in bytes, clustering keys, and more. Can filter results and include dropped tables within Time Travel retention period.
- Submit SQL Statement","slug":"SNOWFLAKE_SUBMIT_SQL_STATEMENT
- Submits a SQL statement for execution.