Snowflake · Schema

MessageContentSqlObject

Data LakesData SharingData WarehousingDatabaseSQL
View JSON Schema on GitHub

JSON Schema

snowflake-messagecontentsqlobject-schema.json Raw ↑
{
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "$id": "#/components/schemas/MessageContentSqlObject",
  "title": "MessageContentSqlObject",
  "allOf": [
    {
      "$ref": "#/components/schemas/MessageContent"
    },
    {
      "title": "SQL",
      "type": "object",
      "description": "The SQL content that is part of a message.",
      "properties": {
        "statement": {
          "type": "string",
          "description": "The executable SQL statement",
          "example": "SELECT store, SUM(profit) FROM sales GROUP BY store"
        },
        "confidence": {
          "$ref": "#/components/schemas/Confidence"
        }
      },
      "required": [
        "statement"
      ]
    }
  ]
}