Create connection

Creates a new connection.

Request

POST

http://<хост_on-premises>/rpc/createConnection

Headers

Name

Description

x-dl-api-version

Type: string

API version header.

Const: 2

Example: 2

Body

application/json

{
  "accuracy": null,
  "collection_id": "null",
  "counter_id": "example",
  "data_export_forbidden": "off",
  "description": "",
  "dir_path": "example",
  "name": "example",
  "token": "example",
  "type": "appmetrica_api",
  "workbook_id": "null"
}

Name

Description

One of 13 types

appmetrica_api

Type: appmetrica_api

Example

{
  "accuracy": null,
  "collection_id": "null",
  "counter_id": "example",
  "data_export_forbidden": "off",
  "description": "",
  "dir_path": "example",
  "name": "example",
  "token": "example",
  "type": "appmetrica_api",
  "workbook_id": "null"
}

chyt

Type: chyt

Example

{
  "alias": "example",
  "cache_invalidation_throttling_interval_sec": null,
  "cache_ttl_sec": null,
  "collection_id": "null",
  "data_export_forbidden": "off",
  "description": "",
  "dir_path": "example",
  "host": "example",
  "name": "example",
  "port": 0,
  "raw_sql_level": "off",
  "secure": true,
  "token": "example",
  "type": "chyt",
  "workbook_id": "null"
}

clickhouse

Type: clickhouse

Example

{
  "cache_invalidation_throttling_interval_sec": null,
  "cache_ttl_sec": null,
  "collection_id": "null",
  "data_export_forbidden": "off",
  "db_name": "example",
  "description": "",
  "dir_path": "example",
  "experimental_features": "off",
  "host": "example",
  "name": "example",
  "password": "example",
  "port": 0,
  "raw_sql_level": "off",
  "readonly": 2,
  "secure": null,
  "ssl_ca": null,
  "ssl_ca_verify": "on",
  "type": "clickhouse",
  "username": "example",
  "workbook_id": "null"
}

greenplum

Type: greenplum

Example

{
  "cache_invalidation_throttling_interval_sec": null,
  "cache_ttl_sec": null,
  "collection_id": "null",
  "data_export_forbidden": "off",
  "db_name": "example",
  "description": "",
  "dir_path": "example",
  "enforce_collate": "auto",
  "host": "example",
  "name": "example",
  "password": "example",
  "port": 0,
  "raw_sql_level": "off",
  "ssl_ca": null,
  "ssl_enable": "off",
  "type": "greenplum",
  "username": "example",
  "workbook_id": "null"
}

json_api

Type: json_api

Example

{
  "allowed_methods": [
    "GET"
  ],
  "collection_id": "null",
  "description": "",
  "dir_path": "example",
  "host": "example",
  "name": "example",
  "path": "example",
  "plain_headers": {},
  "port": 0,
  "secret_headers": {},
  "secure": true,
  "type": "json_api",
  "workbook_id": "null"
}

metrika_api

Type: metrika_api

Example

{
  "accuracy": null,
  "collection_id": "null",
  "counter_id": "example",
  "data_export_forbidden": "off",
  "description": "",
  "dir_path": "example",
  "name": "example",
  "token": "example",
  "type": "metrika_api",
  "workbook_id": "null"
}

mssql

Type: mssql

Example

{
  "cache_invalidation_throttling_interval_sec": null,
  "cache_ttl_sec": null,
  "collection_id": "null",
  "data_export_forbidden": "off",
  "db_name": "example",
  "description": "",
  "dir_path": "example",
  "host": "example",
  "name": "example",
  "password": "example",
  "port": 0,
  "raw_sql_level": "off",
  "type": "mssql",
  "username": "example",
  "workbook_id": "null"
}

mysql

Type: mysql

Example

{
  "cache_invalidation_throttling_interval_sec": null,
  "cache_ttl_sec": null,
  "collection_id": "null",
  "data_export_forbidden": "off",
  "db_name": "example",
  "description": "",
  "dir_path": "example",
  "enforce_collate": "off",
  "host": "example",
  "name": "example",
  "password": "example",
  "port": 0,
  "raw_sql_level": "off",
  "ssl_ca": null,
  "ssl_enable": "off",
  "type": "mysql",
  "username": "example",
  "workbook_id": "null"
}

oracle

Type: oracle

Example

{
  "cache_invalidation_throttling_interval_sec": null,
  "cache_ttl_sec": null,
  "collection_id": "null",
  "data_export_forbidden": "off",
  "db_connect_method": "sid",
  "db_name": "example",
  "description": "",
  "dir_path": "example",
  "host": "example",
  "name": "example",
  "password": "example",
  "port": 0,
  "raw_sql_level": "off",
  "ssl_ca": null,
  "ssl_enable": "off",
  "type": "oracle",
  "username": "example",
  "workbook_id": "null"
}

postgres

Type: postgres

Example

{
  "cache_invalidation_throttling_interval_sec": null,
  "cache_ttl_sec": null,
  "collection_id": "null",
  "data_export_forbidden": "off",
  "db_name": "example",
  "description": "",
  "dir_path": "example",
  "enforce_collate": "auto",
  "host": "example",
  "name": "example",
  "password": "example",
  "port": 0,
  "raw_sql_level": "off",
  "ssl_ca": null,
  "ssl_enable": "off",
  "type": "postgres",
  "username": "example",
  "workbook_id": "null"
}

promql

Type: promql

Example

