View as Markdown
Snowflake icon

Snowflake TRIGGER

New Usage Monitor

Emit new event when a query is executed in the specified params
  • 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)

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.

New Usage Monitor configuration
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

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.

Registry key
snowflake-usage-monitor
Version
0.1.5
App
Snowflake
Authentication
API key
Delivery
Polling source
Output
Events emitted by Snowflake.