snowflake
Execute SQL
Run anomaly detection queries checking for data quality issues across key tables.
The agent runs scheduled anomaly detection queries against Snowflake to check for data quality issues such as null spikes, row count drops, or unexpected value distributions, and sends SMS alerts via Twilio to the on-call data engineer when thresholds are breached.
The scenario uses specific integration tools at each step, while Metorial keeps access scoped and visible.
Execute SQL checks for null rate spikes, unexpected row count changes, and value distribution anomalies across critical tables. Poll for async query completion.
Compare query results against defined anomaly thresholds to determine whether an alert is warranted and compose a concise incident summary.
Validate the on-call engineer's phone number and send an SMS alert with the anomaly type, affected table, severity, and a recommended investigation step.
snowflake
Run anomaly detection queries checking for data quality issues across key tables.
snowflake
Poll for completion of async anomaly detection queries.
twilio
Validate the on-call engineer's phone number before alerting.
twilio
Send an SMS alert with the anomaly summary and affected table details.
snowflake
Verify the anomaly detection task schedule is running as expected.
Integration
Execute SQL statements and manage cloud data warehouse resources on Snowflake. Run queries synchronously or asynchronously, manage databases, schemas, tables, warehouses, users, roles, grants, tasks, stages, streams, and pipes. Ingest data via Snowpipe batch loading or Snowpipe Streaming for low-latency continuous ingestion. Access Cortex AI services for search, inference, and embeddings. Configure outbound notifications to Slack, Microsoft Teams, PagerDuty, email, or cloud queues (SNS, PubSub, Event Grid). Supports multi-statement transactions, resource creation and alteration without SQL, and dynamic tables.
Integration
Send and receive SMS, MMS, WhatsApp, and RCS messages. Make, receive, and monitor phone calls with programmable call control. Verify user identities via OTP, TOTP, and silent network authentication. Look up phone number intelligence including carrier, line type, caller name, and SIM swap detection. Manage multi-channel conversations across chat, SMS, and WhatsApp. Search for and purchase phone numbers, configure voice and messaging endpoints, schedule messages for future delivery, and inspect call recording metadata.
Outcome 1
Metorial keeps the workflow connected, governed, and traceable across the systems involved.
Outcome 2
Metorial keeps the workflow connected, governed, and traceable across the systems involved.
Outcome 3
Metorial keeps the workflow connected, governed, and traceable across the systems involved.
Metorial is the governed connection layer between your AI agents and the tools your company runs on. It turns workflows like send sms alerts via twilio when snowflake anomaly queries detect data issues into something you can deploy quickly, safely, and at scale.
Fast
Connect 1000+ verified integrations through one Magic MCP URL instead of building and maintaining bespoke connectors for each system in this workflow.
Secure
Protoguard inspects every message and tool call for prompt injection and policy violations before an agent touches your systems.
Enterprise
Agents act on real identity under company SSO, with per-user and per-group access policies and a complete, searchable record of everything that happens.
Team ready
Package this workflow as a skill, attach the tools it needs, and let teammates run it through Portals — governed by admins, owned by the people who do the work.
The Metorial products that connect, govern, and observe this scenario.
Connectivity
Start from 1000+ verified integrations or bring your own, and give every one a governed path to your agents under existing SSO and access policies.
Connectivity
A single URL your AI client connects to. Sign in with the login you already use and your agent reaches every integration and tool you allow — no per-app setup.
Identity
Sign in with company SSO, set policies per user and group, and let agents act on real identity across every connected system in this workflow.
Governance
Metorial’s security layer reviews every message and tool request before an agent acts — catching prompt injection and blocking anything outside your policies.
Observability
A complete, searchable record of everything your agents, team, and machines do across these integrations, so you can trust the workflow in production.
Governance
Let teammates connect agents to the integrations and skills your company already uses, with admins deciding who gets access to what.
However you adopt AI, Metorial has a path for connecting it safely.
Solution
Give the agents behind this scenario governed access to every tool and integration they need, with one connection layer instead of bespoke glue code.
Solution
SSO, granular access control, security review, and full audit trails so this workflow meets enterprise governance and compliance requirements.
Solution
Let the people who do this work connect their own AI agents to approved integrations and reusable skills — safely, without waiting on engineering.