{
  "auth_header": "example",
  "auth_type": "password",
  "cache_invalidation_throttling_interval_sec": null,
  "cache_ttl_sec": null,
  "collection_id": "null",
  "data_export_forbidden": "off",
  "db_name": "example",
  "description": "",
  "dir_path": "example",
  "host": "example",
  "name": "example",
  "password": "example",
  "path": "example",
  "port": 0,
  "secure": true,
  "type": "promql",
  "username": "example",
  "workbook_id": "null"
}

trino

Type: trino

Example

{
  "auth_type": null,
  "cache_invalidation_throttling_interval_sec": null,
  "cache_ttl_sec": null,
  "collection_id": "null",
  "data_export_forbidden": "off",
  "db_name": "example",
  "description": "",
  "dir_path": "example",
  "host": "example",
  "jwt": "example",
  "listing_sources": null,
  "name": "example",
  "password": "example",
  "port": 0,
  "raw_sql_level": "off",
  "ssl_ca": null,
  "ssl_enable": "off",
  "type": "trino",
  "username": "example",
  "workbook_id": "null"
}

ydb

Type: ydb

Example

{
  "auth_type": "anonymous",
  "cache_invalidation_throttling_interval_sec": null,
  "cache_ttl_sec": null,
  "collection_id": "null",
  "data_export_forbidden": "off",
  "db_name": "example",
  "description": "",
  "dir_path": "example",
  "host": "example",
  "name": "example",
  "port": 0,
  "raw_sql_level": "off",
  "ssl_ca": null,
  "ssl_enable": "off",
  "token": "example",
  "type": "ydb",
  "username": "example",
  "workbook_id": "null"
}

appmetrica_api

Name	Description
counter_id	Type: string Example: `example`
dir_path	Type: string Example: `example`
name	Type: string Example: `example`
token	Type: string Example: `example`
accuracy	Type: number \| null Default: `null`
collection_id	Type: string \| null Default: `null`
data_export_forbidden	Type: unknown Default: `off`
description	Type: string \| null Default: ``
type	Type: string Const: `appmetrica_api` Example: `example`
workbook_id	Type: string \| null Default: `null`

Example

{
  "accuracy": null,
  "collection_id": "null",
  "counter_id": "example",
  "data_export_forbidden": "off",
  "description": "",
  "dir_path": "example",
  "name": "example",
  "token": "example",
  "type": "appmetrica_api",
  "workbook_id": "null"
}

chyt

Name	Description
alias	Type: string Example: `example`
dir_path	Type: string Example: `example`
host	Type: string Example: `example`
name	Type: string Example: `example`
port	Type: integer
token	Type: string Example: `example`
cache_invalidation_throttling_interval_sec	Type: integer \| null Default: `null`
cache_ttl_sec	Type: integer \| null Default: `null`
collection_id	Type: string \| null Default: `null`
data_export_forbidden	Type: unknown Default: `off`
description	Type: string \| null Default: ``
raw_sql_level	Type: string Default: `off` Enum: `off`, `subselect`, `template`, `dashsql`
secure	Type: boolean
type	Type: string Const: `chyt` Example: `example`
workbook_id	Type: string \| null Default: `null`

Example

{
  "alias": "example",
  "cache_invalidation_throttling_interval_sec": null,
  "cache_ttl_sec": null,
  "collection_id": "null",
  "data_export_forbidden": "off",
  "description": "",
  "dir_path": "example",
  "host": "example",
  "name": "example",
  "port": 0,
  "raw_sql_level": "off",
  "secure": true,
  "token": "example",
  "type": "chyt",
  "workbook_id": "null"
}

clickhouse

Name	Description
dir_path	Type: string Example: `example`
host	Type: string Example: `example`
name	Type: string Example: `example`
port	Type: integer
cache_invalidation_throttling_interval_sec	Type: integer \| null Default: `null`
cache_ttl_sec	Type: integer \| null Default: `null`
collection_id	Type: string \| null Default: `null`
data_export_forbidden	Type: unknown Default: `off`
db_name	Type: string \| null Example: `example`
description	Type: string \| null Default: ``
experimental_features	Type: unknown Default: `off`
password	Type: string \| null Example: `example`
raw_sql_level	Type: string Default: `off` Enum: `off`, `subselect`, `template`, `dashsql`
readonly	Type: integer Default: `2`
secure	Type: unknown Example: `null`
ssl_ca	Type: unknown Default: `null`
ssl_ca_verify	Type: unknown Default: `on`
type	Type: string Const: `clickhouse` Example: `example`
username	Type: string \| null Example: `example`
workbook_id	Type: string \| null Default: `null`

Example

{
  "cache_invalidation_throttling_interval_sec": null,
  "cache_ttl_sec": null,
  "collection_id": "null",
  "data_export_forbidden": "off",
  "db_name": "example",
  "description": "",
  "dir_path": "example",
  "experimental_features": "off",
  "host": "example",
  "name": "example",
  "password": "example",
  "port": 0,
  "raw_sql_level": "off",
  "readonly": 2,
  "secure": null,
  "ssl_ca": null,
  "ssl_ca_verify": "on",
  "type": "clickhouse",
  "username": "example",
  "workbook_id": "null"
}

greenplum

