Validate dataset

datasetId

Type: string

Source dataset identifier.

Example: example

bindedDatasetId

Type: string

Example: example

data

Type: DatasetValidate

{
  "dataset": {
    "avatar_relations": [
      {
        "conditions": [
          {}
        ],
        "id": "example",
        "join_type": "inner",
        "left_avatar_id": "example",
        "managed_by": "user",
        "required": false,
        "right_avatar_id": "example"
      }
    ],
    "cache_invalidation_source": {
      "cache_invalidation_error": null,
      "field": null,
      "filters": [
        {
          "default_filters": [],
          "field_guid": "example",
          "id": "example",
          "managed_by": "user",
          "valid": true
        }
      ],
      "mode": "off",
      "sql": "null"
    },
    "component_errors": {
      "items": [
        {
          "errors": [
            null
          ],
          "id": "example",
          "type": "data_source"
        }
      ]
    },
    "data_export_forbidden": false,
    "description": "",
    "load_preview_by_default": true,
    "obligatory_filters": [
      null
    ],
    "preview_enabled": false,
    "result_schema": [
      {
        "aggregation": "none",
        "avatar_id": "example",
        "cast": "string",
        "data_type": "string",
        "description": "example",
        "guid": "example",
        "has_auto_aggregation": true,
        "hidden": false,
        "initial_data_type": "string",
        "lock_aggregation": true,
        "managed_by": "user",
        "source": "example",
        "title": "example",
        "type": "DIMENSION",
        "ui_settings": "",
        "valid": true
      }
    ],
    "result_schema_aux": {
      "inter_dependencies": {
        "deps": [
          {}
        ]
      }
    },
    "revision_id": "null",
    "rls2": {},
    "source_avatars": [
      {
        "id": "example",
        "is_root": true,
        "managed_by": "user",
        "source_id": "example",
        "title": "example"
      }
    ],
    "sources": [
      {
        "connection_id": "example",
        "id": "example",
        "index_info_set": null,
        "managed_by": "user",
        "parameters": {},
        "raw_schema": [
          null
        ],
        "source_type": "APPMETRICA_API",
        "title": "example",
        "valid": true
      }
    ],
    "template_enabled": false
  },
  "updates": [
    {
      "action": "add_field",
      "field": {
        "aggregation": "none",
        "avatar_id": "example",
        "calc_mode": "direct",
        "cast": "string",
        "default_value": null,
        "description": "example",
        "formula": "example",
        "guid": "example",
        "guid_formula": "example",
        "hidden": true,
        "new_id": "example",
        "source": "example",
        "strict": false,
        "template_enabled": true,
        "title": "example",
        "ui_settings": "example",
        "value_constraint": null
      },
      "order_index": 0
    }
  ]
}

workbookId

Type: string | null

Example: example

calc_mode

Type: string

Enum: direct, formula, result_field

source

Type: string

Example: example

calc_mode

Type: string

Enum: direct, formula, result_field

formula

Type: string

Example: example

calc_mode

Type: string

Enum: direct, formula, result_field

field_id

Type: string

Example: example

left

Type: ConditionPartGeneric

{
  "calc_mode": "direct",
  "source": "example"
}

operator

Type: string

Enum: gt, lt, gte, lte, eq, ne

right

Type: ConditionPartGeneric

{
  "calc_mode": "direct",
  "source": "example"
}

type

Type: string

Const: binary

Example: example

id

Type: string

Example: example

conditions

Type: JoinCondition[]

[
  {
    "left": {
      "calc_mode": "direct",
      "source": "example"
    },
    "operator": "gt",
    "right": null,
    "type": "binary"
  }
]

join_type

Type: string

Enum: inner, left, right, full

left_avatar_id

Type: string

Example: example

managed_by

Type: string | null

Default: user

Enum: user, feature, compiler_runtime, null

required

Type: boolean

Whether the control value is required.

Default: false

right_avatar_id

Type: string

Example: example

level

Type: string

Enum: info, warning, critical

locator

Type: string

Example: example

message

Type: string

Notification message.

Example: example

title

Type: string

Example: example

formula

Type: string

Default: ``

guid_formula

Type: string

Default: ``

aggregation

Type: string

Default: none

Enum: none, sum, avg, min, max, count, countunique

calc_spec

Type: FormulaCalculationSpec

{
  "formula": "",
  "guid_formula": ""
}

cast

Type: string

