DataLens API: Create dataset

Статья создана

Обновлена 16 января 2026 г.

HTTP request
Body parameters
DatasetContentInternal
AvatarRelation
JoinCondition
direct1
formula2
result_field
ComponentErrorList
ComponentErrorPack
ComponentError
ObligatoryFilter
Where
ResultSchemaSchemaGeneric
ParameterValueConstraint
ResultSchemaAux
FieldInterDependencyInfo
FieldInterDependencyItem
RLS2ConfigEntry
RLSSubject
SourceAvatarStrict
DataSourceStrict
SQLParameters
CHYTTableListParameters
CHYTTableRangeParameters
SubselectParameters
SchematizedParameters
SimpleParameters
Options
Connections
CompatConnectionTypeListItem
ConnectionListItem
DataTypes
DataTypeListItem
Fields
FieldListItem
Join
Preview
Avatars
SourceListItem
SourceListing
Sources
CompatSourceTypeListItem
SourceListItem1
Response
DatasetContentInternal
AvatarRelation
JoinCondition
direct1
formula2
result_field
ComponentErrorList
ComponentErrorPack
ComponentError
ObligatoryFilter
Where
ResultSchemaSchemaGeneric
ParameterValueConstraint
ResultSchemaAux
FieldInterDependencyInfo
FieldInterDependencyItem
RLS2ConfigEntry
RLSSubject
SourceAvatarStrict
DataSourceStrict
SQLParameters
CHYTTableListParameters
CHYTTableRangeParameters
SubselectParameters
SchematizedParameters
SimpleParameters
Options
Connections
CompatConnectionTypeListItem
ConnectionListItem
DataTypes
DataTypeListItem
Fields
FieldListItem
Join
Preview
Avatars
SourceListItem
SourceListing
Sources
CompatSourceTypeListItem
SourceListItem1

HTTP request

POST https://api.datalens.yandex.net/rpc/createDataset

Body parameters

Request schema: application/json