Name	Description
dir_path	Type: string Example: `example`
host	Type: string Example: `example`
name	Type: string Example: `example`
password	Type: string Example: `example`
port	Type: integer
username	Type: string Example: `example`
cache_invalidation_throttling_interval_sec	Type: integer \| null Default: `null`
cache_ttl_sec	Type: integer \| null Default: `null`
collection_id	Type: string \| null Default: `null`
data_export_forbidden	Type: unknown Default: `off`
db_name	Type: string \| null Example: `example`
description	Type: string \| null Default: ``
enforce_collate	Type: string Default: `auto` Enum: `auto`, `on`, `off`
raw_sql_level	Type: string Default: `off` Enum: `off`, `subselect`, `template`, `dashsql`
ssl_ca	Type: unknown Default: `null`
ssl_enable	Type: unknown Default: `off`
type	Type: string Const: `greenplum` Example: `example`
workbook_id	Type: string \| null Default: `null`

Example

{
  "cache_invalidation_throttling_interval_sec": null,
  "cache_ttl_sec": null,
  "collection_id": "null",
  "data_export_forbidden": "off",
  "db_name": "example",
  "description": "",
  "dir_path": "example",
  "enforce_collate": "auto",
  "host": "example",
  "name": "example",
  "password": "example",
  "port": 0,
  "raw_sql_level": "off",
  "ssl_ca": null,
  "ssl_enable": "off",
  "type": "greenplum",
  "username": "example",
  "workbook_id": "null"
}

json_api

Name	Description
allowed_methods	Type: string[] Example `[ "GET" ]`
dir_path	Type: string Example: `example`
host	Type: string Example: `example`
name	Type: string Example: `example`
port	Type: integer
collection_id	Type: string \| null Default: `null`
description	Type: string \| null Default: ``
path	Type: string \| null Example: `example`
plain_headers	Type: object \| null Example `{}`
secret_headers	Type: object \| null Example `{}`
secure	Type: boolean
type	Type: string Const: `json_api` Example: `example`
workbook_id	Type: string \| null Default: `null`

Example

{
  "allowed_methods": [
    "GET"
  ],
  "collection_id": "null",
  "description": "",
  "dir_path": "example",
  "host": "example",
  "name": "example",
  "path": "example",
  "plain_headers": {},
  "port": 0,
  "secret_headers": {},
  "secure": true,
  "type": "json_api",
  "workbook_id": "null"
}

metrika_api

Name	Description
counter_id	Type: string Example: `example`
dir_path	Type: string Example: `example`
name	Type: string Example: `example`
token	Type: string Example: `example`
accuracy	Type: number \| null Default: `null`
collection_id	Type: string \| null Default: `null`
data_export_forbidden	Type: unknown Default: `off`
description	Type: string \| null Default: ``
type	Type: string Const: `metrika_api` Example: `example`
workbook_id	Type: string \| null Default: `null`

Example

{
  "accuracy": null,
  "collection_id": "null",
  "counter_id": "example",
  "data_export_forbidden": "off",
  "description": "",
  "dir_path": "example",
  "name": "example",
  "token": "example",
  "type": "metrika_api",
  "workbook_id": "null"
}

mssql

Name	Description
dir_path	Type: string Example: `example`
host	Type: string Example: `example`
name	Type: string Example: `example`
password	Type: string Example: `example`
port	Type: integer
username	Type: string Example: `example`
cache_invalidation_throttling_interval_sec	Type: integer \| null Default: `null`
cache_ttl_sec	Type: integer \| null Default: `null`
collection_id	Type: string \| null Default: `null`
data_export_forbidden	Type: unknown Default: `off`
db_name	Type: string \| null Example: `example`
description	Type: string \| null Default: ``
raw_sql_level	Type: string Default: `off` Enum: `off`, `subselect`, `template`, `dashsql`
type	Type: string Const: `mssql` Example: `example`
workbook_id	Type: string \| null Default: `null`

Example

{
  "cache_invalidation_throttling_interval_sec": null,
  "cache_ttl_sec": null,
  "collection_id": "null",
  "data_export_forbidden": "off",
  "db_name": "example",
  "description": "",
  "dir_path": "example",
  "host": "example",
  "name": "example",
  "password": "example",
  "port": 0,
  "raw_sql_level": "off",
  "type": "mssql",
  "username": "example",
  "workbook_id": "null"
}

mysql

Name	Description
dir_path	Type: string Example: `example`
host	Type: string Example: `example`
name	Type: string Example: `example`
password	Type: string Example: `example`
port	Type: integer
username	Type: string Example: `example`
cache_invalidation_throttling_interval_sec	Type: integer \| null Default: `null`
cache_ttl_sec	Type: integer \| null Default: `null`
collection_id	Type: string \| null Default: `null`
data_export_forbidden	Type: unknown Default: `off`
db_name	Type: string \| null Example: `example`
description	Type: string \| null Default: ``
enforce_collate	Type: string Default: `off` Enum: `auto`, `on`, `off`
raw_sql_level	Type: string Default: `off` Enum: `off`, `subselect`, `template`, `dashsql`
ssl_ca	Type: unknown Default: `null`
ssl_enable	Type: unknown Default: `off`
type	Type: string Const: `mysql` Example: `example`
workbook_id	Type: string \| null Default: `null`

Example

{
  "cache_invalidation_throttling_interval_sec": null,
  "cache_ttl_sec": null,
  "collection_id": "null",
  "data_export_forbidden": "off",
  "db_name": "example",
  "description": "",
  "dir_path": "example",
  "enforce_collate": "off",
  "host": "example",
  "name": "example",
  "password": "example",
  "port": 0,
  "raw_sql_level": "off",
  "ssl_ca": null,
  "ssl_enable": "off",
  "type": "mysql",
  "username": "example",
  "workbook_id": "null"
}