Default: string

Enum: string, integer, float, date, datetime, boolean, geopoint, geopolygon, uuid, markup, datetimetz, unsupported, array_str, array_int, array_float, tree_str, genericdatetime

data_type

Type: string

Default: string

Enum: string, integer, float, date, datetime, boolean, geopoint, geopolygon, uuid, markup, datetimetz, unsupported, array_str, array_int, array_float, tree_str, genericdatetime

description

Type: string

Example: example

guid

Type: string

Example: example

has_auto_aggregation

Type: boolean | null

hidden

Type: boolean

Default: false

initial_data_type

Type: string | null

Enum: string, integer, float, date, datetime, boolean, geopoint, geopolygon, uuid, markup, datetimetz, unsupported, array_str, array_int, array_float, tree_str, genericdatetime, null

Example: string

lock_aggregation

Type: boolean | null

managed_by

Type: string | null

Enum: user, feature, compiler_runtime, null

Example: user

title

Type: string

Default: INVALIDATION CACHE SERVICE FIELD

type

Type: string

Enum: DIMENSION, MEASURE

ui_settings

Type: string

Default: ``

valid

Type: boolean | null

column

Type: string

Example: example

operation

Type: string

Filtering operation.

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

values

Type: array | null

[
  null
]

id

Type: string

Example: example

default_filters

Type: Where[]

Default: []

[
  {
    "column": "example",
    "operation": "ISNULL",
    "values": [
      null
    ]
  }
]

field_guid

Type: string

Example: example

managed_by

Type: string | null

Default: user

Enum: user, feature, compiler_runtime, null

valid

Type: boolean

Default: true

cache_invalidation_error

Default: null

field

Default: null

filters

Type: ObligatoryFilter[]

[
  {
    "default_filters": [],
    "field_guid": "example",
    "id": "example",
    "managed_by": "user",
    "valid": true
  }
]

mode

Type: string

Default: off

Enum: sql, formula, off

sql

Type: string | null

Default: null

code

Type: unknown

Notification code.

Example: null

details

Additional notification details.

{}

level

Type: string

Enum: error, warning

message

Type: string

Notification message.

Example: example

errors

Type: ComponentError[]

[
  {
    "code": null,
    "details": {},
    "level": "error",
    "message": "example"
  }
]

id

Type: string

Example: example

type

Type: string

Enum: data_source, source_avatar, avatar_relation, field, obligatory_filter, result_schema

items

Type: ComponentErrorPack[]

[
  {
    "errors": [
      {
        "code": null,
        "details": {},
        "level": "error",
        "message": "example"
      }
    ],
    "id": "example",
    "type": "data_source"
  }
]

title

Type: string

Example: example

aggregation

Type: string

Default: none

Enum: none, sum, avg, min, max, count, countunique

avatar_id

Type: string | null

Example: example

cast

Type: string

Enum: string, integer, float, date, datetime, boolean, geopoint, geopolygon, uuid, markup, datetimetz, unsupported, array_str, array_int, array_float, tree_str, genericdatetime

data_type

Type: string | null

Enum: string, integer, float, date, datetime, boolean, geopoint, geopolygon, uuid, markup, datetimetz, unsupported, array_str, array_int, array_float, tree_str, genericdatetime, null

Example: string

description

Type: string

Example: example

guid

Type: string

Example: example

has_auto_aggregation

Type: boolean | null

hidden

Type: boolean

Default: false

initial_data_type

Type: string | null

Enum: string, integer, float, date, datetime, boolean, geopoint, geopolygon, uuid, markup, datetimetz, unsupported, array_str, array_int, array_float, tree_str, genericdatetime, null

Example: string

lock_aggregation

Type: boolean | null

managed_by

Type: string | null

Enum: user, feature, compiler_runtime, null

Example: user

source

Type: string

Example: example

type

Type: string

Enum: DIMENSION, MEASURE

ui_settings

Type: string

Default: ``

valid

Type: boolean | null

title

Type: string

Example: example

aggregation

Type: string

Default: none

Enum: none, sum, avg, min, max, count, countunique

cast

Type: string

Enum: string, integer, float, date, datetime, boolean, geopoint, geopolygon, uuid, markup, datetimetz, unsupported, array_str, array_int, array_float, tree_str, genericdatetime

data_type

Type: string | null

