Know when a Gist query has finished
Give long-running work a simple status follow-up, so you do not have to keep checking the console.
Trigger
Recurring schedule
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Action
Check Statement Status
Retrieves the status of a previously submitted sql statement. replace '{statementhandle}' with the unique identifier of the statement.
Why this helps
Repeatedly refreshing a query status page interrupts other work and makes follow-up easy to lose.
- Check a submitted statement using its Snowflake handle.
- Make query follow-up part of a recurring routine.
- Get a concise status report without repeated console visits.
Setup
Build it in a few focused steps.
- 1Connect Gist and Snowflake to Notis once through the portal.
- 2Create the automation in Automations or ask Notis to set up a recurring statement-status check.
- 3In one prompt, tell Notis how the run-tracking process provides the Snowflake statement handle and when to check it.
- 4Choose a schedule and a channel for run reports.
- 5Test with a real statement handle and confirm the reported status matches Snowflake.
Questions about this workflow
Can a status check work without a statement handle?
No. The Snowflake status action needs the unique handle for the previously submitted statement.
Can the schedule match our query duration?
Choose an interval appropriate for the queries you submit and the follow-up you need.
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.