{
  "created_via": "unknown",
  "dataset": {
    "avatar_relations": [
      {
        "conditions": [
          {
            "left": {
              "<oneOf>": [
                {
                  "calc_mode": "string",
                  "source": "string"
                },
                {
                  "calc_mode": "string",
                  "formula": "string"
                },
                {
                  "calc_mode": "string",
                  "field_id": "string"
                }
              ]
            },
            "operator": "string",
            "right": {
              "<oneOf>": [
                {
                  "calc_mode": "string",
                  "source": "string"
                },
                {
                  "calc_mode": "string",
                  "formula": "string"
                },
                {
                  "calc_mode": "string",
                  "field_id": "string"
                }
              ]
            },
            "type": "string"
          }
        ],
        "id": "string",
        "join_type": "string",
        "left_avatar_id": "string",
        "managed_by": "string | null",
        "required": "boolean",
        "right_avatar_id": "string",
        "virtual": "unknown"
      }
    ],
    "component_errors": {
      "items": [
        {
          "errors": [
            {
              "code": "unknown",
              "details": {
                "string": "unknown"
              },
              "level": "string",
              "message": "string"
            }
          ],
          "id": "string",
          "type": "string"
        }
      ]
    },
    "data_export_forbidden": "boolean",
    "description": "string | null",
    "load_preview_by_default": "boolean",
    "obligatory_filters": [
      {
        "default_filters": [
          {
            "column": "string",
            "operation": "string",
            "values": "array | null"
          }
        ],
        "field_guid": "string",
        "id": "string",
        "managed_by": "string | null",
        "valid": "boolean"
      }
    ],
    "preview_enabled": "boolean",
    "result_schema": [
      {
        "<oneOf>": [
          {
            "aggregation": "string",
            "aggregation_locked": "boolean | null",
            "autoaggregated": "boolean | null",
            "avatar_id": "string | null",
            "cast": "string",
            "data_type": "string | null",
            "description": "string",
            "guid": "string",
            "has_auto_aggregation": "boolean | null",
            "hidden": "boolean",
            "initial_data_type": "string | null",
            "lock_aggregation": "boolean | null",
            "managed_by": "string | null",
            "source": "string",
            "title": "string",
            "type": "string",
            "ui_settings": "string",
            "valid": "boolean | null",
            "virtual": "unknown"
          },
          {
            "aggregation": "string",
            "aggregation_locked": "boolean | null",
            "autoaggregated": "boolean | null",
            "cast": "string",
            "data_type": "string | null",
            "description": "string",
            "formula": "string",
            "guid": "string",
            "guid_formula": "string",
            "has_auto_aggregation": "boolean | null",
            "hidden": "boolean",
            "initial_data_type": "string | null",
            "lock_aggregation": "boolean | null",
            "managed_by": "string | null",
            "title": "string",
            "type": "string",
            "ui_settings": "string",
            "valid": "boolean | null",
            "virtual": "unknown"
          },
          {
            "aggregation": "string",
            "aggregation_locked": "boolean | null",
            "autoaggregated": "boolean | null",
            "cast": "string",
            "data_type": "string | null",
            "default_value": "string | null",
            "description": "string",
            "guid": "string",
            "has_auto_aggregation": "boolean | null",
            "hidden": "boolean",
            "initial_data_type": "string | null",
            "lock_aggregation": "boolean | null",
            "managed_by": "string | null",
            "template_enabled": "boolean",
            "title": "string",
            "type": "string",
            "ui_settings": "string",
            "valid": "boolean | null",
            "value_constraint": "unknown",
            "virtual": "unknown"
          }
        ]
      }
    ],
    "result_schema_aux": {
      "inter_dependencies": {
        "deps": [
          {
            "dep_field_id": "string",
            "ref_field_ids": [
              "string"
            ]
          }
        ]
      }
    },
    "revision_id": "string | null",
    "rls": {
      "string": "unknown"
    },
    "rls2": {
      "string": "array"
    },
    "source_avatars": [
      {
        "id": "string",
        "is_root": "boolean",
        "managed_by": "string | null",
        "source_id": "string",
        "title": "string",
        "valid": "boolean",
        "virtual": "unknown"
      }
    ],
    "sources": [
      {
        "<oneOf>": [
          {
            "connection_id": "string | null",
            "id": "string",
            "index_info_set": "array | null",
            "managed_by": "string | null",
            "parameter_hash": "string",
            "parameters": {
              "db_name": "string | null",
              "db_version": "string | null",
              "table_name": "string | null"
            },
            "raw_schema": "array | null",
            "source_type": "APPMETRICA_API",
            "title": "string",
            "valid": "boolean",
            "virtual": "unknown"
          },
          {
            "connection_id": "string | null",
            "id": "string",
            "index_info_set": "array | null",
            "managed_by": "string | null",
            "parameter_hash": "string",
            "parameters": {
              "db_name": "string | null",
              "db_version": "string | null",
              "table_name": "string | null"
            },
            "raw_schema": "array | null",
            "source_type": "CHYT_TABLE",
            "title": "string",
            "valid": "boolean",
            "virtual": "unknown"
          },
          {
            "connection_id": "string | null",
            "id": "string",
            "index_info_set": "array | null",
            "managed_by": "string | null",
            "parameter_hash": "string",
            "parameters": {
              "table_names": "string"
            },
            "raw_schema": "array | null",
            "source_type": "CHYT_TABLE_LIST",
            "title": "string",
            "valid": "boolean",
            "virtual": "unknown"
          },
          {
            "connection_id": "string | null",
            "id": "string",
            "index_info_set": "array | null",
            "managed_by": "string | null",
            "parameter_hash": "string",
            "parameters": {
              "directory_path": "string",
              "range_from": "string",
              "range_to": "string"
            },
            "raw_schema": "array | null",
            "source_type": "CHYT_TABLE_RANGE",
            "title": "string",
            "valid": "boolean",
            "virtual": "unknown"
          },
          {
            "connection_id": "string | null",
            "id": "string",
            "index_info_set": "array | null",
            "managed_by": "string | null",
            "parameter_hash": "string",
            "parameters": {
              "subsql": "string"
            },
            "raw_schema": "array | null",
            "source_type": "CHYT_SUBSELECT",
            "title": "string",
            "valid": "boolean",
            "virtual": "unknown"
          },
          {
            "connection_id": "string | null",
            "id": "string",
            "index_info_set": "array | null",
            "managed_by": "string | null",
            "parameter_hash": "string",
            "parameters": {
              "db_name": "string | null",
              "db_version": "string | null",
              "table_name": "string | null"
            },
            "raw_schema": "array | null",
            "source_type": "CHYT_USER_AUTH_TABLE",
            "title": "string",
            "valid": "boolean",
            "virtual": "unknown"
          },
          {
            "connection_id": "string | null",
            "id": "string",
            "index_info_set": "array | null",
            "managed_by": "string | null",
            "parameter_hash": "string",
            "parameters": {
              "table_names": "string"
            },
            "raw_schema": "array | null",
            "source_type": "CHYT_USER_AUTH_TABLE_LIST",
            "title": "string",
            "valid": "boolean",
            "virtual": "unknown"
          },
          {
            "connection_id": "string | null",
            "id": "string",
            "index_info_set": "array | null",
            "managed_by": "string | null",
            "parameter_hash": "string",
            "parameters": {
              "directory_path": "string",
              "range_from": "string",
              "range_to": "string"
            },
            "raw_schema": "array | null",
            "source_type": "CHYT_USER_AUTH_TABLE_RANGE",
            "title": "string",
            "valid": "boolean",
            "virtual": "unknown"
          },
          {
            "connection_id": "string | null",
            "id": "string",
            "index_info_set": "array | null",
            "managed_by": "string | null",
            "parameter_hash": "string",
            "parameters": {
              "subsql": "string"
            },
            "raw_schema": "array | null",
            "source_type": "CHYT_USER_AUTH_SUBSELECT",
            "title": "string",
            "valid": "boolean",
            "virtual": "unknown"
          },
          {
            "connection_id": "string | null",
            "id": "string",
            "index_info_set": "array | null",
            "managed_by": "string | null",
            "parameter_hash": "string",
            "parameters": {
              "db_name": "string | null",
              "db_version": "string | null",
              "table_name": "string | null"
            },
            "raw_schema": "array | null",
            "source_type": "CH_TABLE",
            "title": "string",
            "valid": "boolean",
            "virtual": "unknown"
          },
          {
            "connection_id": "string | null",
            "id": "string",
            "index_info_set": "array | null",
            "managed_by": "string | null",
            "parameter_hash": "string",
            "parameters": {
              "subsql": "string"
            },
            "raw_schema": "array | null",
            "source_type": "CH_SUBSELECT",
            "title": "string",
            "valid": "boolean",
            "virtual": "unknown"
          },
          {
            "connection_id": "string | null",
            "id": "string",
            "index_info_set": "array | null",
            "managed_by": "string | null",
            "parameter_hash": "string",
            "parameters": {
              "db_name": "string | null",
              "db_version": "string | null",
              "schema_name": "string | null",
              "table_name": "string | null"
            },
            "raw_schema": "array | null",
            "source_type": "GP_TABLE",
            "title": "string",
            "valid": "boolean",
            "virtual": "unknown"
          },
          {
            "connection_id": "string | null",
            "id": "string",
            "index_info_set": "array | null",
            "managed_by": "string | null",
            "parameter_hash": "string",
            "parameters": {
              "subsql": "string"
            },
            "raw_schema": "array | null",
            "source_type": "GP_SUBSELECT",
            "title": "string",
            "valid": "boolean",
            "virtual": "unknown"
          },
          {
            "connection_id": "string | null",
            "id": "string",
            "index_info_set": "array | null",
            "managed_by": "string | null",
            "parameter_hash": "string",
            "parameters": {},
            "raw_schema": "array | null",
            "source_type": "GSHEETS",
            "title": "string",
            "valid": "boolean",
            "virtual": "unknown"
          },
          {
            "connection_id": "string | null",
            "id": "string",
            "index_info_set": "array | null",
            "managed_by": "string | null",
            "parameter_hash": "string",
            "parameters": {},
            "raw_schema": "array | null",
            "source_type": "JSON_API",
            "title": "string",
            "valid": "boolean",
            "virtual": "unknown"
          },
          {
            "connection_id": "string | null",
            "id": "string",
            "index_info_set": "array | null",
            "managed_by": "string | null",
            "parameter_hash": "string",
            "parameters": {
              "db_name": "string | null",
              "db_version": "string | null",
              "table_name": "string | null"
            },
            "raw_schema": "array | null",
            "source_type": "METRIKA_API",
            "title": "string",
            "valid": "boolean",
            "virtual": "unknown"
          },
          {
            "connection_id": "string | null",
            "id": "string",
            "index_info_set": "array | null",
            "managed_by": "string | null",
            "parameter_hash": "string",
            "parameters": {
              "db_name": "string | null",
              "db_version": "string | null",
              "schema_name": "string | null",
              "table_name": "string | null"
            },
            "raw_schema": "array | null",
            "source_type": "MSSQL_TABLE",
            "title": "string",
            "valid": "boolean",
            "virtual": "unknown"
          },
          {
            "connection_id": "string | null",
            "id": "string",
            "index_info_set": "array | null",
            "managed_by": "string | null",
            "parameter_hash": "string",
            "parameters": {
              "subsql": "string"
            },
            "raw_schema": "array | null",
            "source_type": "MSSQL_SUBSELECT",
            "title": "string",
            "valid": "boolean",
            "virtual": "unknown"
          },
          {
            "connection_id": "string | null",
            "id": "string",
            "index_info_set": "array | null",
            "managed_by": "string | null",
            "parameter_hash": "string",
            "parameters": {
              "db_name": "string | null",
              "db_version": "string | null",
              "table_name": "string | null"
            },
            "raw_schema": "array | null",
            "source_type": "MYSQL_TABLE",
            "title": "string",
            "valid": "boolean",
            "virtual": "unknown"
          },
          {
            "connection_id": "string | null",
            "id": "string",
            "index_info_set": "array | null",
            "managed_by": "string | null",
            "parameter_hash": "string",
            "parameters": {
              "subsql": "string"
            },
            "raw_schema": "array | null",
            "source_type": "MYSQL_SUBSELECT",
            "title": "string",
            "valid": "boolean",
            "virtual": "unknown"
          },
          {
            "connection_id": "string | null",
            "id": "string",
            "index_info_set": "array | null",
            "managed_by": "string | null",
            "parameter_hash": "string",
            "parameters": {
              "db_name": "string | null",
              "db_version": "string | null",
              "schema_name": "string | null",
              "table_name": "string | null"
            },
            "raw_schema": "array | null",
            "source_type": "ORACLE_TABLE",
            "title": "string",
            "valid": "boolean",
            "virtual": "unknown"
          },
          {
            "connection_id": "string | null",
            "id": "string",
            "index_info_set": "array | null",
            "managed_by": "string | null",
            "parameter_hash": "string",
            "parameters": {
              "subsql": "string"
            },
            "raw_schema": "array | null",
            "source_type": "ORACLE_SUBSELECT",
            "title": "string",
            "valid": "boolean",
            "virtual": "unknown"
          },
          {
            "connection_id": "string | null",
            "id": "string",
            "index_info_set": "array | null",
            "managed_by": "string | null",
            "parameter_hash": "string",
            "parameters": {
              "db_name": "string | null",
              "db_version": "string | null",
              "schema_name": "string | null",
              "table_name": "string | null"
            },
            "raw_schema": "array | null",
            "source_type": "PG_TABLE",
            "title": "string",
            "valid": "boolean",
            "virtual": "unknown"
          },
          {
            "connection_id": "string | null",
            "id": "string",
            "index_info_set": "array | null",
            "managed_by": "string | null",
            "parameter_hash": "string",
            "parameters": {
              "subsql": "string"
            },
            "raw_schema": "array | null",
            "source_type": "PG_SUBSELECT",
            "title": "string",
            "valid": "boolean",
            "virtual": "unknown"
          },
          {
            "connection_id": "string | null",
            "id": "string",
            "index_info_set": "array | null",
            "managed_by": "string | null",
            "parameter_hash": "string",
            "parameters": {},
            "raw_schema": "array | null",
            "source_type": "PROMQL",
            "title": "string",
            "valid": "boolean",
            "virtual": "unknown"
          },
          {
            "connection_id": "string | null",
            "id": "string",
            "index_info_set": "array | null",
            "managed_by": "string | null",
            "parameter_hash": "string",
            "parameters": {},
            "raw_schema": "array | null",
            "source_type": "SOLOMON",
            "title": "string",
            "valid": "boolean",
            "virtual": "unknown"
          },
          {
            "connection_id": "string | null",
            "id": "string",
            "index_info_set": "array | null",
            "managed_by": "string | null",
            "parameter_hash": "string",
            "parameters": {
              "db_name": "string | null",
              "db_version": "string | null",
              "table_name": "string | null"
            },
            "raw_schema": "array | null",
            "source_type": "CH_USAGE_TRACKING_YA_TEAM_TABLE",
            "title": "string",
            "valid": "boolean",
            "virtual": "unknown"
          },
          {
            "connection_id": "string | null",
            "id": "string",
            "index_info_set": "array | null",
            "managed_by": "string | null",
            "parameter_hash": "string",
            "parameters": {
              "db_name": "string | null",
              "db_version": "string | null",
              "table_name": "string | null"
            },
            "raw_schema": "array | null",
            "source_type": "YDB_TABLE",
            "title": "string",
            "valid": "boolean",
            "virtual": "unknown"
          },
          {
            "connection_id": "string | null",
            "id": "string",
            "index_info_set": "array | null",
            "managed_by": "string | null",
            "parameter_hash": "string",
            "parameters": {
              "subsql": "string"
            },
            "raw_schema": "array | null",
            "source_type": "YDB_SUBSELECT",
            "title": "string",
            "valid": "boolean",
            "virtual": "unknown"
          }
        ]
      }
    ],
    "template_enabled": "boolean"
  },
  "dir_path": "string",
  "name": "string",
  "options": {
    "connections": {
      "compatible_types": [
        {
          "conn_type": "unknown"
        }
      ],
      "items": [
        {
          "id": "string",
          "replacement_types": [
            {
              "conn_type": "unknown"
            }
          ]
        }
      ],
      "max": "integer"
    },
    "data_types": {
      "items": [
        {
          "aggregations": [
            "string"
          ],
          "casts": [
            "string"
          ],
          "filter_operations": [
            "string"
          ],
          "type": "string"
        }
      ]
    },
    "fields": {
      "items": [
        {
          "aggregations": [
            "string"
          ],
          "casts": [
            "string"
          ],
          "guid": "string"
        }
      ]
    },
    "join": {
      "operators": [
        "string"
      ],
      "types": [
        "string"
      ]
    },
    "preview": {
      "enabled": "boolean"
    },
    "schema_update_enabled": "boolean",
    "source_avatars": {
      "items": [
        {
          "id": "string",
          "schema_update_enabled": "boolean"
        }
      ],
      "max": "integer"
    },
    "source_listing": {
      "db_name_label": "string",
      "db_name_required_for_search": "boolean",
      "supports_db_name_listing": "boolean",
      "supports_source_pagination": "boolean",
      "supports_source_search": "boolean"
    },
    "sources": {
      "compatible_types": [
        {
          "source_type": "unknown"
        }
      ],
      "items": [
        {
          "id": "string",
          "schema_update_enabled": "boolean"
        }
      ],
      "max": "integer"
    },
    "supported_functions": [
      "string"
    ],
    "supports_offset": "boolean"
  },
  "preview": "boolean",
  "workbook_id": "string"
}

Field	Description
created_via	unknown
dataset	DatasetContentInternal Required field.
dir_path	string
name	string
options	Options
preview	boolean
workbook_id	string

DatasetContentInternal

Field	Description
avatar_relations[]	AvatarRelation Required field.
component_errors	ComponentErrorList
data_export_forbidden	boolean
description	string \| null
load_preview_by_default	boolean
obligatory_filters[]	ObligatoryFilter Required field.
preview_enabled	boolean
result_schema[]	ResultSchemaSchemaGeneric
result_schema_aux	ResultSchemaAux
revision_id	string \| null
rls	object (map<string, unknown>)
rls2	RLS2ConfigEntry Required field.
source_avatars[]	SourceAvatarStrict Required field.
sources[]	DataSourceStrict
template_enabled	boolean

AvatarRelation

Field	Description
conditions[]	JoinCondition Required field.
id	string Required field.
join_type	enum `inner` `left` `right` `full`
left_avatar_id	string
managed_by	enum `user` `feature` `compiler_runtime` `null`
required	boolean
right_avatar_id	string
virtual	unknown

JoinCondition

Field	Description
left	One of direct1 \| formula2 \| result_field
operator	enum Required field. `gt` `lt` `gte` `lte` `eq` `ne`
right	One of direct1 \| formula2 \| result_field
type	enum Required field. `binary`

