# New Usage Monitor — Snowflake

> Emit new event when a query is executed in the specified params

- Key: `snowflake-usage-monitor`
- Type: Trigger (Polling)
- Version: 0.1.5
- App: Snowflake (`snowflake`) — https://pipedream.com/apps/snowflake.md
- This page (HTML): https://pipedream.com/apps/snowflake/triggers/usage-monitor
- Source: https://github.com/PipedreamHQ/pipedream/blob/master/components/snowflake/sources/usage-monitor/usage-monitor.mjs

## Props

| Prop | Type | Required | Description |
|---|---|---|---|
| `timer` | `$.interface.timer` | Yes | Watch for changes on this schedule |
| `warehouse` | `string` | No | The warehouse to monitor |
| `database` | `string` | No | The name of the database to monitor |
| `username` | `string` | No | The username to monitor |
| `role` | `string` | No | The role to monitor |
| `schema` | `string` | No | The schema to monitor |
| `totalElapsedTime` | `string` | No | Show register where TOTAL_ELAPSED_TIME >= requested value |
| `bytesScanned` | `string` | No | Show register where BYTES_SCANNED >= requested value |
| `rowsProduced` | `string` | No | Show register where ROWS_PRODUCED >= requested value |
| `compilationTime` | `string` | No | Show register where COMPILATION_TIME >= requested value |
| `executionTime` | `string` | No | Show register where EXECUTION_TIME >= requested value |
| `queuedProvisioningTime` | `string` | No | Show register where QUEUED_PROVISIONING_TIME >= requested value |
| `queueRepairTime` | `string` | No | Show register where QUEUE_REPAIR_TIME >= requested value |
| `queuedOverloadTime` | `string` | No | Show register where QUEUED_OVERLOAD_TIME >= requested value |
| `transactionBlockedTime` | `string` | No | Show register where TRANSACTION_BLOCKED_TIME >= requested value |
| `creditsUsedCloudServices` | `string` | No | Show register where CREDITS_USED_CLOUD_SERVICES >= requested value |

## Returns

Events emitted by Snowflake.

## Run it

**TypeScript**

```ts
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**

```bash
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**

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.

## Event delivery

Every event is sent to the HTTP endpoint you choose when you deploy the source. Or: no webhook required — your app or agent can fetch recent events from the [trigger events API](https://pipedream.com/docs/connect/api-reference/list-trigger-events.md) instead.

---

- App: https://pipedream.com/apps/snowflake.md · All apps: https://pipedream.com/apps