Snowflake TRIGGER
New Usage Monitor
- Trigger
- Polling
- API key
- Webhook delivery
IMPLEMENTATION
Deploy this event source
Connect the user's Snowflake account, configure the source, and choose the webhook where your backend receives events.
import { PipedreamClient } from "@pipedream/sdk"
const pd = new PipedreamClient({
projectId: process.env.PIPEDREAM_PROJECT_ID!,
clientId: process.env.PIPEDREAM_CLIENT_ID!,
clientSecret: process.env.PIPEDREAM_CLIENT_SECRET!,
projectEnvironment: "production",
})
const deployed = await pd.triggers.deploy({
id: "snowflake-usage-monitor",
externalUserId: "{external_user_id}", // any stable ID for this user in your system
configuredProps: {
snowflake: { authProvisionId: "apn_xxxxxxx" },
timer: { "intervalSeconds": 900 },
warehouse: "Warehouse",
},
webhookUrl: "https://example.com/webhooks/snowflake",
})
console.log(deployed.id)curl -X POST https://api.pipedream.com/v1/connect/{project_id}/triggers/deploy \
-H "Content-Type: application/json" \
-H "X-PD-Environment: production" \
-H "Authorization: Bearer {access_token}" \
-d '{
"external_user_id": "{external_user_id}",
"id": "snowflake-usage-monitor",
"webhook_url": "https://example.com/webhooks/snowflake",
"configured_props": {
"snowflake": { "authProvisionId": "apn_xxxxxxx" },
"timer": { "intervalSeconds": 900 },
"warehouse": "Warehouse"
}
}'MCP servers expose Snowflake actions as on-demand tools.
New Usage Monitor is an event source, so your application deploys it
with the Connect SDK or API and then either receives each event at a
webhook URL or retrieves events on demand with the trigger events API.MCP exposes on-demand actions. Event sources are deployed through the Connect SDK or API because they continue listening after the initial request.
SCHEMA
Configuration
These inputs define which events the source watches. Dynamic options are loaded from the connected account.
| Property | Type | Description |
|---|---|---|
timer Timer | $.interface.timer | Watch for changes on this schedule Required |
warehouse Warehouse | string | The warehouse to monitor Optional |
database Database Name | string | The name of the database to monitor Optional |
username Username | string | The username to monitor Optional |
role Role | string | The role to monitor Optional |
schema Schema | string | The schema to monitor Optional |
totalElapsedTime Total Elapsed Time | string | Show register where TOTAL_ELAPSED_TIME >= requested value Optional |
bytesScanned Bytes Scanned | string | Show register where BYTES_SCANNED >= requested value Optional |
rowsProduced Rows Produced | string | Show register where ROWS_PRODUCED >= requested value Optional |
compilationTime Compilation Time | string | Show register where COMPILATION_TIME >= requested value Optional |
executionTime Execution Time | string | Show register where EXECUTION_TIME >= requested value Optional |
queuedProvisioningTime Queued Provisioning Time | string | Show register where QUEUED_PROVISIONING_TIME >= requested value Optional |
queueRepairTime Queue Repair Time | string | Show register where QUEUE_REPAIR_TIME >= requested value Optional |
queuedOverloadTime Queued Overload Time | string | Show register where QUEUED_OVERLOAD_TIME >= requested value Optional |
transactionBlockedTime Transaction Blocked Time | string | Show register where TRANSACTION_BLOCKED_TIME >= requested value Optional |
creditsUsedCloudServices Credit Used Cloud Services | string | Show register where CREDITS_USED_CLOUD_SERVICES >= requested value Optional |
LIFECYCLE
Event delivery
01
Connect
Your user authorizes Snowflake through Pipedream managed auth.
02
Deploy
Your backend deploys this source with that user's own configuration.
03
Webhook delivery
Every event is sent to the HTTP endpoint you choose when you deploy the source — after each poll.
OR
On-demand retrieval
No webhook required. Your app or agent can fetch recent events from the trigger events API.
REFERENCE
Trigger details
- Registry key
- snowflake-usage-monitor
- Version
- 0.1.5
- App
- Snowflake
- Authentication
- API key
- Delivery
- Polling source
- Output
- Events emitted by Snowflake.
- Source
- View on GitHub ↗