oracle

Name	Description
db_connect_method	Type: string Enum: `sid`, `service_name`
dir_path	Type: string Example: `example`
host	Type: string Example: `example`
name	Type: string Example: `example`
password	Type: string Example: `example`
port	Type: integer
username	Type: string Example: `example`
cache_invalidation_throttling_interval_sec	Type: integer \| null Default: `null`
cache_ttl_sec	Type: integer \| null Default: `null`
collection_id	Type: string \| null Default: `null`
data_export_forbidden	Type: unknown Default: `off`
db_name	Type: string \| null Example: `example`
description	Type: string \| null Default: ``
raw_sql_level	Type: string Default: `off` Enum: `off`, `subselect`, `template`, `dashsql`
ssl_ca	Type: unknown Default: `null`
ssl_enable	Type: unknown Default: `off`
type	Type: string Const: `oracle` Example: `example`
workbook_id	Type: string \| null Default: `null`

Example

{
  "cache_invalidation_throttling_interval_sec": null,
  "cache_ttl_sec": null,
  "collection_id": "null",
  "data_export_forbidden": "off",
  "db_connect_method": "sid",
  "db_name": "example",
  "description": "",
  "dir_path": "example",
  "host": "example",
  "name": "example",
  "password": "example",
  "port": 0,
  "raw_sql_level": "off",
  "ssl_ca": null,
  "ssl_enable": "off",
  "type": "oracle",
  "username": "example",
  "workbook_id": "null"
}

postgres

Name	Description
dir_path	Type: string Example: `example`
host	Type: string Example: `example`
name	Type: string Example: `example`
password	Type: string Example: `example`
port	Type: integer
username	Type: string Example: `example`
cache_invalidation_throttling_interval_sec	Type: integer \| null Default: `null`
cache_ttl_sec	Type: integer \| null Default: `null`
collection_id	Type: string \| null Default: `null`
data_export_forbidden	Type: unknown Default: `off`
db_name	Type: string \| null Example: `example`
description	Type: string \| null Default: ``
enforce_collate	Type: string Default: `auto` Enum: `auto`, `on`, `off`
raw_sql_level	Type: string Default: `off` Enum: `off`, `subselect`, `template`, `dashsql`
ssl_ca	Type: unknown Default: `null`
ssl_enable	Type: unknown Default: `off`
type	Type: string Const: `postgres` Example: `example`
workbook_id	Type: string \| null Default: `null`

Example

{
  "cache_invalidation_throttling_interval_sec": null,
  "cache_ttl_sec": null,
  "collection_id": "null",
  "data_export_forbidden": "off",
  "db_name": "example",
  "description": "",
  "dir_path": "example",
  "enforce_collate": "auto",
  "host": "example",
  "name": "example",
  "password": "example",
  "port": 0,
  "raw_sql_level": "off",
  "ssl_ca": null,
  "ssl_enable": "off",
  "type": "postgres",
  "username": "example",
  "workbook_id": "null"
}

promql

Name	Description
dir_path	Type: string Example: `example`
host	Type: string Example: `example`
name	Type: string Example: `example`
port	Type: integer
auth_header	Type: string \| null Example: `example`
auth_type	Type: unknown Default: `password`
cache_invalidation_throttling_interval_sec	Type: integer \| null Default: `null`
cache_ttl_sec	Type: integer \| null Default: `null`
collection_id	Type: string \| null Default: `null`
data_export_forbidden	Type: unknown Default: `off`
db_name	Type: string \| null Example: `example`
description	Type: string \| null Default: ``
password	Type: string \| null Example: `example`
path	Type: string \| null Example: `example`
secure	Type: boolean
type	Type: string Const: `promql` Example: `example`
username	Type: string \| null Example: `example`
workbook_id	Type: string \| null Default: `null`

Example

{
  "auth_header": "example",
  "auth_type": "password",
  "cache_invalidation_throttling_interval_sec": null,
  "cache_ttl_sec": null,
  "collection_id": "null",
  "data_export_forbidden": "off",
  "db_name": "example",
  "description": "",
  "dir_path": "example",
  "host": "example",
  "name": "example",
  "password": "example",
  "path": "example",
  "port": 0,
  "secure": true,
  "type": "promql",
  "username": "example",
  "workbook_id": "null"
}

trino

Name	Description
auth_type	Type: unknown Example: `null`
dir_path	Type: string Example: `example`
host	Type: string Example: `example`
listing_sources	Type: unknown Example: `null`
name	Type: string Example: `example`
port	Type: integer
username	Type: string Example: `example`
cache_invalidation_throttling_interval_sec	Type: integer \| null Default: `null`
cache_ttl_sec	Type: integer \| null Default: `null`
collection_id	Type: string \| null Default: `null`
data_export_forbidden	Type: unknown Default: `off`
db_name	Type: string \| null Example: `example`
description	Type: string \| null Default: ``
jwt	Type: string \| null Example: `example`
password	Type: string \| null Example: `example`
raw_sql_level	Type: string Default: `off` Enum: `off`, `subselect`, `template`, `dashsql`
ssl_ca	Type: unknown Default: `null`
ssl_enable	Type: unknown Default: `off`
type	Type: string Const: `trino` Example: `example`
workbook_id	Type: string \| null Default: `null`

Example