direct1

Field

Description

calc_mode

enum

Required field.

direct
formula
result_field

source

string

Required field.

formula2

Field

Description

calc_mode

enum

Required field.

direct
formula
result_field

formula

string

Required field.

result_field

Field

Description

calc_mode

enum

Required field.

direct
formula
result_field

field_id

string

Required field.

ComponentErrorList

Field	Description
items[]	ComponentErrorPack

ComponentErrorPack

Field	Description
errors[]	ComponentError
id	string
type	enum `data_source` `source_avatar` `avatar_relation` `field` `obligatory_filter` `result_schema`

ComponentError

Field	Description
code	unknown
details	object (map<string, unknown>)
level	enum `error` `warning`
message	string

ObligatoryFilter

Field	Description
default_filters[]	Where Required field.
field_guid	string
id	string Required field.
managed_by	enum `user` `feature` `compiler_runtime` `null`
valid	boolean

Where

Field	Description
column	string Required field.
operation	enum Required field. `ISNULL` `ISNOTNULL` `GT` `LT` `GTE` `LTE` `EQ` `NE` `STARTSWITH` `ISTARTSWITH` `ENDSWITH` `IENDSWITH` `CONTAINS` `ICONTAINS` `NOTCONTAINS` `NOTICONTAINS` `LENEQ` `LENNE` `LENGT` `LENGTE` `LENLT` `LENLTE` `IN` `NIN` `BETWEEN`
values	array \| null Required field.

ResultSchemaSchemaGeneric

One of:

Field	Description
aggregation	enum `none` `sum` `avg` `min` `max` `count` `countunique`
aggregation_locked	boolean \| null
autoaggregated	boolean \| null
avatar_id	string \| null
cast	enum `string` `integer` `float` `date` `datetime` `boolean` `geopoint` `geopolygon` `uuid` `markup` `datetimetz` `unsupported` `array_str` `array_int` `array_float` `tree_str` `genericdatetime`
data_type	enum `string` `integer` `float` `date` `datetime` `boolean` `geopoint` `geopolygon` `uuid` `markup` `datetimetz` `unsupported` `array_str` `array_int` `array_float` `tree_str` `genericdatetime` `null`
description	string
guid	string
has_auto_aggregation	boolean \| null
hidden	boolean
initial_data_type	enum `string` `integer` `float` `date` `datetime` `boolean` `geopoint` `geopolygon` `uuid` `markup` `datetimetz` `unsupported` `array_str` `array_int` `array_float` `tree_str` `genericdatetime` `null`
lock_aggregation	boolean \| null
managed_by	enum `user` `feature` `compiler_runtime` `null`
source	string
title	string Required field.
type	enum `DIMENSION` `MEASURE`
ui_settings	string
valid	boolean \| null
virtual	unknown

Field	Description
aggregation	enum `none` `sum` `avg` `min` `max` `count` `countunique`
aggregation_locked	boolean \| null
autoaggregated	boolean \| null
cast	enum `string` `integer` `float` `date` `datetime` `boolean` `geopoint` `geopolygon` `uuid` `markup` `datetimetz` `unsupported` `array_str` `array_int` `array_float` `tree_str` `genericdatetime`
data_type	enum `string` `integer` `float` `date` `datetime` `boolean` `geopoint` `geopolygon` `uuid` `markup` `datetimetz` `unsupported` `array_str` `array_int` `array_float` `tree_str` `genericdatetime` `null`
description	string
formula	string
guid	string
guid_formula	string
has_auto_aggregation	boolean \| null
hidden	boolean
initial_data_type	enum `string` `integer` `float` `date` `datetime` `boolean` `geopoint` `geopolygon` `uuid` `markup` `datetimetz` `unsupported` `array_str` `array_int` `array_float` `tree_str` `genericdatetime` `null`
lock_aggregation	boolean \| null
managed_by	enum `user` `feature` `compiler_runtime` `null`
title	string Required field.
type	enum `DIMENSION` `MEASURE`
ui_settings	string
valid	boolean \| null
virtual	unknown

Field	Description
aggregation	enum `none` `sum` `avg` `min` `max` `count` `countunique`
aggregation_locked	boolean \| null
autoaggregated	boolean \| null
cast	enum `string` `integer` `float` `date` `datetime` `boolean` `geopoint` `geopolygon` `uuid` `markup` `datetimetz` `unsupported` `array_str` `array_int` `array_float` `tree_str` `genericdatetime`
data_type	enum `string` `integer` `float` `date` `datetime` `boolean` `geopoint` `geopolygon` `uuid` `markup` `datetimetz` `unsupported` `array_str` `array_int` `array_float` `tree_str` `genericdatetime` `null`
default_value	string \| null
description	string
guid	string
has_auto_aggregation	boolean \| null
hidden	boolean
initial_data_type	enum `string` `integer` `float` `date` `datetime` `boolean` `geopoint` `geopolygon` `uuid` `markup` `datetimetz` `unsupported` `array_str` `array_int` `array_float` `tree_str` `genericdatetime` `null`
lock_aggregation	boolean \| null
managed_by	enum `user` `feature` `compiler_runtime` `null`
template_enabled	boolean
title	string Required field.
type	enum `DIMENSION` `MEASURE`
ui_settings	string
valid	boolean \| null
value_constraint	Any of ParameterValueConstraint \| null
virtual	unknown

Field	Description
Empty

ParameterValueConstraint

One of:

Field	Description
pattern	string
type	regex (const)

Field	Description
type	default (const)

Field	Description
Empty

ResultSchemaAux

Field	Description
inter_dependencies	FieldInterDependencyInfo

FieldInterDependencyInfo

Field	Description
deps[]	FieldInterDependencyItem

FieldInterDependencyItem

Field	Description
dep_field_id	string
ref_field_ids[]	string

RLS2ConfigEntry

Field	Description
allowed_value	string \| null
field_guid	string \| null
pattern_type	enum `value` `all` `userid`
subject	RLSSubject Required field.

RLSSubject

Field	Description
subject_id	string Required field.
subject_name	string \| null
subject_type	enum `user` `group` `all` `userid` `unknown` `notfound`

SourceAvatarStrict

Field	Description
id	string Required field.
is_root	boolean
managed_by	enum Required field. `user` `feature` `compiler_runtime` `null`
source_id	string
title	string
valid	boolean
virtual	unknown

DataSourceStrict

One of:

Field	Description
connection_id	string \| null
id	string Required field.
index_info_set	array \| null
managed_by	enum `user` `feature` `compiler_runtime` `null`
parameter_hash	string
parameters	SQLParameters
raw_schema	array \| null
source_type	APPMETRICA_API (const)
title	string Required field.
valid	boolean
virtual	unknown

Field	Description
connection_id	string \| null
id	string Required field.
index_info_set	array \| null
managed_by	enum `user` `feature` `compiler_runtime` `null`
parameter_hash	string
parameters	SQLParameters
raw_schema	array \| null
source_type	CHYT_TABLE (const)
title	string Required field.
valid	boolean
virtual	unknown

Field	Description
connection_id	string \| null
id	string Required field.
index_info_set	array \| null
managed_by	enum `user` `feature` `compiler_runtime` `null`
parameter_hash	string
parameters	CHYTTableListParameters
raw_schema	array \| null
source_type	CHYT_TABLE_LIST (const)
title	string Required field.
valid	boolean
virtual	unknown

Field	Description
connection_id	string \| null
id	string Required field.
index_info_set	array \| null
managed_by	enum `user` `feature` `compiler_runtime` `null`
parameter_hash	string
parameters	CHYTTableRangeParameters
raw_schema	array \| null
source_type	CHYT_TABLE_RANGE (const)
title	string Required field.
valid	boolean
virtual	unknown

Field	Description
connection_id	string \| null
id	string Required field.
index_info_set	array \| null
managed_by	enum `user` `feature` `compiler_runtime` `null`
parameter_hash	string
parameters	SubselectParameters
raw_schema	array \| null
source_type	CHYT_SUBSELECT (const)
title	string Required field.
valid	boolean
virtual	unknown

Field	Description
connection_id	string \| null
id	string Required field.
index_info_set	array \| null
managed_by	enum `user` `feature` `compiler_runtime` `null`
parameter_hash	string
parameters	SQLParameters
raw_schema	array \| null
source_type	CHYT_USER_AUTH_TABLE (const)
title	string Required field.
valid	boolean
virtual	unknown

Field	Description
connection_id	string \| null
id	string Required field.
index_info_set	array \| null
managed_by	enum `user` `feature` `compiler_runtime` `null`
parameter_hash	string
parameters	CHYTTableListParameters
raw_schema	array \| null
source_type	CHYT_USER_AUTH_TABLE_LIST (const)
title	string Required field.
valid	boolean
virtual	unknown

Field	Description
connection_id	string \| null
id	string Required field.
index_info_set	array \| null
managed_by	enum `user` `feature` `compiler_runtime` `null`
parameter_hash	string
parameters	CHYTTableRangeParameters
raw_schema	array \| null
source_type	CHYT_USER_AUTH_TABLE_RANGE (const)
title	string Required field.
valid	boolean
virtual	unknown

Field	Description
connection_id	string \| null
id	string Required field.
index_info_set	array \| null
managed_by	enum `user` `feature` `compiler_runtime` `null`
parameter_hash	string
parameters	SubselectParameters
raw_schema	array \| null
source_type	CHYT_USER_AUTH_SUBSELECT (const)
title	string Required field.
valid	boolean
virtual	unknown

Field	Description
connection_id	string \| null
id	string Required field.
index_info_set	array \| null
managed_by	enum `user` `feature` `compiler_runtime` `null`
parameter_hash	string
parameters	SQLParameters
raw_schema	array \| null
source_type	CH_TABLE (const)
title	string Required field.
valid	boolean
virtual	unknown

Field	Description
connection_id	string \| null
id	string Required field.
index_info_set	array \| null
managed_by	enum `user` `feature` `compiler_runtime` `null`
parameter_hash	string
parameters	SubselectParameters
raw_schema	array \| null
source_type	CH_SUBSELECT (const)
title	string Required field.
valid	boolean
virtual	unknown

Field	Description
connection_id	string \| null
id	string Required field.
index_info_set	array \| null
managed_by	enum `user` `feature` `compiler_runtime` `null`
parameter_hash	string
parameters	SchematizedParameters
raw_schema	array \| null
source_type	GP_TABLE (const)
title	string Required field.
valid	boolean
virtual	unknown

