PostHog · Schema

WebTrendsQueryResponse

A/B TestingAnalyticsFeature FlagsOpen SourceProduct AnalyticsSession Recording

Properties

Name	Type	Description
clickhouse	string	Executed ClickHouse query
columns	array	Returned columns
error	string	Query error. Returned only if 'explain' or `modifiers.debug` is true. Throws an error otherwise.
explain	array	Query explanation output
hasMore	boolean
hogql	string	Generated HogQL query.
limit	integer
metadata	object	Query metadata output
modifiers	object	Modifiers used when performing the query
offset	integer
query	string	Input query string
query_status	object	Query status indicates whether next to the provided data, a query is still running.
resolved_date_range	object	The date range used for the query
results	array
samplingRate	object
timings	array	Measured timings for different parts of the query generation process
types	array	Types of returned columns
usedPreAggregatedTables	boolean

View JSON Schema on GitHub

JSON Schema

{
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "$id": "#/components/schemas/WebTrendsQueryResponse",
  "title": "WebTrendsQueryResponse",
  "additionalProperties": false,
  "properties": {
    "clickhouse": {
      "default": null,
      "description": "Executed ClickHouse query",
      "title": "Clickhouse",
      "type": "string",
      "nullable": true
    },
    "columns": {
      "default": null,
      "description": "Returned columns",
      "title": "Columns",
      "items": {},
      "type": "array",
      "nullable": true
    },
    "error": {
      "default": null,
      "description": "Query error. Returned only if 'explain' or `modifiers.debug` is true. Throws an error otherwise.",
      "title": "Error",
      "type": "string",
      "nullable": true
    },
    "explain": {
      "default": null,
      "description": "Query explanation output",
      "title": "Explain",
      "items": {
        "type": "string"
      },
      "type": "array",
      "nullable": true
    },
    "hasMore": {
      "default": null,
      "title": "Hasmore",
      "type": "boolean",
      "nullable": true
    },
    "hogql": {
      "default": null,
      "description": "Generated HogQL query.",
      "title": "Hogql",
      "type": "string",
      "nullable": true
    },
    "limit": {
      "default": null,
      "title": "Limit",
      "type": "integer",
      "nullable": true
    },
    "metadata": {
      "default": null,
      "description": "Query metadata output",
      "allOf": [
        {
          "$ref": "#/components/schemas/HogQLMetadataResponse"
        }
      ],
      "nullable": true
    },
    "modifiers": {
      "default": null,
      "description": "Modifiers used when performing the query",
      "allOf": [
        {
          "$ref": "#/components/schemas/HogQLQueryModifiers"
        }
      ],
      "nullable": true
    },
    "offset": {
      "default": null,
      "title": "Offset",
      "type": "integer",
      "nullable": true
    },
    "query": {
      "default": null,
      "description": "Input query string",
      "title": "Query",
      "type": "string",
      "nullable": true
    },
    "query_status": {
      "default": null,
      "description": "Query status indicates whether next to the provided data, a query is still running.",
      "allOf": [
        {
          "$ref": "#/components/schemas/QueryStatus"
        }
      ],
      "nullable": true
    },
    "resolved_date_range": {
      "default": null,
      "description": "The date range used for the query",
      "allOf": [
        {
          "$ref": "#/components/schemas/ResolvedDateRangeResponse"
        }
      ],
      "nullable": true
    },
    "results": {
      "items": {
        "$ref": "#/components/schemas/WebTrendsItem"
      },
      "title": "Results",
      "type": "array"
    },
    "samplingRate": {
      "default": null,
      "allOf": [
        {
          "$ref": "#/components/schemas/SamplingRate"
        }
      ],
      "nullable": true
    },
    "timings": {
      "default": null,
      "description": "Measured timings for different parts of the query generation process",
      "title": "Timings",
      "items": {
        "$ref": "#/components/schemas/QueryTiming"
      },
      "type": "array",
      "nullable": true
    },
    "types": {
      "default": null,
      "description": "Types of returned columns",
      "title": "Types",
      "items": {},
      "type": "array",
      "nullable": true
    },
    "usedPreAggregatedTables": {
      "default": null,
      "title": "Usedpreaggregatedtables",
      "type": "boolean",
      "nullable": true
    }
  },
  "required": [
    "results"
  ],
  "type": "object"
}