Enum: string, integer, float, date, datetime, boolean, geopoint, geopolygon, uuid, markup, datetimetz, unsupported, array_str, array_int, array_float, tree_str, genericdatetime, null

Example: string

description

Type: string

Example: example

formula

Type: string

Default: ``

guid

Type: string

Example: example

guid_formula

Type: string

Default: ``

has_auto_aggregation

Type: boolean | null

hidden

Type: boolean

Default: false

initial_data_type

Type: string | null

Enum: string, integer, float, date, datetime, boolean, geopoint, geopolygon, uuid, markup, datetimetz, unsupported, array_str, array_int, array_float, tree_str, genericdatetime, null

Example: string

lock_aggregation

Type: boolean | null

managed_by

Type: string | null

Enum: user, feature, compiler_runtime, null

Example: user

type

Type: string

Enum: DIMENSION, MEASURE

ui_settings

Type: string

Default: ``

valid

Type: boolean | null

pattern

Type: string

Example: example

type

Type: string

Const: regex

Example: example

type

Type: string

Const: default

Example: example

title

Type: string

Example: example

aggregation

Type: string

Default: none

Enum: none, sum, avg, min, max, count, countunique

cast

Type: string

Enum: string, integer, float, date, datetime, boolean, geopoint, geopolygon, uuid, markup, datetimetz, unsupported, array_str, array_int, array_float, tree_str, genericdatetime

data_type

Type: string | null

Enum: string, integer, float, date, datetime, boolean, geopoint, geopolygon, uuid, markup, datetimetz, unsupported, array_str, array_int, array_float, tree_str, genericdatetime, null

Example: string

default_value

Type: string | null

Example: example

description

Type: string

Example: example

guid

Type: string

Example: example

has_auto_aggregation

Type: boolean | null

hidden

Type: boolean

Default: false

initial_data_type

Type: string | null

Enum: string, integer, float, date, datetime, boolean, geopoint, geopolygon, uuid, markup, datetimetz, unsupported, array_str, array_int, array_float, tree_str, genericdatetime, null

Example: string

lock_aggregation

Type: boolean | null

managed_by

Type: string | null

Enum: user, feature, compiler_runtime, null

Example: user

template_enabled

Type: boolean

Default: false

type

Type: string

Enum: DIMENSION, MEASURE

ui_settings

Type: string

Default: ``

valid

Type: boolean | null

value_constraint

dep_field_id

Type: string

Example: example

ref_field_ids

Type: string[]

[
  "example"
]

deps

Type: FieldInterDependencyItem[]

[
  {
    "dep_field_id": "example",
    "ref_field_ids": [
      "example"
    ]
  }
]

inter_dependencies

Type: FieldInterDependencyInfo

{
  "deps": [
    {
      "dep_field_id": "example",
      "ref_field_ids": [
        "example"
      ]
    }
  ]
}

subject_id

Type: string

Example: example

subject_name

Type: string | null

Default: null

subject_type

Type: string

Enum: user, group, all, userid, unknown, notfound

subject

Type: RLSSubject

{
  "subject_id": "example",
  "subject_name": "null",
  "subject_type": "user"
}

allowed_value

Type: string | null

Default: null

field_guid

Type: string | null

Default: null

pattern_type

Type: string

Default: value

Enum: value, all, userid

id

Type: string

Example: example

managed_by

Type: string | null

Enum: user, feature, compiler_runtime, null

Example: user

is_root

Type: boolean

source_id

Type: string

Example: example

title

Type: string

Example: example

columns

Type: string[]

[
  "example"
]

kind

Type: string | null

Enum: table_sorting, null

Example: table_sorting

db_name

Type: string | null

Example: example

db_version

Type: string | null

Example: example

table_name

Type: string | null

Example: example

name

Type: string

Example: example

name

Type: string

Example: example

nullable

Type: boolean

Default: true

length

Type: integer | null

Default: null

name

Type: string

Example: example

nullable

Type: boolean

Default: true

lowcardinality

Type: boolean

Default: false

name

Type: string

Example: example

nullable

Type: boolean

Default: true

explicit_timezone

Type: boolean

Default: true

lowcardinality

Type: boolean

Default: false

name

Type: string

Example: example

nullable

Type: boolean

Default: true

timezone_name

Type: string

Default: UTC

precision

Type: integer

lowcardinality

Type: boolean

Default: false

name

Type: string

Example: example

nullable

Type: boolean

Default: true

precision

Type: integer

