Snowflake · Schema

Alert

A Snowflake alert

Data LakesData SharingData WarehousingDatabaseSQL

Properties

Name	Type	Description
name	string	Name of the alert
comment	string	user comment associated to an object in the dictionary
schedule	object	The schedule the alert runs under
warehouse	string	The warehouse the alert runs in
condition	string	The SQL statement that must be evaluated to determine whether to trigger the alert
action	string	The SQL statement to execute when the alert is triggered
created_on	string	Date and time when the alert was created.
database_name	string	Database in which the alert is stored
schema_name	string	Schema in which the alert is stored
owner	string	Role that owns the alert
owner_role_type	string	The type of role that owns the alert
state	string	The current state of the alert

View JSON Schema on GitHub

JSON Schema

{
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "$id": "#/components/schemas/Alert",
  "title": "Alert",
  "type": "object",
  "description": "A Snowflake alert",
  "properties": {
    "name": {
      "type": "string",
      "description": "Name of the alert",
      "example": "Example Title"
    },
    "comment": {
      "type": "string",
      "description": "user comment associated to an object in the dictionary",
      "example": "example_value"
    },
    "schedule": {
      "$ref": "#/components/schemas/Schedule",
      "description": "The schedule the alert runs under"
    },
    "warehouse": {
      "type": "string",
      "description": "The warehouse the alert runs in",
      "example": "example_value"
    },
    "condition": {
      "type": "string",
      "description": "The SQL statement that must be evaluated to determine whether to trigger the alert",
      "example": "example_value"
    },
    "action": {
      "type": "string",
      "description": "The SQL statement to execute when the alert is triggered",
      "example": "example_value"
    },
    "created_on": {
      "type": "string",
      "format": "date-time",
      "readOnly": true,
      "description": "Date and time when the alert was created.",
      "example": "2026-01-15T10:30:00Z"
    },
    "database_name": {
      "type": "string",
      "readOnly": true,
      "description": "Database in which the alert is stored",
      "example": "example_value"
    },
    "schema_name": {
      "type": "string",
      "readOnly": true,
      "description": "Schema in which the alert is stored",
      "example": "example_value"
    },
    "owner": {
      "type": "string",
      "readOnly": true,
      "description": "Role that owns the alert",
      "example": "example_value"
    },
    "owner_role_type": {
      "type": "string",
      "readOnly": true,
      "description": "The type of role that owns the alert",
      "example": "example_value"
    },
    "state": {
      "type": "string",
      "readOnly": true,
      "description": "The current state of the alert",
      "example": "example_value"
    }
  },
  "required": [
    "name",
    "schedule",
    "condition",
    "action"
  ]
}