{
  "auth_type": null,
  "cache_invalidation_throttling_interval_sec": null,
  "cache_ttl_sec": null,
  "collection_id": "null",
  "data_export_forbidden": "off",
  "db_name": "example",
  "description": "",
  "dir_path": "example",
  "host": "example",
  "jwt": "example",
  "listing_sources": null,
  "name": "example",
  "password": "example",
  "port": 0,
  "raw_sql_level": "off",
  "ssl_ca": null,
  "ssl_enable": "off",
  "type": "trino",
  "username": "example",
  "workbook_id": "null"
}

ydb

Name	Description
db_name	Type: string Example: `example`
dir_path	Type: string Example: `example`
host	Type: string Example: `example`
name	Type: string Example: `example`
port	Type: integer
auth_type	Type: string \| null Enum: `anonymous`, `password`, `oauth`, `null` Example: `anonymous`
cache_invalidation_throttling_interval_sec	Type: integer \| null Default: `null`
cache_ttl_sec	Type: integer \| null Default: `null`
collection_id	Type: string \| null Default: `null`
data_export_forbidden	Type: unknown Default: `off`
description	Type: string \| null Default: ``
raw_sql_level	Type: string Default: `off` Enum: `off`, `subselect`, `template`, `dashsql`
ssl_ca	Type: unknown Default: `null`
ssl_enable	Type: unknown Default: `off`
token	Type: string \| null Example: `example`
type	Type: string Const: `ydb` Example: `example`
username	Type: string \| null Example: `example`
workbook_id	Type: string \| null Default: `null`

Example

{
  "auth_type": "anonymous",
  "cache_invalidation_throttling_interval_sec": null,
  "cache_ttl_sec": null,
  "collection_id": "null",
  "data_export_forbidden": "off",
  "db_name": "example",
  "description": "",
  "dir_path": "example",
  "host": "example",
  "name": "example",
  "port": 0,
  "raw_sql_level": "off",
  "ssl_ca": null,
  "ssl_enable": "off",
  "token": "example",
  "type": "ydb",
  "username": "example",
  "workbook_id": "null"
}

Responses

200 OK

Response

Body

application/json

{
  "id": "example"
}

Name

Description

Type: string

Slide identifier.

Example: example

appmetrica_api

Name

Description

counter_id

Type: string

Example: example

dir_path

Type: string

Example: example

name

Type: string

Example: example

accuracy

Type: number | null

Default: null

collection_id

Type: string | null

Default: null

created_at

Type: string

Example: example

data_export_forbidden

Type: unknown

Default: off

description

Type: string | null

Default: ``

Type: string

Example: example

key

Type: string

Example: example

meta

Type: object

[additional]

Type: unknown

Example: null

Example

{}

type

Type: string

Const: appmetrica_api

Example: example

updated_at

Type: string

Example: example

workbook_id

Type: string | null

Default: null

Example

{
  "accuracy": null,
  "collection_id": "null",
  "counter_id": "example",
  "created_at": "example",
  "data_export_forbidden": "off",
  "description": "",
  "dir_path": "example",
  "id": "example",
  "key": "example",
  "meta": {},
  "name": "example",
  "type": "appmetrica_api",
  "updated_at": "example",
  "workbook_id": "null"
}

chyt

Name

Description

alias

Type: string

Example: example

dir_path

Type: string

Example: example

host

Type: string

Example: example

name

Type: string

Example: example

port

Type: integer

cache_invalidation_throttling_interval_sec

Type: integer | null

Default: null

cache_ttl_sec

Type: integer | null

Default: null

collection_id

Type: string | null

Default: null

created_at

Type: string

Example: example

data_export_forbidden

Type: unknown

Default: off

description

Type: string | null

Default: ``

Type: string

Example: example

key

Type: string

Example: example

meta

Type: object

[additional]

Type: unknown

Example: null

Example

{}

raw_sql_level

Type: string

Default: off

Enum: off, subselect, template, dashsql

secure

Type: boolean

type

Type: string

Const: chyt

Example: example

updated_at

Type: string

Example: example

workbook_id

Type: string | null

Default: null

Example

{
  "alias": "example",
  "cache_invalidation_throttling_interval_sec": null,
  "cache_ttl_sec": null,
  "collection_id": "null",
  "created_at": "example",
  "data_export_forbidden": "off",
  "description": "",
  "dir_path": "example",
  "host": "example",
  "id": "example",
  "key": "example",
  "meta": {},
  "name": "example",
  "port": 0,
  "raw_sql_level": "off",
  "secure": true,
  "type": "chyt",
  "updated_at": "example",
  "workbook_id": "null"
}

clickhouse

Name

Description

dir_path

Type: string

Example: example

host

Type: string

Example: example

name

Type: string

Example: example

port

Type: integer

cache_invalidation_throttling_interval_sec

Type: integer | null

Default: null

cache_ttl_sec

Type: integer | null

Default: null

collection_id

Type: string | null

Default: null

created_at

Type: string

Example: example

data_export_forbidden

Type: unknown

Default: off

db_name

Type: string | null

Example: example

description

Type: string | null

Default: ``

experimental_features

Type: unknown

Default: off

Type: string

Example: example

key

Type: string

Example: example

meta

Type: object

[additional]

Type: unknown

Example: null

Example

{}

raw_sql_level

Type: string

Default: off

Enum: off, subselect, template, dashsql

readonly

Type: integer

Default: 2

secure

Type: unknown

Example: null

ssl_ca_verify

Type: unknown

Default: on

type

Type: string

Const: clickhouse

Example: example

updated_at

Type: string

Example: example

username