Field	Description
connection_id	string \| null
id	string Required field.
index_info_set	array \| null
managed_by	enum `user` `feature` `compiler_runtime` `null`
parameter_hash	string
parameters	SubselectParameters
raw_schema	array \| null
source_type	GP_SUBSELECT (const)
title	string Required field.
valid	boolean
virtual	unknown

Field	Description
connection_id	string \| null
id	string Required field.
index_info_set	array \| null
managed_by	enum `user` `feature` `compiler_runtime` `null`
parameter_hash	string
parameters	SimpleParameters
raw_schema	array \| null
source_type	GSHEETS (const)
title	string Required field.
valid	boolean
virtual	unknown

Field	Description
connection_id	string \| null
id	string Required field.
index_info_set	array \| null
managed_by	enum `user` `feature` `compiler_runtime` `null`
parameter_hash	string
parameters	SimpleParameters
raw_schema	array \| null
source_type	JSON_API (const)
title	string Required field.
valid	boolean
virtual	unknown

Field	Description
connection_id	string \| null
id	string Required field.
index_info_set	array \| null
managed_by	enum `user` `feature` `compiler_runtime` `null`
parameter_hash	string
parameters	SQLParameters
raw_schema	array \| null
source_type	METRIKA_API (const)
title	string Required field.
valid	boolean
virtual	unknown

Field	Description
connection_id	string \| null
id	string Required field.
index_info_set	array \| null
managed_by	enum `user` `feature` `compiler_runtime` `null`
parameter_hash	string
parameters	SchematizedParameters
raw_schema	array \| null
source_type	MSSQL_TABLE (const)
title	string Required field.
valid	boolean
virtual	unknown

Field	Description
connection_id	string \| null
id	string Required field.
index_info_set	array \| null
managed_by	enum `user` `feature` `compiler_runtime` `null`
parameter_hash	string
parameters	SubselectParameters
raw_schema	array \| null
source_type	MSSQL_SUBSELECT (const)
title	string Required field.
valid	boolean
virtual	unknown

Field	Description
connection_id	string \| null
id	string Required field.
index_info_set	array \| null
managed_by	enum `user` `feature` `compiler_runtime` `null`
parameter_hash	string
parameters	SQLParameters
raw_schema	array \| null
source_type	MYSQL_TABLE (const)
title	string Required field.
valid	boolean
virtual	unknown

Field	Description
connection_id	string \| null
id	string Required field.
index_info_set	array \| null
managed_by	enum `user` `feature` `compiler_runtime` `null`
parameter_hash	string
parameters	SubselectParameters
raw_schema	array \| null
source_type	MYSQL_SUBSELECT (const)
title	string Required field.
valid	boolean
virtual	unknown

Field	Description
connection_id	string \| null
id	string Required field.
index_info_set	array \| null
managed_by	enum `user` `feature` `compiler_runtime` `null`
parameter_hash	string
parameters	SchematizedParameters
raw_schema	array \| null
source_type	ORACLE_TABLE (const)
title	string Required field.
valid	boolean
virtual	unknown

Field	Description
connection_id	string \| null
id	string Required field.
index_info_set	array \| null
managed_by	enum `user` `feature` `compiler_runtime` `null`
parameter_hash	string
parameters	SubselectParameters
raw_schema	array \| null
source_type	ORACLE_SUBSELECT (const)
title	string Required field.
valid	boolean
virtual	unknown

Field	Description
connection_id	string \| null
id	string Required field.
index_info_set	array \| null
managed_by	enum `user` `feature` `compiler_runtime` `null`
parameter_hash	string
parameters	SchematizedParameters
raw_schema	array \| null
source_type	PG_TABLE (const)
title	string Required field.
valid	boolean
virtual	unknown

Field	Description
connection_id	string \| null
id	string Required field.
index_info_set	array \| null
managed_by	enum `user` `feature` `compiler_runtime` `null`
parameter_hash	string
parameters	SubselectParameters
raw_schema	array \| null
source_type	PG_SUBSELECT (const)
title	string Required field.
valid	boolean
virtual	unknown

Field	Description
connection_id	string \| null
id	string Required field.
index_info_set	array \| null
managed_by	enum `user` `feature` `compiler_runtime` `null`
parameter_hash	string
parameters	SimpleParameters
raw_schema	array \| null
source_type	PROMQL (const)
title	string Required field.
valid	boolean
virtual	unknown

Field	Description
connection_id	string \| null
id	string Required field.
index_info_set	array \| null
managed_by	enum `user` `feature` `compiler_runtime` `null`
parameter_hash	string
parameters	SimpleParameters
raw_schema	array \| null
source_type	SOLOMON (const)
title	string Required field.
valid	boolean
virtual	unknown

Field	Description
connection_id	string \| null
id	string Required field.
index_info_set	array \| null
managed_by	enum `user` `feature` `compiler_runtime` `null`
parameter_hash	string
parameters	SQLParameters
raw_schema	array \| null
source_type	CH_USAGE_TRACKING_YA_TEAM_TABLE (const)
title	string Required field.
valid	boolean
virtual	unknown

Field	Description
connection_id	string \| null
id	string Required field.
index_info_set	array \| null
managed_by	enum `user` `feature` `compiler_runtime` `null`
parameter_hash	string
parameters	SQLParameters
raw_schema	array \| null
source_type	YDB_TABLE (const)
title	string Required field.
valid	boolean
virtual	unknown

Field	Description
connection_id	string \| null
id	string Required field.
index_info_set	array \| null
managed_by	enum `user` `feature` `compiler_runtime` `null`
parameter_hash	string
parameters	SubselectParameters
raw_schema	array \| null
source_type	YDB_SUBSELECT (const)
title	string Required field.
valid	boolean
virtual	unknown

Field	Description
Empty

SQLParameters

Field	Description
db_name	string \| null
db_version	string \| null
table_name	string \| null

CHYTTableListParameters

Field	Description
table_names	string

CHYTTableRangeParameters

Field	Description
directory_path	string
range_from	string
range_to	string

SubselectParameters

Field	Description
subsql	string

SchematizedParameters

Field	Description
db_name	string \| null
db_version	string \| null
schema_name	string \| null
table_name	string \| null

SimpleParameters

Field	Description
Empty

Options

Field	Description
connections	Connections
data_types	DataTypes
fields	Fields
join	Join
preview	Preview
schema_update_enabled	boolean
source_avatars	Avatars
source_listing	SourceListing
sources	Sources
supported_functions[]	string
supports_offset	boolean

Connections

Field	Description
compatible_types[]	CompatConnectionTypeListItem
items[]	ConnectionListItem
max	integer

CompatConnectionTypeListItem

Field	Description
conn_type	unknown

ConnectionListItem

Field	Description
id	string
replacement_types[]	CompatConnectionTypeListItem

DataTypes

Field	Description
items[]	DataTypeListItem

DataTypeListItem

Field	Description
aggregations[]	enum `none` `sum` `avg` `min` `max` `count` `countunique`
casts[]	enum `string` `integer` `float` `date` `datetime` `boolean` `geopoint` `geopolygon` `uuid` `markup` `datetimetz` `unsupported` `array_str` `array_int` `array_float` `tree_str` `genericdatetime`
filter_operations[]	enum `ISNULL` `ISNOTNULL` `GT` `LT` `GTE` `LTE` `EQ` `NE` `STARTSWITH` `ISTARTSWITH` `ENDSWITH` `IENDSWITH` `CONTAINS` `ICONTAINS` `NOTCONTAINS` `NOTICONTAINS` `LENEQ` `LENNE` `LENGT` `LENGTE` `LENLT` `LENLTE` `IN` `NIN` `BETWEEN`
type	enum `string` `integer` `float` `date` `datetime` `boolean` `geopoint` `geopolygon` `uuid` `markup` `datetimetz` `unsupported` `array_str` `array_int` `array_float` `tree_str` `genericdatetime`

Fields

Field	Description
items[]	FieldListItem

FieldListItem

Field	Description
aggregations[]	enum `none` `sum` `avg` `min` `max` `count` `countunique`
casts[]	enum `string` `integer` `float` `date` `datetime` `boolean` `geopoint` `geopolygon` `uuid` `markup` `datetimetz` `unsupported` `array_str` `array_int` `array_float` `tree_str` `genericdatetime`
guid	string

Join

Field

Description

operators[]

enum

gt
lt
gte
lte
eq
ne

types[]

enum

inner
left
right
full

Preview

Field	Description
enabled	boolean

Avatars

Field	Description
items[]	SourceListItem
max	integer

SourceListItem

Field	Description
id	string
schema_update_enabled	boolean

SourceListing

Field	Description
db_name_label	string
db_name_required_for_search	boolean
supports_db_name_listing	boolean
supports_source_pagination	boolean
supports_source_search	boolean

Sources

Field	Description
compatible_types[]	CompatSourceTypeListItem
items[]	SourceListItem1
max	integer

CompatSourceTypeListItem

Field	Description
source_type	unknown

SourceListItem1

Field	Description
id	string
schema_update_enabled	boolean

Response

HTTP Code: 200

Response

Response schema: application/json

