See how shared Gist snippets are being used
Send a Gist reference to Notis and get a Snowflake usage summary in one workflow.
Trigger
Webhook received
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Action
Execute SQL
Tool to execute a sql statement and return the resulting data. use when you need to query data from snowflake.
Why this helps
You should not have to hunt through dashboards every time you share a useful snippet.
- Review usage from one request instead of opening analytics dashboards.
- Get a focused query result tied to the Gist reference.
- Reduce the chance that useful shared code gets overlooked.
Setup
Build it in a few focused steps.
- 1Connect Gist and Snowflake to Notis once through the portal.
- 2Create a new automation in Automations, or ask Notis to create it conversationally.
- 3In one plain-language prompt, tell Notis to query Snowflake for usage associated with the Gist reference received by the webhook.
- 4Choose an incoming webhook trigger and a channel for run reports.
- 5Send one real Gist reference to the webhook and confirm the query result is useful.
Questions about this workflow
Does Gist start this automation directly?
No. Gist has no integration trigger events in this setup. A connected backend sends a request to the Notis webhook with the Gist reference.
Do I need to map the Gist URL into a Snowflake field?
No. Describe in the prompt how Notis should use the received Gist reference when querying Snowflake.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Gist to Snowflake. A trigger fires from one place; an action lands in another.
Gist triggers
Snowflake actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Cancel Statement Execution
Cancels the execution of a running sql statement. use this action to stop a long-running query.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
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
Fetches details of a specific catalog integration.
Get Active Scheduled Maintenances
Retrieves a list of any active scheduled maintenances currently in the in progress or verifying state.
Get All Scheduled Maintenances
Retrieves a list of the 50 most recent scheduled maintenances, including those in the completed state.
Get Component Status
Retrieves the status of individual components, each listed with its current status.
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
Retrieves a summary of the status page, including status indicators, component statuses, unresolved incidents, and upcoming or in-progress scheduled maintenances.
Connect any two apps with Notis in the middle.
Gist and Snowflake, or any other combination from 1,000+ integrations.
When this happens · Trigger
Do this · Action
Save your first hour today.
7-day trial of any paid plan, with 20$ of usage included.
No card. Works with personal or business Snowflake.