Type: string | null

Example: example

workbook_id

Type: string | null

Default: null

Example

{
  "cache_invalidation_throttling_interval_sec": null,
  "cache_ttl_sec": null,
  "collection_id": "null",
  "created_at": "example",
  "data_export_forbidden": "off",
  "db_name": "example",
  "description": "",
  "dir_path": "example",
  "experimental_features": "off",
  "host": "example",
  "id": "example",
  "key": "example",
  "meta": {},
  "name": "example",
  "port": 0,
  "raw_sql_level": "off",
  "readonly": 2,
  "secure": null,
  "ssl_ca_verify": "on",
  "type": "clickhouse",
  "updated_at": "example",
  "username": "example",
  "workbook_id": "null"
}

greenplum

Name

Description

dir_path

Type: string

Example: example

host

Type: string

Example: example

name

Type: string

Example: example

port

Type: integer

username

Type: string

Example: example

cache_invalidation_throttling_interval_sec

Type: integer | null

Default: null

cache_ttl_sec

Type: integer | null

Default: null

collection_id

Type: string | null

Default: null

created_at

Type: string

Example: example

data_export_forbidden

Type: unknown

Default: off

db_name

Type: string | null

Example: example

description

Type: string | null

Default: ``

enforce_collate

Type: string

Default: auto

Enum: auto, on, off

Type: string

Example: example

key

Type: string

Example: example

meta

Type: object

[additional]

Type: unknown

Example: null

Example

{}

raw_sql_level

Type: string

Default: off

Enum: off, subselect, template, dashsql

ssl_enable

Type: unknown

Default: off

type

Type: string

Const: greenplum

Example: example

updated_at

Type: string

Example: example

workbook_id

Type: string | null

Default: null

Example

{
  "cache_invalidation_throttling_interval_sec": null,
  "cache_ttl_sec": null,
  "collection_id": "null",
  "created_at": "example",
  "data_export_forbidden": "off",
  "db_name": "example",
  "description": "",
  "dir_path": "example",
  "enforce_collate": "auto",
  "host": "example",
  "id": "example",
  "key": "example",
  "meta": {},
  "name": "example",
  "port": 0,
  "raw_sql_level": "off",
  "ssl_enable": "off",
  "type": "greenplum",
  "updated_at": "example",
  "username": "example",
  "workbook_id": "null"
}

json_api

Name

Description

allowed_methods

Type: string[]

Example

[
  "GET"
]

dir_path

Type: string

Example: example

host

Type: string

Example: example

name

Type: string

Example: example

port

Type: integer

collection_id

Type: string | null

Default: null

created_at

Type: string

Example: example

description

Type: string | null

Default: ``

Type: string

Example: example

key

Type: string

Example: example

meta

Type: object

[additional]

Type: unknown

Example: null

Example

{}

path

Type: string | null

Example: example

plain_headers

Type: object | null

Example

{}

secret_headers

Type: object | null

Example

{}

secure

Type: boolean

type

Type: string

Const: json_api

Example: example

updated_at

Type: string

Example: example

workbook_id

Type: string | null

Default: null

Example

{
  "allowed_methods": [
    "GET"
  ],
  "collection_id": "null",
  "created_at": "example",
  "description": "",
  "dir_path": "example",
  "host": "example",
  "id": "example",
  "key": "example",
  "meta": {},
  "name": "example",
  "path": "example",
  "plain_headers": {},
  "port": 0,
  "secret_headers": {},
  "secure": true,
  "type": "json_api",
  "updated_at": "example",
  "workbook_id": "null"
}

metrika_api

Name

Description

counter_id

Type: string

Example: example

dir_path

Type: string

Example: example

name

Type: string

Example: example

accuracy

Type: number | null

Default: null

collection_id

Type: string | null

Default: null

created_at

Type: string

Example: example

data_export_forbidden

Type: unknown

Default: off

description

Type: string | null

Default: ``

Type: string

Example: example

key

Type: string

Example: example

meta

Type: object

[additional]

Type: unknown

Example: null

Example

{}

type

Type: string

Const: metrika_api

Example: example

updated_at

Type: string

Example: example

workbook_id

Type: string | null

Default: null

Example

{
  "accuracy": null,
  "collection_id": "null",
  "counter_id": "example",
  "created_at": "example",
  "data_export_forbidden": "off",
  "description": "",
  "dir_path": "example",
  "id": "example",
  "key": "example",
  "meta": {},
  "name": "example",
  "type": "metrika_api",
  "updated_at": "example",
  "workbook_id": "null"
}

mssql

Name

Description

dir_path

Type: string

Example: example

host

Type: string

Example: example

name

Type: string

Example: example

port

Type: integer

username

Type: string

Example: example

cache_invalidation_throttling_interval_sec

Type: integer | null

Default: null

cache_ttl_sec

Type: integer | null

Default: null

collection_id

Type: string | null

Default: null

created_at

Type: string

Example: example

data_export_forbidden

Type: unknown

Default: off

db_name

Type: string | null

Example: example

description

Type: string | null

Default: ``

Type: string

Example: example

key

Type: string

Example: example

meta

Type: object

[additional]

Type: unknown

Example: null

Example

{}

raw_sql_level

Type: string

Default: off

Enum: off, subselect, template, dashsql

type

Type: string

Const: mssql

Example: example

updated_at

Type: string

Example: example

workbook_id

Type: string | null

Default: null

Example