{
  "dataset": {
    "avatar_relations": [
      {
        "conditions": [
          {
            "left": {
              "<oneOf>": [
                {
                  "calc_mode": "string",
                  "source": "string"
                },
                {
                  "calc_mode": "string",
                  "formula": "string"
                },
                {
                  "calc_mode": "string",
                  "field_id": "string"
                }
              ]
            },
            "operator": "string",
            "right": {
              "<oneOf>": [
                {
                  "calc_mode": "string",
                  "source": "string"
                },
                {
                  "calc_mode": "string",
                  "formula": "string"
                },
                {
                  "calc_mode": "string",
                  "field_id": "string"
                }
              ]
            },
            "type": "string"
          }
        ],
        "id": "string",
        "join_type": "string",
        "left_avatar_id": "string",
        "managed_by": "string | null",
        "required": "boolean",
        "right_avatar_id": "string",
        "virtual": "unknown"
      }
    ],
    "component_errors": {
      "items": [
        {
          "errors": [
            {
              "code": "unknown",
              "details": {
                "string": "unknown"
              },
              "level": "string",
              "message": "string"
            }
          ],
          "id": "string",
          "type": "string"
        }
      ]
    },
    "data_export_forbidden": "boolean",
    "description": "string | null",
    "load_preview_by_default": "boolean",
    "obligatory_filters": [
      {
        "default_filters": [
          {
            "column": "string",
            "operation": "string",
            "values": "array | null"
          }
        ],
        "field_guid": "string",
        "id": "string",
        "managed_by": "string | null",
        "valid": "boolean"
      }
    ],
    "preview_enabled": "boolean",
    "result_schema": [
      {
        "<oneOf>": [
          {
            "aggregation": "string",
            "aggregation_locked": "boolean | null",
            "autoaggregated": "boolean | null",
            "avatar_id": "string | null",
            "cast": "string",
            "data_type": "string | null",
            "description": "string",
            "guid": "string",
            "has_auto_aggregation": "boolean | null",
            "hidden": "boolean",
            "initial_data_type": "string | null",
            "lock_aggregation": "boolean | null",
            "managed_by": "string | null",
            "source": "string",
            "title": "string",
            "type": "string",
            "ui_settings": "string",
            "valid": "boolean | null",
            "virtual": "unknown"
          },
          {
            "aggregation": "string",
            "aggregation_locked": "boolean | null",
            "autoaggregated": "boolean | null",
            "cast": "string",
            "data_type": "string | null",
            "description": "string",
            "formula": "string",
            "guid": "string",
            "guid_formula": "string",
            "has_auto_aggregation": "boolean | null",
            "hidden": "boolean",
            "initial_data_type": "string | null",
            "lock_aggregation": "boolean | null",
            "managed_by": "string | null",
            "title": "string",
            "type": "string",
            "ui_settings": "string",
            "valid": "boolean | null",
            "virtual": "unknown"
          },
          {
            "aggregation": "string",
            "aggregation_locked": "boolean | null",
            "autoaggregated": "boolean | null",
            "cast": "string",
            "data_type": "string | null",
            "default_value": "string | null",
            "description": "string",
            "guid": "string",
            "has_auto_aggregation": "boolean | null",
            "hidden": "boolean",
            "initial_data_type": "string | null",
            "lock_aggregation": "boolean | null",
            "managed_by": "string | null",
            "template_enabled": "boolean",
            "title": "string",
            "type": "string",
            "ui_settings": "string",
            "valid": "boolean | null",
            "value_constraint": "unknown",
            "virtual": "unknown"
          }
        ]
      }
    ],
    "result_schema_aux": {
      "inter_dependencies": {
        "deps": [
          {
            "dep_field_id": "string",
            "ref_field_ids": [
              "string"
            ]
          }
        ]
      }
    },
    "revision_id": "string | null",
    "rls": {
      "string": "unknown"
    },
    "rls2": {
      "string": "array"
    },
    "source_avatars": [
      {
        "id": "string",
        "is_root": "boolean",
        "managed_by": "string | null",
        "source_id": "string",
        "title": "string",
        "valid": "boolean",
        "virtual": "unknown"
      }
    ],
    "sources": [
      {
        "<oneOf>": [
          {
            "connection_id": "string | null",
            "id": "string",
            "index_info_set": "array | null",
            "managed_by": "string | null",
            "parameter_hash": "string",
            "parameters": {
              "db_name": "string | null",
              "db_version": "string | null",
              "table_name": "string | null"
            },
            "raw_schema": "array | null",
            "source_type": "APPMETRICA_API",
            "title": "string",
            "valid": "boolean",
            "virtual": "unknown"
          },
          {
            "connection_id": "string | null",
            "id": "string",
            "index_info_set": "array | null",
            "managed_by": "string | null",
            "parameter_hash": "string",
            "parameters": {
              "db_name": "string | null",
              "db_version": "string | null",
              "table_name": "string | null"
            },
            "raw_schema": "array | null",
            "source_type": "CHYT_TABLE",
            "title": "string",
            "valid": "boolean",
            "virtual": "unknown"
          },
          {
            "connection_id": "string | null",
            "id": "string",
            "index_info_set": "array | null",
            "managed_by": "string | null",
            "parameter_hash": "string",
            "parameters": {
              "table_names": "string"
            },
            "raw_schema": "array | null",
            "source_type": "CHYT_TABLE_LIST",
            "title": "string",
            "valid": "boolean",
            "virtual": "unknown"
          },
          {
            "connection_id": "string | null",
            "id": "string",
            "index_info_set": "array | null",
            "managed_by": "string | null",
            "parameter_hash": "string",
            "parameters": {
              "directory_path": "string",
              "range_from": "string",
              "range_to": "string"
            },
            "raw_schema": "array | null",
            "source_type": "CHYT_TABLE_RANGE",
            "title": "string",
            "valid": "boolean",
            "virtual": "unknown"
          },
          {
            "connection_id": "string | null",
            "id": "string",
            "index_info_set": "array | null",
            "managed_by": "string | null",
            "parameter_hash": "string",
            "parameters": {
              "subsql": "string"
            },
            "raw_schema": "array | null",
            "source_type": "CHYT_SUBSELECT",
            "title": "string",
            "valid": "boolean",
            "virtual": "unknown"
          },
          {
            "connection_id": "string | null",
            "id": "string",
            "index_info_set": "array | null",
            "managed_by": "string | null",
            "parameter_hash": "string",
            "parameters": {
              "db_name": "string | null",
              "db_version": "string | null",
              "table_name": "string | null"
            },
            "raw_schema": "array | null",
            "source_type": "CHYT_USER_AUTH_TABLE",
            "title": "string",
            "valid": "boolean",
            "virtual": "unknown"
          },
          {
            "connection_id": "string | null",
            "id": "string",
            "index_info_set": "array | null",
            "managed_by": "string | null",
            "parameter_hash": "string",
            "parameters": {
              "table_names": "string"
            },
            "raw_schema": "array | null",
            "source_type": "CHYT_USER_AUTH_TABLE_LIST",
            "title": "string",
            "valid": "boolean",
            "virtual": "unknown"
          },
          {
            "connection_id": "string | null",
            "id": "string",
            "index_info_set": "array | null",
            "managed_by": "string | null",
            "parameter_hash": "string",
            "parameters": {
              "directory_path": "string",
              "range_from": "string",
              "range_to": "string"
            },
            "raw_schema": "array | null",
            "source_type": "CHYT_USER_AUTH_TABLE_RANGE",
            "title": "string",
            "valid": "boolean",
            "virtual": "unknown"
          },
          {
            "connection_id": "string | null",
            "id": "string",
            "index_info_set": "array | null",
            "managed_by": "string | null",
            "parameter_hash": "string",
            "parameters": {
              "subsql": "string"
            },
            "raw_schema": "array | null",
            "source_type": "CHYT_USER_AUTH_SUBSELECT",
            "title": "string",
            "valid": "boolean",
            "virtual": "unknown"
          },
          {
            "connection_id": "string | null",
            "id": "string",
            "index_info_set": "array | null",
            "managed_by": "string | null",
            "parameter_hash": "string",
            "parameters": {
              "db_name": "string | null",
              "db_version": "string | null",
              "table_name": "string | null"
            },
            "raw_schema": "array | null",
            "source_type": "CH_TABLE",
            "title": "string",
            "valid": "boolean",
            "virtual": "unknown"
          },
          {
            "connection_id": "string | null",
            "id": "string",
            "index_info_set": "array | null",
            "managed_by": "string | null",
            "parameter_hash": "string",
            "parameters": {
              "subsql": "string"
            },
            "raw_schema": "array | null",
            "source_type": "CH_SUBSELECT",
            "title": "string",
            "valid": "boolean",
            "virtual": "unknown"
          },
          {
            "connection_id": "string | null",
            "id": "string",
            "index_info_set": "array | null",
            "managed_by": "string | null",
            "parameter_hash": "string",
            "parameters": {
              "db_name": "string | null",
              "db_version": "string | null",
              "schema_name": "string | null",
              "table_name": "string | null"
            },
            "raw_schema": "array | null",
            "source_type": "GP_TABLE",
            "title": "string",
            "valid": "boolean",
            "virtual": "unknown"
          },
          {
            "connection_id": "string | null",
            "id": "string",
            "index_info_set": "array | null",
            "managed_by": "string | null",
            "parameter_hash": "string",
            "parameters": {
              "subsql": "string"
            },
            "raw_schema": "array | null",
            "source_type": "GP_SUBSELECT",
            "title": "string",
            "valid": "boolean",
            "virtual": "unknown"
          },
          {
            "connection_id": "string | null",
            "id": "string",
            "index_info_set": "array | null",
            "managed_by": "string | null",
            "parameter_hash": "string",
            "parameters": {},
            "raw_schema": "array | null",
            "source_type": "GSHEETS",
            "title": "string",
            "valid": "boolean",
            "virtual": "unknown"
          },
          {
            "connection_id": "string | null",
            "id": "string",
            "index_info_set": "array | null",
            "managed_by": "string | null",
            "parameter_hash": "string",
            "parameters": {},
            "raw_schema": "array | null",
            "source_type": "JSON_API",
            "title": "string",
            "valid": "boolean",
            "virtual": "unknown"
          },
          {
            "connection_id": "string | null",
            "id": "string",
            "index_info_set": "array | null",
            "managed_by": "string | null",
            "parameter_hash": "string",
            "parameters": {
              "db_name": "string | null",
              "db_version": "string | null",
              "table_name": "string | null"
            },
            "raw_schema": "array | null",
            "source_type": "METRIKA_API",
            "title": "string",
            "valid": "boolean",
            "virtual": "unknown"
          },
          {
            "connection_id": "string | null",
            "id": "string",
            "index_info_set": "array | null",
            "managed_by": "string | null",
            "parameter_hash": "string",
            "parameters": {
              "db_name": "string | null",
              "db_version": "string | null",
              "schema_name": "string | null",
              "table_name": "string | null"
            },
            "raw_schema": "array | null",
            "source_type": "MSSQL_TABLE",
            "title": "string",
            "valid": "boolean",
            "virtual": "unknown"
          },
          {
            "connection_id": "string | null",
            "id": "string",
            "index_info_set": "array | null",
            "managed_by": "string | null",
            "parameter_hash": "string",
            "parameters": {
              "subsql": "string"
            },
            "raw_schema": "array | null",
            "source_type": "MSSQL_SUBSELECT",
            "title": "string",
            "valid": "boolean",
            "virtual": "unknown"
          },
          {
            "connection_id": "string | null",
            "id": "string",
            "index_info_set": "array | null",
            "managed_by": "string | null",
            "parameter_hash": "string",
            "parameters": {
              "db_name": "string | null",
              "db_version": "string | null",
              "table_name": "string | null"
            },
            "raw_schema": "array | null",
            "source_type": "MYSQL_TABLE",
            "title": "string",
            "valid": "boolean",
            "virtual": "unknown"
          },
          {
            "connection_id": "string | null",
            "id": "string",
            "index_info_set": "array | null",
            "managed_by": "string | null",
            "parameter_hash": "string",
            "parameters": {
              "subsql": "string"
            },
            "raw_schema": "array | null",
            "source_type": "MYSQL_SUBSELECT",
            "title": "string",
            "valid": "boolean",
            "virtual": "unknown"
          },
          {
            "connection_id": "string | null",
            "id": "string",
            "index_info_set": "array | null",
            "managed_by": "string | null",
            "parameter_hash": "string",
            "parameters": {
              "db_name": "string | null",
              "db_version": "string | null",
              "schema_name": "string | null",
              "table_name": "string | null"
            },
            "raw_schema": "array | null",
            "source_type": "ORACLE_TABLE",
            "title": "string",
            "valid": "boolean",
            "virtual": "unknown"
          },
          {
            "connection_id": "string | null",
            "id": "string",
            "index_info_set": "array | null",
            "managed_by": "string | null",
            "parameter_hash": "string",
            "parameters": {
              "subsql": "string"
            },
            "raw_schema": "array | null",
            "source_type": "ORACLE_SUBSELECT",
            "title": "string",
            "valid": "boolean",
            "virtual": "unknown"
          },
          {
            "connection_id": "string | null",
            "id": "string",
            "index_info_set": "array | null",
            "managed_by": "string | null",
            "parameter_hash": "string",
            "parameters": {
              "db_name": "string | null",
              "db_version": "string | null",
              "schema_name": "string | null",
              "table_name": "string | null"
            },
            "raw_schema": "array | null",
            "source_type": "PG_TABLE",
            "title": "string",
            "valid": "boolean",
            "virtual": "unknown"
          },
          {
            "connection_id": "string | null",
            "id": "string",
            "index_info_set": "array | null",
            "managed_by": "string | null",
            "parameter_hash": "string",
            "parameters": {
              "subsql": "string"
            },
            "raw_schema": "array | null",
            "source_type": "PG_SUBSELECT",
            "title": "string",
            "valid": "boolean",
            "virtual": "unknown"
          },
          {
            "connection_id": "string | null",
            "id": "string",
            "index_info_set": "array | null",
            "managed_by": "string | null",
            "parameter_hash": "string",
            "parameters": {},
            "raw_schema": "array | null",
            "source_type": "PROMQL",
            "title": "string",
            "valid": "boolean",
            "virtual": "unknown"
          },
          {
            "connection_id": "string | null",
            "id": "string",
            "index_info_set": "array | null",
            "managed_by": "string | null",
            "parameter_hash": "string",
            "parameters": {},
            "raw_schema": "array | null",
            "source_type": "SOLOMON",
            "title": "string",
            "valid": "boolean",
            "virtual": "unknown"
          },
          {
            "connection_id": "string | null",
            "id": "string",
            "index_info_set": "array | null",
            "managed_by": "string | null",
            "parameter_hash": "string",
            "parameters": {
              "db_name": "string | null",
              "db_version": "string | null",
              "table_name": "string | null"
            },
            "raw_schema": "array | null",
            "source_type": "CH_USAGE_TRACKING_YA_TEAM_TABLE",
            "title": "string",
            "valid": "boolean",
            "virtual": "unknown"
          },
          {
            "connection_id": "string | null",
            "id": "string",
            "index_info_set": "array | null",
            "managed_by": "string | null",
            "parameter_hash": "string",
            "parameters": {
              "db_name": "string | null",
              "db_version": "string | null",
              "table_name": "string | null"
            },
            "raw_schema": "array | null",
            "source_type": "YDB_TABLE",
            "title": "string",
            "valid": "boolean",
            "virtual": "unknown"
          },
          {
            "connection_id": "string | null",
            "id": "string",
            "index_info_set": "array | null",
            "managed_by": "string | null",
            "parameter_hash": "string",
            "parameters": {
              "subsql": "string"
            },
            "raw_schema": "array | null",
            "source_type": "YDB_SUBSELECT",
            "title": "string",
            "valid": "boolean",
            "virtual": "unknown"
          }
        ]
      }
    ],
    "template_enabled": "boolean"
  },
  "id": "string",
  "is_favorite": "boolean",
  "key": "string",
  "options": {
    "connections": {
      "compatible_types": [
        {
          "conn_type": "unknown"
        }
      ],
      "items": [
        {
          "id": "string",
          "replacement_types": [
            {
              "conn_type": "unknown"
            }
          ]
        }
      ],
      "max": "integer"
    },
    "data_types": {
      "items": [
        {
          "aggregations": [
            "string"
          ],
          "casts": [
            "string"
          ],
          "filter_operations": [
            "string"
          ],
          "type": "string"
        }
      ]
    },
    "fields": {
      "items": [
        {
          "aggregations": [
            "string"
          ],
          "casts": [
            "string"
          ],
          "guid": "string"
        }
      ]
    },
    "join": {
      "operators": [
        "string"
      ],
      "types": [
        "string"
      ]
    },
    "preview": {
      "enabled": "boolean"
    },
    "schema_update_enabled": "boolean",
    "source_avatars": {
      "items": [
        {
          "id": "string",
          "schema_update_enabled": "boolean"
        }
      ],
      "max": "integer"
    },
    "source_listing": {
      "db_name_label": "string",
      "db_name_required_for_search": "boolean",
      "supports_db_name_listing": "boolean",
      "supports_source_pagination": "boolean",
      "supports_source_search": "boolean"
    },
    "sources": {
      "compatible_types": [
        {
          "source_type": "unknown"
        }
      ],
      "items": [
        {
          "id": "string",
          "schema_update_enabled": "boolean"
        }
      ],
      "max": "integer"
    },
    "supported_functions": [
      "string"
    ],
    "supports_offset": "boolean"
  },
  "permissions": {
    "string": "boolean"
  }
}