explicit_timezone

Type: boolean

Default: true

lowcardinality

Type: boolean

Default: false

name

Type: string

Example: example

nullable

Type: boolean

Default: true

timezone_name

Type: string

Default: UTC

description

Type: string | null

Example: example

has_auto_aggregation

Type: boolean | null

lock_aggregation

Type: boolean | null

name

Type: string

Example: example

native_type

nullable

Type: boolean | null

title

Type: string

Example: example

user_type

Type: string

Enum: string, integer, float, date, datetime, boolean, geopoint, geopolygon, uuid, markup, datetimetz, unsupported, array_str, array_int, array_float, tree_str, genericdatetime

id

Type: string

Example: example

title

Type: string

Example: example

connection_id

Type: string | null

Example: example

index_info_set

Type: array | null

Default: null

[
  {
    "columns": [
      "example"
    ],
    "kind": "table_sorting"
  }
]

managed_by

Type: string | null

Enum: user, feature, compiler_runtime, null

Example: user

parameters

Type: SQLParameters

{
  "db_name": "example",
  "db_version": "example",
  "table_name": "example"
}

raw_schema

Type: array | null

[
  {
    "description": "example",
    "has_auto_aggregation": true,
    "lock_aggregation": true,
    "name": "example",
    "native_type": {
      "name": "example"
    },
    "nullable": true,
    "title": "example",
    "user_type": "string"
  }
]

source_type

Type: string

Const: APPMETRICA_API

Example: example

valid

Type: boolean

Default: true

id

Type: string

Example: example

title

Type: string

Example: example

connection_id

Type: string | null

Example: example

index_info_set

Type: array | null

Default: null

[
  {
    "columns": [
      "example"
    ],
    "kind": "table_sorting"
  }
]

managed_by

Type: string | null

Enum: user, feature, compiler_runtime, null

Example: user

parameters

Type: SQLParameters

{
  "db_name": "example",
  "db_version": "example",
  "table_name": "example"
}

raw_schema

Type: array | null

[
  {
    "description": "example",
    "has_auto_aggregation": true,
    "lock_aggregation": true,
    "name": "example",
    "native_type": {
      "name": "example"
    },
    "nullable": true,
    "title": "example",
    "user_type": "string"
  }
]

source_type

Type: string

Const: CHYT_YTSAURUS_TABLE

Example: example

valid

Type: boolean

Default: true

table_names

Type: string

Example: example

id

Type: string

Example: example

title

Type: string

Example: example

connection_id

Type: string | null

Example: example

index_info_set

Type: array | null

Default: null

[
  {
    "columns": [
      "example"
    ],
    "kind": "table_sorting"
  }
]

managed_by

Type: string | null

Enum: user, feature, compiler_runtime, null

Example: user

parameters

Type: CHYTTableListParameters

{
  "table_names": "example"
}

raw_schema

Type: array | null

[
  {
    "description": "example",
    "has_auto_aggregation": true,
    "lock_aggregation": true,
    "name": "example",
    "native_type": {
      "name": "example"
    },
    "nullable": true,
    "title": "example",
    "user_type": "string"
  }
]

source_type

Type: string

Const: CHYT_YTSAURUS_TABLE_LIST

Example: example

valid

Type: boolean

Default: true

directory_path

Type: string

Example: example

range_from

Type: string

Example: example

range_to

Type: string

Example: example

id

Type: string

Example: example

title

Type: string

Example: example

connection_id

Type: string | null

Example: example

index_info_set

Type: array | null

Default: null

[
  {
    "columns": [
      "example"
    ],
    "kind": "table_sorting"
  }
]

managed_by

Type: string | null

Enum: user, feature, compiler_runtime, null

Example: user

parameters

Type: CHYTTableRangeParameters

{
  "directory_path": "example",
  "range_from": "example",
  "range_to": "example"
}

raw_schema

Type: array | null

[
  {
    "description": "example",
    "has_auto_aggregation": true,
    "lock_aggregation": true,
    "name": "example",
    "native_type": {
      "name": "example"
    },
    "nullable": true,
    "title": "example",
    "user_type": "string"
  }
]

source_type

Type: string

Const: CHYT_YTSAURUS_TABLE_RANGE

Example: example

valid

Type: boolean

Default: true

subsql

Type: string

Example: example

id

Type: string

Example: example

title

Type: string

Example: example

connection_id

Type: string | null

Example: example