{
  "cache_invalidation_throttling_interval_sec": null,
  "cache_ttl_sec": null,
  "collection_id": "null",
  "created_at": "example",
  "data_export_forbidden": "off",
  "db_name": "example",
  "description": "",
  "dir_path": "example",
  "host": "example",
  "id": "example",
  "key": "example",
  "meta": {},
  "name": "example",
  "port": 0,
  "raw_sql_level": "off",
  "type": "mssql",
  "updated_at": "example",
  "username": "example",
  "workbook_id": "null"
}

mysql

Name

Description

dir_path

Type: string

Example: example

host

Type: string

Example: example

name

Type: string

Example: example

port

Type: integer

username

Type: string

Example: example

cache_invalidation_throttling_interval_sec

Type: integer | null

Default: null

cache_ttl_sec

Type: integer | null

Default: null

collection_id

Type: string | null

Default: null

created_at

Type: string

Example: example

data_export_forbidden

Type: unknown

Default: off

db_name

Type: string | null

Example: example

description

Type: string | null

Default: ``

enforce_collate

Type: string

Default: off

Enum: auto, on, off

Type: string

Example: example

key

Type: string

Example: example

meta

Type: object

[additional]

Type: unknown

Example: null

Example

{}

raw_sql_level

Type: string

Default: off

Enum: off, subselect, template, dashsql

ssl_enable

Type: unknown

Default: off

type

Type: string

Const: mysql

Example: example

updated_at

Type: string

Example: example

workbook_id

Type: string | null

Default: null

Example

{
  "cache_invalidation_throttling_interval_sec": null,
  "cache_ttl_sec": null,
  "collection_id": "null",
  "created_at": "example",
  "data_export_forbidden": "off",
  "db_name": "example",
  "description": "",
  "dir_path": "example",
  "enforce_collate": "off",
  "host": "example",
  "id": "example",
  "key": "example",
  "meta": {},
  "name": "example",
  "port": 0,
  "raw_sql_level": "off",
  "ssl_enable": "off",
  "type": "mysql",
  "updated_at": "example",
  "username": "example",
  "workbook_id": "null"
}

oracle

Name

Description

db_connect_method

Type: string

Enum: sid, service_name

dir_path

Type: string

Example: example

host

Type: string

Example: example

name

Type: string

Example: example

port

Type: integer

username

Type: string

Example: example

cache_invalidation_throttling_interval_sec

Type: integer | null

Default: null

cache_ttl_sec

Type: integer | null

Default: null

collection_id

Type: string | null

Default: null

created_at

Type: string

Example: example

data_export_forbidden

Type: unknown

Default: off

db_name

Type: string | null

Example: example

description

Type: string | null

Default: ``

Type: string

Example: example

key

Type: string

Example: example

meta

Type: object

[additional]

Type: unknown

Example: null

Example

{}

raw_sql_level

Type: string

Default: off

Enum: off, subselect, template, dashsql

ssl_enable

Type: unknown

Default: off

type

Type: string

Const: oracle

Example: example

updated_at

Type: string

Example: example

workbook_id

Type: string | null

Default: null

Example

{
  "cache_invalidation_throttling_interval_sec": null,
  "cache_ttl_sec": null,
  "collection_id": "null",
  "created_at": "example",
  "data_export_forbidden": "off",
  "db_connect_method": "sid",
  "db_name": "example",
  "description": "",
  "dir_path": "example",
  "host": "example",
  "id": "example",
  "key": "example",
  "meta": {},
  "name": "example",
  "port": 0,
  "raw_sql_level": "off",
  "ssl_enable": "off",
  "type": "oracle",
  "updated_at": "example",
  "username": "example",
  "workbook_id": "null"
}

postgres

Name

Description

dir_path

Type: string

Example: example

host

Type: string

Example: example

name

Type: string

Example: example

port

Type: integer

username

Type: string

Example: example

cache_invalidation_throttling_interval_sec

Type: integer | null

Default: null

cache_ttl_sec

Type: integer | null

Default: null

collection_id

Type: string | null

Default: null

created_at

Type: string

Example: example

data_export_forbidden

Type: unknown

Default: off

db_name

Type: string | null

Example: example

description

Type: string | null

Default: ``

enforce_collate

Type: string

Default: auto

Enum: auto, on, off

Type: string

Example: example

key

Type: string

Example: example

meta

Type: object

[additional]

Type: unknown

Example: null

Example

{}

raw_sql_level

Type: string

Default: off

Enum: off, subselect, template, dashsql

ssl_enable

Type: unknown

Default: off

type

Type: string

Const: postgres

Example: example

updated_at

Type: string

Example: example

workbook_id

Type: string | null

Default: null

Example

{
  "cache_invalidation_throttling_interval_sec": null,
  "cache_ttl_sec": null,
  "collection_id": "null",
  "created_at": "example",
  "data_export_forbidden": "off",
  "db_name": "example",
  "description": "",
  "dir_path": "example",
  "enforce_collate": "auto",
  "host": "example",
  "id": "example",
  "key": "example",
  "meta": {},
  "name": "example",
  "port": 0,
  "raw_sql_level": "off",
  "ssl_enable": "off",
  "type": "postgres",
  "updated_at": "example",
  "username": "example",
  "workbook_id": "null"
}

promql

Name

Description

dir_path

Type: string

Example: example

host

Type: string

Example: example

name

Type: string

Example: example

port

Type: integer

auth_type

Type: unknown

Default: password

cache_invalidation_throttling_interval_sec

Type: integer | null

Default: null