Field	Description
dataset	DatasetContentInternal Required field.
id	string
is_favorite	boolean
key	string
options	Options
permissions	object (map<string, boolean>)

DatasetContentInternal

Field	Description
avatar_relations[]	AvatarRelation Required field.
component_errors	ComponentErrorList
data_export_forbidden	boolean
description	string \| null
load_preview_by_default	boolean
obligatory_filters[]	ObligatoryFilter Required field.
preview_enabled	boolean
result_schema[]	ResultSchemaSchemaGeneric
result_schema_aux	ResultSchemaAux
revision_id	string \| null
rls	object (map<string, unknown>)
rls2	RLS2ConfigEntry Required field.
source_avatars[]	SourceAvatarStrict Required field.
sources[]	DataSourceStrict
template_enabled	boolean

AvatarRelation

Field	Description
conditions[]	JoinCondition Required field.
id	string Required field.
join_type	enum `inner` `left` `right` `full`
left_avatar_id	string
managed_by	enum `user` `feature` `compiler_runtime` `null`
required	boolean
right_avatar_id	string
virtual	unknown

JoinCondition

Field	Description
left	One of direct1 \| formula2 \| result_field
operator	enum Required field. `gt` `lt` `gte` `lte` `eq` `ne`
right	One of direct1 \| formula2 \| result_field
type	enum Required field. `binary`

direct1

Field

Description

calc_mode

enum

Required field.

direct
formula
result_field

source

string

Required field.

formula2

Field

Description

calc_mode

enum

Required field.

direct
formula
result_field

formula

string

Required field.

result_field

Field

Description

calc_mode

enum

Required field.

direct
formula
result_field

field_id

string

Required field.

ComponentErrorList

Field	Description
items[]	ComponentErrorPack

ComponentErrorPack

Field	Description
errors[]	ComponentError
id	string
type	enum `data_source` `source_avatar` `avatar_relation` `field` `obligatory_filter` `result_schema`

ComponentError

Field	Description
code	unknown
details	object (map<string, unknown>)
level	enum `error` `warning`
message	string

ObligatoryFilter

Field	Description
default_filters[]	Where Required field.
field_guid	string
id	string Required field.
managed_by	enum `user` `feature` `compiler_runtime` `null`
valid	boolean

Where

Field	Description
column	string Required field.
operation	enum Required field. `ISNULL` `ISNOTNULL` `GT` `LT` `GTE` `LTE` `EQ` `NE` `STARTSWITH` `ISTARTSWITH` `ENDSWITH` `IENDSWITH` `CONTAINS` `ICONTAINS` `NOTCONTAINS` `NOTICONTAINS` `LENEQ` `LENNE` `LENGT` `LENGTE` `LENLT` `LENLTE` `IN` `NIN` `BETWEEN`
values	array \| null Required field.

ResultSchemaSchemaGeneric

One of:

Field	Description
aggregation	enum `none` `sum` `avg` `min` `max` `count` `countunique`
aggregation_locked	boolean \| null
autoaggregated	boolean \| null
avatar_id	string \| null
cast	enum `string` `integer` `float` `date` `datetime` `boolean` `geopoint` `geopolygon` `uuid` `markup` `datetimetz` `unsupported` `array_str` `array_int` `array_float` `tree_str` `genericdatetime`
data_type	enum `string` `integer` `float` `date` `datetime` `boolean` `geopoint` `geopolygon` `uuid` `markup` `datetimetz` `unsupported` `array_str` `array_int` `array_float` `tree_str` `genericdatetime` `null`
description	string
guid	string
has_auto_aggregation	boolean \| null
hidden	boolean
initial_data_type	enum `string` `integer` `float` `date` `datetime` `boolean` `geopoint` `geopolygon` `uuid` `markup` `datetimetz` `unsupported` `array_str` `array_int` `array_float` `tree_str` `genericdatetime` `null`
lock_aggregation	boolean \| null
managed_by	enum `user` `feature` `compiler_runtime` `null`
source	string
title	string Required field.
type	enum `DIMENSION` `MEASURE`
ui_settings	string
valid	boolean \| null
virtual	unknown

