PostHog · Schema

DatabaseSchemaMaterializedViewTable

A/B TestingAnalyticsFeature FlagsOpen SourceProduct AnalyticsSession Recording

Properties

Name	Type	Description
fields	object
id	string
last_run_at	string
name	string
query	object
row_count	number
status	string
type	string

View JSON Schema on GitHub

JSON Schema

{
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "$id": "#/components/schemas/DatabaseSchemaMaterializedViewTable",
  "title": "DatabaseSchemaMaterializedViewTable",
  "additionalProperties": false,
  "properties": {
    "fields": {
      "additionalProperties": {
        "$ref": "#/components/schemas/DatabaseSchemaField"
      },
      "title": "Fields",
      "type": "object"
    },
    "id": {
      "title": "Id",
      "type": "string"
    },
    "last_run_at": {
      "default": null,
      "title": "Last Run At",
      "type": "string",
      "nullable": true
    },
    "name": {
      "title": "Name",
      "type": "string"
    },
    "query": {
      "$ref": "#/components/schemas/HogQLQuery"
    },
    "row_count": {
      "default": null,
      "title": "Row Count",
      "type": "number",
      "nullable": true
    },
    "status": {
      "default": null,
      "title": "Status",
      "type": "string",
      "nullable": true
    },
    "type": {
      "default": "materialized_view",
      "title": "Type",
      "type": "string",
      "enum": [
        "materialized_view"
      ]
    }
  },
  "required": [
    "fields",
    "id",
    "name",
    "query"
  ],
  "type": "object"
}