PostHog · Schema

DataWarehouseSavedQueryMinimal

Lightweight serializer for list views - excludes large query field to reduce memory usage.

A/B TestingAnalyticsFeature FlagsOpen SourceProduct AnalyticsSession Recording

Properties

Name	Type	Description
id	string
deleted	boolean
name	string
created_by	object
created_at	string
sync_frequency	string
columns	array
status	object	The status of when this SavedQuery last ran. * `Cancelled` - Cancelled * `Modified` - Modified * `Completed` - Completed * `Failed` - Failed * `Running` - Running
last_run_at	string
managed_viewset_kind	string
folder_id	string
folder_name	string
latest_error	string
is_materialized	boolean
origin	object	Where this SavedQuery is created. * `data_warehouse` - Data Warehouse * `endpoint` - Endpoint * `managed_viewset` - Managed Viewset
is_test	boolean	Whether this view is for testing only and will auto-expire.
expires_at	string	When this test view should be automatically deleted.
user_access_level	string	The effective access level the user has for this object

View JSON Schema on GitHub

JSON Schema

{
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "$id": "#/components/schemas/DataWarehouseSavedQueryMinimal",
  "title": "DataWarehouseSavedQueryMinimal",
  "type": "object",
  "description": "Lightweight serializer for list views - excludes large query field to reduce memory usage.",
  "properties": {
    "id": {
      "type": "string",
      "format": "uuid",
      "readOnly": true
    },
    "deleted": {
      "type": "boolean",
      "readOnly": true,
      "nullable": true
    },
    "name": {
      "type": "string",
      "readOnly": true
    },
    "created_by": {
      "allOf": [
        {
          "$ref": "#/components/schemas/UserBasic"
        }
      ],
      "readOnly": true
    },
    "created_at": {
      "type": "string",
      "format": "date-time",
      "readOnly": true
    },
    "sync_frequency": {
      "type": "string",
      "nullable": true,
      "readOnly": true
    },
    "columns": {
      "type": "array",
      "items": {
        "type": "object",
        "additionalProperties": true
      },
      "readOnly": true
    },
    "status": {
      "readOnly": true,
      "nullable": true,
      "description": "The status of when this SavedQuery last ran.\n\n* `Cancelled` - Cancelled\n* `Modified` - Modified\n* `Completed` - Completed\n* `Failed` - Failed\n* `Running` - Running",
      "oneOf": [
        {
          "$ref": "#/components/schemas/SavedQueryStatusEnum"
        },
        {
          "$ref": "#/components/schemas/NullEnum"
        }
      ]
    },
    "last_run_at": {
      "type": "string",
      "format": "date-time",
      "nullable": true,
      "readOnly": true
    },
    "managed_viewset_kind": {
      "type": "string",
      "nullable": true,
      "readOnly": true
    },
    "folder_id": {
      "type": "string",
      "format": "uuid",
      "readOnly": true,
      "nullable": true
    },
    "folder_name": {
      "type": "string",
      "readOnly": true,
      "nullable": true
    },
    "latest_error": {
      "type": "string",
      "readOnly": true,
      "nullable": true
    },
    "is_materialized": {
      "type": "boolean",
      "readOnly": true,
      "nullable": true
    },
    "origin": {
      "readOnly": true,
      "nullable": true,
      "description": "Where this SavedQuery is created.\n\n* `data_warehouse` - Data Warehouse\n* `endpoint` - Endpoint\n* `managed_viewset` - Managed Viewset",
      "oneOf": [
        {
          "$ref": "#/components/schemas/OriginEnum"
        },
        {
          "$ref": "#/components/schemas/NullEnum"
        }
      ]
    },
    "is_test": {
      "type": "boolean",
      "readOnly": true,
      "description": "Whether this view is for testing only and will auto-expire."
    },
    "expires_at": {
      "type": "string",
      "format": "date-time",
      "readOnly": true,
      "nullable": true,
      "description": "When this test view should be automatically deleted."
    },
    "user_access_level": {
      "type": "string",
      "nullable": true,
      "readOnly": true,
      "description": "The effective access level the user has for this object"
    }
  },
  "required": [
    "columns",
    "created_at",
    "created_by",
    "deleted",
    "expires_at",
    "folder_id",
    "folder_name",
    "id",
    "is_materialized",
    "is_test",
    "last_run_at",
    "latest_error",
    "managed_viewset_kind",
    "name",
    "origin",
    "status",
    "sync_frequency",
    "user_access_level"
  ]
}