Field	Description
aggregation	enum `none` `sum` `avg` `min` `max` `count` `countunique`
aggregation_locked	boolean \| null
autoaggregated	boolean \| null
cast	enum `string` `integer` `float` `date` `datetime` `boolean` `geopoint` `geopolygon` `uuid` `markup` `datetimetz` `unsupported` `array_str` `array_int` `array_float` `tree_str` `genericdatetime`
data_type	enum `string` `integer` `float` `date` `datetime` `boolean` `geopoint` `geopolygon` `uuid` `markup` `datetimetz` `unsupported` `array_str` `array_int` `array_float` `tree_str` `genericdatetime` `null`
description	string
formula	string
guid	string
guid_formula	string
has_auto_aggregation	boolean \| null
hidden	boolean
initial_data_type	enum `string` `integer` `float` `date` `datetime` `boolean` `geopoint` `geopolygon` `uuid` `markup` `datetimetz` `unsupported` `array_str` `array_int` `array_float` `tree_str` `genericdatetime` `null`
lock_aggregation	boolean \| null
managed_by	enum `user` `feature` `compiler_runtime` `null`
title	string Required field.
type	enum `DIMENSION` `MEASURE`
ui_settings	string
valid	boolean \| null
virtual	unknown

Field	Description
aggregation	enum `none` `sum` `avg` `min` `max` `count` `countunique`
aggregation_locked	boolean \| null
autoaggregated	boolean \| null
cast	enum `string` `integer` `float` `date` `datetime` `boolean` `geopoint` `geopolygon` `uuid` `markup` `datetimetz` `unsupported` `array_str` `array_int` `array_float` `tree_str` `genericdatetime`
data_type	enum `string` `integer` `float` `date` `datetime` `boolean` `geopoint` `geopolygon` `uuid` `markup` `datetimetz` `unsupported` `array_str` `array_int` `array_float` `tree_str` `genericdatetime` `null`
default_value	string \| null
description	string
guid	string
has_auto_aggregation	boolean \| null
hidden	boolean
initial_data_type	enum `string` `integer` `float` `date` `datetime` `boolean` `geopoint` `geopolygon` `uuid` `markup` `datetimetz` `unsupported` `array_str` `array_int` `array_float` `tree_str` `genericdatetime` `null`
lock_aggregation	boolean \| null
managed_by	enum `user` `feature` `compiler_runtime` `null`
template_enabled	boolean
title	string Required field.
type	enum `DIMENSION` `MEASURE`
ui_settings	string
valid	boolean \| null
value_constraint	Any of ParameterValueConstraint \| null
virtual	unknown

Field	Description
Empty

ParameterValueConstraint

One of:

Field	Description
pattern	string
type	regex (const)

Field	Description
type	default (const)

Field	Description
Empty

ResultSchemaAux

Field	Description
inter_dependencies	FieldInterDependencyInfo

FieldInterDependencyInfo

Field	Description
deps[]	FieldInterDependencyItem

FieldInterDependencyItem

Field	Description
dep_field_id	string
ref_field_ids[]	string

RLS2ConfigEntry

Field	Description
allowed_value	string \| null
field_guid	string \| null
pattern_type	enum `value` `all` `userid`
subject	RLSSubject Required field.

RLSSubject

Field	Description
subject_id	string Required field.
subject_name	string \| null
subject_type	enum `user` `group` `all` `userid` `unknown` `notfound`

SourceAvatarStrict

Field	Description
id	string Required field.
is_root	boolean
managed_by	enum Required field. `user` `feature` `compiler_runtime` `null`
source_id	string
title	string
valid	boolean
virtual	unknown

DataSourceStrict

One of:

Field	Description
connection_id	string \| null
id	string Required field.
index_info_set	array \| null
managed_by	enum `user` `feature` `compiler_runtime` `null`
parameter_hash	string
parameters	SQLParameters
raw_schema	array \| null
source_type	APPMETRICA_API (const)
title	string Required field.
valid	boolean
virtual	unknown

Field	Description
connection_id	string \| null
id	string Required field.
index_info_set	array \| null
managed_by	enum `user` `feature` `compiler_runtime` `null`
parameter_hash	string
parameters	SQLParameters
raw_schema	array \| null
source_type	CHYT_TABLE (const)
title	string Required field.
valid	boolean
virtual	unknown

Field	Description
connection_id	string \| null
id	string Required field.
index_info_set	array \| null
managed_by	enum `user` `feature` `compiler_runtime` `null`
parameter_hash	string
parameters	CHYTTableListParameters
raw_schema	array \| null
source_type	CHYT_TABLE_LIST (const)
title	string Required field.
valid	boolean
virtual	unknown

Field	Description
connection_id	string \| null
id	string Required field.
index_info_set	array \| null
managed_by	enum `user` `feature` `compiler_runtime` `null`
parameter_hash	string
parameters	CHYTTableRangeParameters
raw_schema	array \| null
source_type	CHYT_TABLE_RANGE (const)
title	string Required field.
valid	boolean
virtual	unknown

Field	Description
connection_id	string \| null
id	string Required field.
index_info_set	array \| null
managed_by	enum `user` `feature` `compiler_runtime` `null`
parameter_hash	string
parameters	SubselectParameters
raw_schema	array \| null
source_type	CHYT_SUBSELECT (const)
title	string Required field.
valid	boolean
virtual	unknown

Field	Description
connection_id	string \| null
id	string Required field.
index_info_set	array \| null
managed_by	enum `user` `feature` `compiler_runtime` `null`
parameter_hash	string
parameters	SQLParameters
raw_schema	array \| null
source_type	CHYT_USER_AUTH_TABLE (const)
title	string Required field.
valid	boolean
virtual	unknown

Field	Description
connection_id	string \| null
id	string Required field.
index_info_set	array \| null
managed_by	enum `user` `feature` `compiler_runtime` `null`
parameter_hash	string
parameters	CHYTTableListParameters
raw_schema	array \| null
source_type	CHYT_USER_AUTH_TABLE_LIST (const)
title	string Required field.
valid	boolean
virtual	unknown

Field	Description
connection_id	string \| null
id	string Required field.
index_info_set	array \| null
managed_by	enum `user` `feature` `compiler_runtime` `null`
parameter_hash	string
parameters	CHYTTableRangeParameters
raw_schema	array \| null
source_type	CHYT_USER_AUTH_TABLE_RANGE (const)
title	string Required field.
valid	boolean
virtual	unknown

Field	Description
connection_id	string \| null
id	string Required field.
index_info_set	array \| null
managed_by	enum `user` `feature` `compiler_runtime` `null`
parameter_hash	string
parameters	SubselectParameters
raw_schema	array \| null
source_type	CHYT_USER_AUTH_SUBSELECT (const)
title	string Required field.
valid	boolean
virtual	unknown

Field	Description
connection_id	string \| null
id	string Required field.
index_info_set	array \| null
managed_by	enum `user` `feature` `compiler_runtime` `null`
parameter_hash	string
parameters	SQLParameters
raw_schema	array \| null
source_type	CH_TABLE (const)
title	string Required field.
valid	boolean
virtual	unknown

Field	Description
connection_id	string \| null
id	string Required field.
index_info_set	array \| null
managed_by	enum `user` `feature` `compiler_runtime` `null`
parameter_hash	string
parameters	SubselectParameters
raw_schema	array \| null
source_type	CH_SUBSELECT (const)
title	string Required field.
valid	boolean
virtual	unknown

Field	Description
connection_id	string \| null
id	string Required field.
index_info_set	array \| null
managed_by	enum `user` `feature` `compiler_runtime` `null`
parameter_hash	string
parameters	SchematizedParameters
raw_schema	array \| null
source_type	GP_TABLE (const)
title	string Required field.
valid	boolean
virtual	unknown

Field	Description
connection_id	string \| null
id	string Required field.
index_info_set	array \| null
managed_by	enum `user` `feature` `compiler_runtime` `null`
parameter_hash	string
parameters	SubselectParameters
raw_schema	array \| null
source_type	GP_SUBSELECT (const)
title	string Required field.
valid	boolean
virtual	unknown

Field	Description
connection_id	string \| null
id	string Required field.
index_info_set	array \| null
managed_by	enum `user` `feature` `compiler_runtime` `null`
parameter_hash	string
parameters	SimpleParameters
raw_schema	array \| null
source_type	GSHEETS (const)
title	string Required field.
valid	boolean
virtual	unknown

Field	Description
connection_id	string \| null
id	string Required field.
index_info_set	array \| null
managed_by	enum `user` `feature` `compiler_runtime` `null`
parameter_hash	string
parameters	SimpleParameters
raw_schema	array \| null
source_type	JSON_API (const)
title	string Required field.
valid	boolean
virtual	unknown

Field	Description
connection_id	string \| null
id	string Required field.
index_info_set	array \| null
managed_by	enum `user` `feature` `compiler_runtime` `null`
parameter_hash	string
parameters	SQLParameters
raw_schema	array \| null
source_type	METRIKA_API (const)
title	string Required field.
valid	boolean
virtual	unknown

Field	Description
connection_id	string \| null
id	string Required field.
index_info_set	array \| null
managed_by	enum `user` `feature` `compiler_runtime` `null`
parameter_hash	string
parameters	SchematizedParameters
raw_schema	array \| null
source_type	MSSQL_TABLE (const)
title	string Required field.
valid	boolean
virtual	unknown

Field	Description
connection_id	string \| null
id	string Required field.
index_info_set	array \| null
managed_by	enum `user` `feature` `compiler_runtime` `null`
parameter_hash	string
parameters	SubselectParameters
raw_schema	array \| null
source_type	MSSQL_SUBSELECT (const)
title	string Required field.
valid	boolean
virtual	unknown

Field	Description
connection_id	string \| null
id	string Required field.
index_info_set	array \| null
managed_by	enum `user` `feature` `compiler_runtime` `null`
parameter_hash	string
parameters	SQLParameters
raw_schema	array \| null
source_type	MYSQL_TABLE (const)
title	string Required field.
valid	boolean
virtual	unknown

Field	Description
connection_id	string \| null
id	string Required field.
index_info_set	array \| null
managed_by	enum `user` `feature` `compiler_runtime` `null`
parameter_hash	string
parameters	SubselectParameters
raw_schema	array \| null
source_type	MYSQL_SUBSELECT (const)
title	string Required field.
valid	boolean
virtual	unknown

Field	Description
connection_id	string \| null
id	string Required field.
index_info_set	array \| null
managed_by	enum `user` `feature` `compiler_runtime` `null`
parameter_hash	string
parameters	SchematizedParameters
raw_schema	array \| null
source_type	ORACLE_TABLE (const)
title	string Required field.
valid	boolean
virtual	unknown

Field	Description
connection_id	string \| null
id	string Required field.
index_info_set	array \| null
managed_by	enum `user` `feature` `compiler_runtime` `null`
parameter_hash	string
parameters	SubselectParameters
raw_schema	array \| null
source_type	ORACLE_SUBSELECT (const)
title	string Required field.
valid	boolean
virtual	unknown

