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

posthog-datawarehousesavedqueryminimal-schema.json Raw ↑
{
  "$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"
  ]
}

Work with this as data

Every JSON Schema here is available over the APIs.io API and to AI agents over MCP.

MCP server

One button, every client — Claude, Cursor, VS Code and the rest.

https://apis.io/mcp

Tools for schemas

4 MCP tools reach this
  • find_json_schemasBrowse and filter every JSON Schema in the catalog.
  • apis_io_searchSTART HERE — APIs, providers and tags for one query, each with its total.
  • resolveTurn a domain, URL or GitHub org into the provider it belongs to.
  • find_cohortsEvery scored population of providers in the catalog.
All 92 tools →

Call it yourself

curl for this page
This JSON Schema
curl "https://apis.io/api/v1/json-schemas/posthog-datawarehousesavedqueryminimal"
All schemas
curl "https://apis.io/api/v1/json-schemas?limit=25"

Discovery needs no key. Ratings and market analysis are Pro.

Get an API key

Free tier, no form to fill in. Signing in shares your email address with us — we store it to create your key and to recognise you if you sign in with another provider. See our Privacy Policy and Terms.

A second provider on the same verified email joins the account you already have.