cache_ttl_sec

Type: integer | null

Default: null

collection_id

Type: string | null

Default: null

created_at

Type: string

Example: example

data_export_forbidden

Type: unknown

Default: off

db_name

Type: string | null

Example: example

description

Type: string | null

Default: ``

Type: string

Example: example

key

Type: string

Example: example

meta

Type: object

[additional]

Type: unknown

Example: null

Example

{}

path

Type: string | null

Example: example

secure

Type: boolean

type

Type: string

Const: promql

Example: example

updated_at

Type: string

Example: example

username

Type: string | null

Example: example

workbook_id

Type: string | null

Default: null

Example

{
  "auth_type": "password",
  "cache_invalidation_throttling_interval_sec": null,
  "cache_ttl_sec": null,
  "collection_id": "null",
  "created_at": "example",
  "data_export_forbidden": "off",
  "db_name": "example",
  "description": "",
  "dir_path": "example",
  "host": "example",
  "id": "example",
  "key": "example",
  "meta": {},
  "name": "example",
  "path": "example",
  "port": 0,
  "secure": true,
  "type": "promql",
  "updated_at": "example",
  "username": "example",
  "workbook_id": "null"
}

trino

Name

Description

auth_type

Type: unknown

Example: null

dir_path

Type: string

Example: example

host

Type: string

Example: example

listing_sources

Type: unknown

Example: null

name

Type: string

Example: example

port

Type: integer

username

Type: string

Example: example

cache_invalidation_throttling_interval_sec

Type: integer | null

Default: null

cache_ttl_sec

Type: integer | null

Default: null

collection_id

Type: string | null

Default: null

created_at

Type: string

Example: example

data_export_forbidden

Type: unknown

Default: off

db_name

Type: string | null

Example: example

description

Type: string | null

Default: ``

Type: string

Example: example

key

Type: string

Example: example

meta

Type: object

[additional]

Type: unknown

Example: null

Example

{}

raw_sql_level

Type: string

Default: off

Enum: off, subselect, template, dashsql

ssl_enable

Type: unknown

Default: off

type

Type: string

Const: trino

Example: example

updated_at

Type: string

Example: example

workbook_id

Type: string | null

Default: null

Example

{
  "auth_type": null,
  "cache_invalidation_throttling_interval_sec": null,
  "cache_ttl_sec": null,
  "collection_id": "null",
  "created_at": "example",
  "data_export_forbidden": "off",
  "db_name": "example",
  "description": "",
  "dir_path": "example",
  "host": "example",
  "id": "example",
  "key": "example",
  "listing_sources": null,
  "meta": {},
  "name": "example",
  "port": 0,
  "raw_sql_level": "off",
  "ssl_enable": "off",
  "type": "trino",
  "updated_at": "example",
  "username": "example",
  "workbook_id": "null"
}

ydb

Name	Description
db_name	Type: string Example: `example`
dir_path	Type: string Example: `example`
host	Type: string Example: `example`
name	Type: string Example: `example`
port	Type: integer
auth_type	Type: string \| null Enum: `anonymous`, `password`, `oauth`, `null` Example: `anonymous`
cache_invalidation_throttling_interval_sec	Type: integer \| null Default: `null`
cache_ttl_sec	Type: integer \| null Default: `null`
collection_id	Type: string \| null Default: `null`
created_at	Type: string Example: `example`
data_export_forbidden	Type: unknown Default: `off`
description	Type: string \| null Default: ``
id	Type: string Example: `example`
key	Type: string Example: `example`
raw_sql_level	Type: string Default: `off` Enum: `off`, `subselect`, `template`, `dashsql`
ssl_enable	Type: unknown Default: `off`
type	Type: string Const: `ydb` Example: `example`
updated_at	Type: string Example: `example`
username	Type: string \| null Example: `example`
workbook_id	Type: string \| null Default: `null`

Example

{
  "auth_type": "anonymous",
  "cache_invalidation_throttling_interval_sec": null,
  "cache_ttl_sec": null,
  "collection_id": "null",
  "created_at": "example",
  "data_export_forbidden": "off",
  "db_name": "example",
  "description": "",
  "dir_path": "example",
  "host": "example",
  "id": "example",
  "key": "example",
  "name": "example",
  "port": 0,
  "raw_sql_level": "off",
  "ssl_enable": "off",
  "type": "ydb",
  "updated_at": "example",
  "username": "example",
  "workbook_id": "null"
}

Get connection

Update connection

Create connection

RequestRequest

HeadersHeaders

BodyBody

appmetrica_apiappmetrica_api

chytchyt

clickhouseclickhouse

greenplumgreenplum

json_apijson_api

metrika_apimetrika_api

mssqlmssql

mysqlmysql

oracleoracle

postgrespostgres

promqlpromql

trinotrino

ydbydb

ResponsesResponses

200 OK200 OK

BodyBody

appmetrica_apiappmetrica_api

chytchyt

clickhouseclickhouse

greenplumgreenplum

json_apijson_api

metrika_apimetrika_api

mssqlmssql

mysqlmysql

oracleoracle

postgrespostgres

promqlpromql

trinotrino

ydbydb

Request

Headers

Body

appmetrica_api

chyt

clickhouse

greenplum

json_api

metrika_api

mssql

mysql

oracle

postgres

promql

trino

ydb

Responses

200 OK

Body

appmetrica_api

chyt

clickhouse

greenplum

json_api

metrika_api

mssql

mysql

oracle

postgres

promql

trino

ydb