Field	Description
connection_id	string \| null
id	string Required field.
index_info_set	array \| null
managed_by	enum `user` `feature` `compiler_runtime` `null`
parameter_hash	string
parameters	SchematizedParameters
raw_schema	array \| null
source_type	PG_TABLE (const)
title	string Required field.
valid	boolean
virtual	unknown

Field	Description
connection_id	string \| null
id	string Required field.
index_info_set	array \| null
managed_by	enum `user` `feature` `compiler_runtime` `null`
parameter_hash	string
parameters	SubselectParameters
raw_schema	array \| null
source_type	PG_SUBSELECT (const)
title	string Required field.
valid	boolean
virtual	unknown

Field	Description
connection_id	string \| null
id	string Required field.
index_info_set	array \| null
managed_by	enum `user` `feature` `compiler_runtime` `null`
parameter_hash	string
parameters	SimpleParameters
raw_schema	array \| null
source_type	PROMQL (const)
title	string Required field.
valid	boolean
virtual	unknown

Field	Description
connection_id	string \| null
id	string Required field.
index_info_set	array \| null
managed_by	enum `user` `feature` `compiler_runtime` `null`
parameter_hash	string
parameters	SimpleParameters
raw_schema	array \| null
source_type	SOLOMON (const)
title	string Required field.
valid	boolean
virtual	unknown

Field	Description
connection_id	string \| null
id	string Required field.
index_info_set	array \| null
managed_by	enum `user` `feature` `compiler_runtime` `null`
parameter_hash	string
parameters	SQLParameters
raw_schema	array \| null
source_type	CH_USAGE_TRACKING_YA_TEAM_TABLE (const)
title	string Required field.
valid	boolean
virtual	unknown

Field	Description
connection_id	string \| null
id	string Required field.
index_info_set	array \| null
managed_by	enum `user` `feature` `compiler_runtime` `null`
parameter_hash	string
parameters	SQLParameters
raw_schema	array \| null
source_type	YDB_TABLE (const)
title	string Required field.
valid	boolean
virtual	unknown

Field	Description
connection_id	string \| null
id	string Required field.
index_info_set	array \| null
managed_by	enum `user` `feature` `compiler_runtime` `null`
parameter_hash	string
parameters	SubselectParameters
raw_schema	array \| null
source_type	YDB_SUBSELECT (const)
title	string Required field.
valid	boolean
virtual	unknown

Field	Description
Empty

SQLParameters

Field	Description
db_name	string \| null
db_version	string \| null
table_name	string \| null

CHYTTableListParameters

Field	Description
table_names	string

CHYTTableRangeParameters

Field	Description
directory_path	string
range_from	string
range_to	string

SubselectParameters

Field	Description
subsql	string

SchematizedParameters

Field	Description
db_name	string \| null
db_version	string \| null
schema_name	string \| null
table_name	string \| null

SimpleParameters

Field	Description
Empty

Options

Field	Description
connections	Connections
data_types	DataTypes
fields	Fields
join	Join
preview	Preview
schema_update_enabled	boolean
source_avatars	Avatars
source_listing	SourceListing
sources	Sources
supported_functions[]	string
supports_offset	boolean

Connections

Field	Description
compatible_types[]	CompatConnectionTypeListItem
items[]	ConnectionListItem
max	integer

CompatConnectionTypeListItem

Field	Description
conn_type	unknown

ConnectionListItem

Field	Description
id	string
replacement_types[]	CompatConnectionTypeListItem

DataTypes

Field	Description
items[]	DataTypeListItem

DataTypeListItem

Field	Description
aggregations[]	enum `none` `sum` `avg` `min` `max` `count` `countunique`
casts[]	enum `string` `integer` `float` `date` `datetime` `boolean` `geopoint` `geopolygon` `uuid` `markup` `datetimetz` `unsupported` `array_str` `array_int` `array_float` `tree_str` `genericdatetime`
filter_operations[]	enum `ISNULL` `ISNOTNULL` `GT` `LT` `GTE` `LTE` `EQ` `NE` `STARTSWITH` `ISTARTSWITH` `ENDSWITH` `IENDSWITH` `CONTAINS` `ICONTAINS` `NOTCONTAINS` `NOTICONTAINS` `LENEQ` `LENNE` `LENGT` `LENGTE` `LENLT` `LENLTE` `IN` `NIN` `BETWEEN`
type	enum `string` `integer` `float` `date` `datetime` `boolean` `geopoint` `geopolygon` `uuid` `markup` `datetimetz` `unsupported` `array_str` `array_int` `array_float` `tree_str` `genericdatetime`

Fields

Field	Description
items[]	FieldListItem

FieldListItem

Field	Description
aggregations[]	enum `none` `sum` `avg` `min` `max` `count` `countunique`
casts[]	enum `string` `integer` `float` `date` `datetime` `boolean` `geopoint` `geopolygon` `uuid` `markup` `datetimetz` `unsupported` `array_str` `array_int` `array_float` `tree_str` `genericdatetime`
guid	string

Join

Field

Description

operators[]

enum

gt
lt
gte
lte
eq
ne

types[]

enum

inner
left
right
full

Preview

Field	Description
enabled	boolean

Avatars

Field	Description
items[]	SourceListItem
max	integer

SourceListItem

Field	Description
id	string
schema_update_enabled	boolean

SourceListing

Field	Description
db_name_label	string
db_name_required_for_search	boolean
supports_db_name_listing	boolean
supports_source_pagination	boolean
supports_source_search	boolean

Sources

Field	Description
compatible_types[]	CompatSourceTypeListItem
items[]	SourceListItem1
max	integer

CompatSourceTypeListItem

Field	Description
source_type	unknown

SourceListItem1

Field	Description
id	string
schema_update_enabled	boolean

DataLens API: Create dataset

HTTP requestHTTP request

Body parametersBody parameters

DatasetContentInternalDatasetContentInternal

AvatarRelationAvatarRelation

JoinConditionJoinCondition

direct1direct1

formula2formula2

result_fieldresult_field

ComponentErrorListComponentErrorList

ComponentErrorPackComponentErrorPack

ComponentErrorComponentError

ObligatoryFilterObligatoryFilter

WhereWhere

ResultSchemaSchemaGenericResultSchemaSchemaGeneric

ParameterValueConstraintParameterValueConstraint

ResultSchemaAuxResultSchemaAux

FieldInterDependencyInfoFieldInterDependencyInfo

FieldInterDependencyItemFieldInterDependencyItem

RLS2ConfigEntryRLS2ConfigEntry

RLSSubjectRLSSubject

SourceAvatarStrictSourceAvatarStrict

DataSourceStrictDataSourceStrict

SQLParametersSQLParameters

CHYTTableListParametersCHYTTableListParameters

CHYTTableRangeParametersCHYTTableRangeParameters

SubselectParametersSubselectParameters

SchematizedParametersSchematizedParameters

SimpleParametersSimpleParameters

OptionsOptions

ConnectionsConnections

CompatConnectionTypeListItemCompatConnectionTypeListItem

ConnectionListItemConnectionListItem

DataTypesDataTypes

DataTypeListItemDataTypeListItem

FieldsFields

FieldListItemFieldListItem

JoinJoin

PreviewPreview

AvatarsAvatars

SourceListItemSourceListItem

SourceListingSourceListing

SourcesSources

CompatSourceTypeListItemCompatSourceTypeListItem

SourceListItem1SourceListItem1

ResponseResponse

DatasetContentInternalDatasetContentInternal

AvatarRelationAvatarRelation

JoinConditionJoinCondition

direct1direct1

formula2formula2

result_fieldresult_field

ComponentErrorListComponentErrorList

ComponentErrorPackComponentErrorPack

ComponentErrorComponentError

ObligatoryFilterObligatoryFilter

WhereWhere

ResultSchemaSchemaGenericResultSchemaSchemaGeneric

ParameterValueConstraintParameterValueConstraint

ResultSchemaAuxResultSchemaAux

FieldInterDependencyInfoFieldInterDependencyInfo

FieldInterDependencyItemFieldInterDependencyItem

RLS2ConfigEntryRLS2ConfigEntry

RLSSubjectRLSSubject

SourceAvatarStrictSourceAvatarStrict

DataSourceStrictDataSourceStrict

SQLParametersSQLParameters

CHYTTableListParametersCHYTTableListParameters

CHYTTableRangeParametersCHYTTableRangeParameters

SubselectParametersSubselectParameters

SchematizedParametersSchematizedParameters

SimpleParametersSimpleParameters

OptionsOptions

ConnectionsConnections

CompatConnectionTypeListItemCompatConnectionTypeListItem

ConnectionListItemConnectionListItem

DataTypesDataTypes

DataTypeListItemDataTypeListItem

FieldsFields

FieldListItemFieldListItem

HTTP request

Body parameters

DatasetContentInternal

AvatarRelation

JoinCondition

direct1

formula2

result_field

ComponentErrorList

ComponentErrorPack

ComponentError

ObligatoryFilter

Where

ResultSchemaSchemaGeneric

ParameterValueConstraint

ResultSchemaAux

FieldInterDependencyInfo

FieldInterDependencyItem

RLS2ConfigEntry

RLSSubject

SourceAvatarStrict

DataSourceStrict

SQLParameters

CHYTTableListParameters

CHYTTableRangeParameters

SubselectParameters

SchematizedParameters

SimpleParameters

Options

Connections

CompatConnectionTypeListItem

ConnectionListItem

DataTypes

DataTypeListItem

Fields

FieldListItem

Join

Preview

Avatars

SourceListItem

SourceListing

Sources

CompatSourceTypeListItem

SourceListItem1

Response

DatasetContentInternal

AvatarRelation

JoinCondition

direct1

formula2

result_field

ComponentErrorList

ComponentErrorPack

ComponentError

ObligatoryFilter

Where

ResultSchemaSchemaGeneric

ParameterValueConstraint

ResultSchemaAux

FieldInterDependencyInfo

FieldInterDependencyItem

RLS2ConfigEntry

RLSSubject

SourceAvatarStrict

DataSourceStrict

SQLParameters

CHYTTableListParameters

CHYTTableRangeParameters

SubselectParameters

SchematizedParameters

SimpleParameters

Options

Connections

CompatConnectionTypeListItem

ConnectionListItem

DataTypes

DataTypeListItem

Fields

FieldListItem

Join