Snowflake · Schema

StreamSourceView

Data LakesData SharingData WarehousingDatabaseSQL

Properties

Name Type Description
append_only boolean Whether this stream is an append only stream or not
show_initial_rows boolean Whether this stream show initial rows on first consumption
point_of_time object Point of time for the stream
base_tables array List of base tables for the stream
View JSON Schema on GitHub

JSON Schema

snowflake-streamsourceview-schema.json Raw ↑
{
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "$id": "#/components/schemas/StreamSourceView",
  "title": "StreamSourceView",
  "type": "object",
  "allOf": [
    {
      "$ref": "#/components/schemas/StreamSource"
    }
  ],
  "properties": {
    "append_only": {
      "type": "boolean",
      "description": "Whether this stream is an append only stream or not",
      "example": true
    },
    "show_initial_rows": {
      "type": "boolean",
      "description": "Whether this stream show initial rows on first consumption",
      "example": true
    },
    "point_of_time": {
      "$ref": "#/components/schemas/PointOfTime",
      "description": "Point of time for the stream"
    },
    "base_tables": {
      "type": "array",
      "items": {
        "type": "string",
        "pattern": "^\"([^\"]|\"\")+\"|[a-zA-Z_][a-zA-Z0-9_$]*$"
      },
      "readOnly": true,
      "description": "List of base tables for the stream",
      "example": []
    }
  }
}