---
metadata:
  - name: generator
    content: Diplodoc Platform v5.52.0
alternate:
  - https://ydb.tech/docs/en/changelog-cli.md?version=v25.4
  - https://ydb.tech/docs/ru/changelog-cli.md?version=v25.4
  - href: en/changelog-cli.md
    type: text/markdown
    title: Markdown version
  - href: llms.txt
    type: text/markdown
    title: llms.txt
sourcePath: en/core/changelog-cli.md
---
> **Documentation Index:** Fetch the complete configuration index at https://ydb.tech/docs/en/llms.txt

# YDB CLI changelog

## Version 2.31.0 {#2-31-0}

Released on April 20, 2026. To update to version **2.31.0**, select the [Downloads](https://ydb.tech/docs/en/downloads/ydb-cli.md?version=v25.4) section.

### Features

* Added the `--stats` option to the `ydb workload * run` [commands](https://ydb.tech/docs/en/reference/ydb-cli/commands/workload/index.md?version=v25.4), enabling extended execution statistics collection (e.g., `--stats profile`).

## Version 2.30.0 {#2-30-0}

Released on April 7, 2026. To update to version **2.30.0**, select the [Downloads](https://ydb.tech/docs/en/downloads/ydb-cli.md?version=v25.4) section.

### Features

* Added the `ydb config completion` command to generate shell completion scripts for bash and zsh.
* Added the `ydb export nfs` and `ydb import nfs` commands, allowing users to create and restore backups directly to/from a shared NFS directory mounted on every host in the cluster.
* Added the `--compact` option to the `ydb workload tpcc import` [command](https://ydb.tech/docs/en/reference/ydb-cli/workload-tpcc.md?version=v25.4).
* Added the `--tx-mode` option to the `ydb workload * run` [commands](https://ydb.tech/docs/en/reference/ydb-cli/commands/workload/index.md?version=v25.4), which allows setting the transaction mode (e.g., `no-tx`, `serializable-rw`, `snapshot-rw`).
* Added support for the new [compaction](https://ydb.tech/docs/en/concepts/glossary.md?version=v25.4#compaction) operation in the `ydb operation` [subcommands](https://ydb.tech/docs/en/reference/ydb-cli/operation-list.md?version=v25.4).

### Improvements

* When a [profile](https://ydb.tech/docs/en/reference/ydb-cli/profile/index.md?version=v25.4) is explicitly specified with the `-p`/`--profile` option, the active profile is no longer used: all options are taken only from the specified profile, environment variables, and command line. This avoids confusion when the chosen profile was unexpectedly supplemented with settings from the active profile.

## Version 2.29.0 {#2-29-0}

Released on February 11, 2026. To update to version **2.29.0**, select the [Downloads](https://ydb.tech/docs/en/downloads/ydb-cli.md?version=v25.4) section.

### Features

* Enhancements to the `ydb` [interactive mode](https://ydb.tech/docs/en/reference/ydb-cli/interactive-cli.md?version=v25.4):
  * Introduced the `/help` command for interactive command guidance.
  * Introduced the `/config` command, providing an interactive dialog to view and customize YDB CLI settings, including:
    * Enabling or disabling autocompletion hints.
    * Enabling or disabling color output.
    * Interactively selecting a color theme from a set of predefined options, with support for cloning and customizing your own theme.
* Added a download progress bar to the `ydb update` [command](https://ydb.tech/docs/en/reference/ydb-cli/commands/service.md?version=v25.4).
* Added the `--include-index-data` option to the `ydb export s3` [command](https://ydb.tech/docs/en/reference/ydb-cli/export-import/export-s3.md?version=v25.4), enabling index data export.
* Added the `--index-population-mode` option to the `ydb import s3` [command](https://ydb.tech/docs/en/reference/ydb-cli/export-import/import-s3.md?version=v25.4), allowing selection of the index population mode (e.g., `build` or `import`).
* Added the `Created by`, `Create time`, and `End time` fields to the "build index" and "execute script" operations in the `ydb operation` [subcommands](https://ydb.tech/docs/en/reference/ydb-cli/operation-list.md?version=v25.4).
* Added unified time interval format support across YDB CLI commands. Options accepting time durations now support explicit time units (e.g., `5s`, `2m`, `1h`) while maintaining backward compatibility with plain numbers interpreted using their original default units.
* Replaced the deprecated "Keep in memory" field with the "Cache mode" field in the column families description of the `ydb scheme describe` [command](https://ydb.tech/docs/en/reference/ydb-cli/commands/scheme-describe.md?version=v25.4).

### Improvements

* Improved the `ydb init` and `ydb config profile` [commands](https://ydb.tech/docs/en/reference/ydb-cli/profile/index.md?version=v25.4) with interactive menus.
* Improved progress bars: consistent MiB/GiB units, stable speed display, and a dual progress bar for the `ydb import file` [command](https://ydb.tech/docs/en/reference/ydb-cli/export-import/import-file.md?version=v25.4) showing both in-progress and confirmed bytes.

### Bug fixes

* Fixed an out-of-memory issue in the `ydb workload query run` [command](https://ydb.tech/docs/en/reference/ydb-cli/commands/workload/index.md?version=v25.4) for queries with large result sets.
* Fixed static credentials parsing to avoid using a [profile](https://ydb.tech/docs/en/reference/ydb-cli/profile/index.md?version=v25.4) password when the username comes from another source.

## Version 2.28.0 {#2-28-0}

Released on December 19, 2025. To update to version **2.28.0**, select the [Downloads](https://ydb.tech/docs/en/downloads/ydb-cli.md?version=v25.4) section.

### Features

* Added `snapshot-ro` and `snapshot-rw` transaction modes to the `--tx-mode` option of the `ydb table query execute` [command](https://ydb.tech/docs/en/reference/ydb-cli/table-query-execute.md?version=v25.4).
* Added `NO_COLOR` environment variable support to disable ANSI colors in YDB CLI (see [no-color.org](https://no-color.org/)).
* Added a simple progress bar for non-interactive stderr.
* Added the `omit-indexes` property to the `--item` option of the `ydb tools copy` [command](https://ydb.tech/docs/en/reference/ydb-cli/tools-copy.md?version=v25.4), allowing tables to be copied without their indexes.
* Added the `import files` subcommand to the `ydb workload vector` [command](https://ydb.tech/docs/en/reference/ydb-cli/commands/workload/index.md?version=v25.4) to populate the table from CSV or Parquet files.
* Added the `import generate` subcommand to the `ydb workload vector` [command](https://ydb.tech/docs/en/reference/ydb-cli/commands/workload/index.md?version=v25.4) to populate the table with random data.
* **_(Requires server v26.1+)_** Changes to previously added `ydb admin cluster state fetch` command:
  * Renamed to `ydb admin cluster diagnostics collect`.
  * Added the `--no-sanitize` option, which disables sanitization and preserves sensitive data in the output.
  * Added the `--output` option to specify the path to the output `.tar.bz2` file.


### Bug fixes

* Fixed a bug where the `ydb tools restore` [command](https://ydb.tech/docs/en/reference/ydb-cli/export-import/tools-restore.md?version=v25.4) could crash with a `mutex lock failure (Invalid argument)` error due to an internal race condition.
* Fixed restoration of views containing named expressions and views that access secondary indexes in the `ydb tools restore` [command](https://ydb.tech/docs/en/reference/ydb-cli/export-import/tools-restore.md?version=v25.4).

## Version 2.27.0 {#2-27-0}

Released on October 30, 2025. To update to version **2.27.0**, select the [Downloads](https://ydb.tech/docs/en/downloads/ydb-cli.md?version=v25.4) section.

### Features

* Added the `--exclude` option to the `ydb import s3` [command](https://ydb.tech/docs/en/reference/ydb-cli/export-import/import-s3.md?version=v25.4), allowing schema objects to be excluded from the import if their names match a pattern.
* Added [transfer](https://ydb.tech/docs/en/concepts/transfer.md?version=v25.4) objects support to the `ydb tools dump` [command](https://ydb.tech/docs/en/reference/ydb-cli/export-import/tools-dump.md?version=v25.4) and `ydb tools restore` [command](https://ydb.tech/docs/en/reference/ydb-cli/export-import/tools-restore.md?version=v25.4).
* Added a new `--retention-period` option to the `ydb topic` subcommands. Usage of the legacy `--retention-period-hours` option is discouraged.
* The `ydb topic consumer add` [command](https://ydb.tech/docs/en/reference/ydb-cli/topic-consumer-add.md?version=v25.4) now has a new `--availability-period` option, which overrides the consumer's retention guarantee.
* The `ydb workload vector` [commands](https://ydb.tech/docs/en/reference/ydb-cli/commands/workload/index.md?version=v25.4) now support `build-index` and `drop-index` subcommands.
* **_(Requires server v26.1+)_** Added the `ydb admin cluster state fetch` command to collect information about cluster nodes' state and metrics.

### Bug fixes

* Fixed a bug where the `ydb debug ping` command crashed on any error.

## Version 2.26.0 {#2-26-0}

Released on September 25, 2025. To update to version **2.26.0**, select the [Downloads](https://ydb.tech/docs/en/downloads/ydb-cli.md?version=v25.4) section.

### Features

* Added the `--no-merge` and `--no-cache` options to the `ydb monitoring healthcheck` [command](https://ydb.tech/docs/en/reference/ydb-cli/commands/monitoring-healthcheck.md?version=v25.4).
* Added query compilation time statistics to the `ydb workload * run` [commands](https://ydb.tech/docs/en/reference/ydb-cli/commands/workload/index.md?version=v25.4).
* Added the `--retries` option to the `ydb tools restore` [command](https://ydb.tech/docs/en/reference/ydb-cli/export-import/tools-restore.md?version=v25.4), which allows setting the number of retries for every upload data request.
* **_(Requires server v25.4+)_** Added the `--replace-sys-acl` option to the `ydb tools restore` [command](https://ydb.tech/docs/en/reference/ydb-cli/export-import/tools-restore.md?version=v25.4), which specifies whether to replace the ACL for system objects.

## Version 2.25.0 {#2-25-0}

Released on September 1, 2025. To update to version **2.25.0**, select the [Downloads](https://ydb.tech/docs/en/downloads/ydb-cli.md?version=v25.4) section.

### Features

* Added final execute statistics to the `ydb workload * run` [commands](https://ydb.tech/docs/en/reference/ydb-cli/commands/workload/index.md?version=v25.4).
* Added the `--start-offset` option to the `ydb topic read` [command](https://ydb.tech/docs/en/reference/ydb-cli/topic-read.md?version=v25.4), which specifies a starting position for reading from the selected partition.
* **_(Requires server v25.3+)_** Added a new paths approach in the `ydb export s3` and `ydb import s3` [commands](https://ydb.tech/docs/en/reference/ydb-cli/export-import/export-s3.md?version=v25.4) with the new `--include` option instead of the `--item` option.
* **_(Requires server v25.3+)_** Added support for encryption features in the `ydb export s3` and `ydb import s3` [commands](https://ydb.tech/docs/en/reference/ydb-cli/export-import/export-s3.md?version=v25.4).
* **_(Requires server v25.3+)_** **_(Experimental)_** Added the `ydb admin cluster bridge` commands to manage a cluster in the bridge mode: `list`, `switchover`, `failover`, `takedown`, `rejoin`.

### Improvements

* User and password authentication options are now parsed independently, allowing them to be sourced from different priority levels. For example, the username can be specified via the `--user` option while the password is retrieved from the `YDB_PASSWORD` environment variable.
* Changed the default logging level from `EMERGENCY` to `WARN` for commands that support multiple verbosity levels.

### Backward incompatible changes

* Removed the `--float-mode` option from the `ydb workload tpch run` and `ydb workload tpcds run` [commands](https://ydb.tech/docs/en/reference/ydb-cli/commands/workload/index.md?version=v25.4). Float mode is now inferred automatically from the table schema created during the `init` phase.

### Bug fixes

* Fixed a bug where the `ydb import file csv` [command](https://ydb.tech/docs/en/reference/ydb-cli/export-import/import-file.md?version=v25.4) with the `--newline-delimited` option could get stuck when processing input with invalid data.
* Fixed an issue with the progress bar display in the `ydb workload clickbench import files` [command](https://ydb.tech/docs/en/reference/ydb-cli/workload-click-bench.md?version=v25.4): incorrect percentage values and excessive line breaks caused duplicate progress lines.
* Fixed a bug where the `ydb workload topic write` [command](https://ydb.tech/docs/en/reference/ydb-cli/topic-write.md?version=v25.4) could crash with an `Unknown AckedMessageId` error due to an internal race condition.
* Fixed decimal type comparison in the `ydb workload * run` [commands](https://ydb.tech/docs/en/reference/ydb-cli/commands/workload/index.md?version=v25.4).

## Version 2.24.1 {#2-24-1}

Released on July 28, 2025. To update to version **2.24.1**, select the [Downloads](https://ydb.tech/docs/en/downloads/ydb-cli.md?version=v25.4) section.

### Bug fixes

* Fixed a bug where the `ydb tools dump` [command](https://ydb.tech/docs/en/reference/ydb-cli/export-import/tools-dump.md?version=v25.4#schema-objects) silently skipped schema objects of unsupported types and created empty directories for them in the destination folder on the file system.

## Version 2.24.0 {#2-24-0}

Released on July 23, 2025. To update to version **2.24.0**, select the [Downloads](https://ydb.tech/docs/en/downloads/ydb-cli.md?version=v25.4) section.

### Features

* Added the ability for the `ydb workload tpch` and `ydb workload tpcds` [commands](https://ydb.tech/docs/en/reference/ydb-cli/commands/workload/index.md?version=v25.4) to use a fractional value for the `--scale` option, specifying a percentage of the full benchmark's data size and workload.
* Added the `ydb workload tpcc check` command to check TPC-C data consistency.

### Improvements

* Changed the default storage type in `ydb workload * init` [commands](https://ydb.tech/docs/en/reference/ydb-cli/commands/workload/index.md?version=v25.4) to `column` (from `row`), and the default datetime mode to `datetime32` (from `datetime64`).

### Bug fixes

* Fixed an issue where the `ydb import file csv` [command](https://ydb.tech/docs/en/reference/ydb-cli/export-import/import-file.md?version=v25.4) could get stuck during execution.

## Version 2.23.0 {#2-23-0}

Released on July 16, 2025. To update to version **2.23.0**, select the [Downloads](https://ydb.tech/docs/en/downloads/ydb-cli.md?version=v25.4) section.

### Features

* Added the `ydb workload tpcc` command to run a TPC-C benchmark.
* Added the `ydb workload vector select` command to benchmark vector index performance and recall.
* Added the `ydb tools infer csv` command to generate a `CREATE TABLE` SQL query from a CSV data file.

### Improvements

* Enhanced processing of special values (`null`, `/dev/null`, `stdout`, `cout`, `console`, `stderr`, and `cerr`) for the `--output` option in the `ydb workload * run` [commands](https://ydb.tech/docs/en/reference/ydb-cli/commands/workload/index.md?version=v25.4).
* The `ydb workload` [commands](https://ydb.tech/docs/en/reference/ydb-cli/commands/workload/index.md?version=v25.4) now work with absolute paths for database scheme objects.
* Improvements in the `ydb` [interactive mode](https://ydb.tech/docs/en/reference/ydb-cli/interactive-cli.md?version=v25.4):
  * Added server connection check and hotkeys description.
  * Improved inline hints.
  * Added table column names completion.
  * Added schema caching.

### Bug fixes

* Fixed an issue where the `ydb tools restore` [command](https://ydb.tech/docs/en/reference/ydb-cli/export-import/tools-restore.md?version=v25.4) was not working on Windows.

## Version 2.22.1 {#2-22-1}

Released on June 17, 2025. To update to version **2.22.1**, select the [Downloads](https://ydb.tech/docs/en/downloads/ydb-cli.md?version=v25.4) section.

### Bug fixes

* Fixed an issue where the certificate was not read from a file if the path to the file was specified in the [profile](https://ydb.tech/docs/en/reference/ydb-cli/profile/index.md?version=v25.4) with the `ca-file` field.
* Fixed an issue where the `ydb workload query import` and `ydb workload clickbench import files` [commands](https://ydb.tech/docs/en/reference/ydb-cli/workload-click-bench.md?version=v25.4) displayed number of rows instead of number of bytes in progress state.

## Version 2.22.0 {#2-22-0}

Released on June 4, 2025. To update to version **2.22.0**, select the [Downloads](https://ydb.tech/docs/en/downloads/ydb-cli.md?version=v25.4) section.

### Features

* Added scheme object names completion in interactive mode.
* Enhanced the capabilities of the `ydb workload query` command: added `ydb workload query init`, `ydb workload query import`, and `ydb workload query clean` commands, and modified the `ydb workload query run` command. Using these commands, you can initialize tables, populate them with data, perform load testing, and clean up the data afterwards.
* Added the `--threads` option to the `ydb workload clickbench run`, `ydb workload tpch run`, and `ydb workload tpcds run` [commands](https://ydb.tech/docs/en/reference/ydb-cli/workload-click-bench.md?version=v25.4). This option allows to specify the number of threads sending the queries.
* **_(Requires server v25.1+)_** **_(Experimental)_** Added the `ydb admin cluster config version` [command](https://ydb.tech/docs/en/reference/ydb-cli/commands/configuration/cluster/index.md?version=v25.4#list) to show the configuration version (V1/V2) on nodes.

### Backward incompatible changes

* Removed the `--executor` option from the `ydb workload * run` [commands](https://ydb.tech/docs/en/reference/ydb-cli/commands/workload/index.md?version=v25.4). The `generic` executor is now always used.

### Bug fixes

* Fixed an issue where the `ydb workload * clean` [commands](https://ydb.tech/docs/en/reference/ydb-cli/commands/workload/index.md?version=v25.4) were deleting all contents from the target directory, instead of just the tables created by the init command.

## Version 2.21.0 {#2-21-0}

Released on May 22, 2025. To update to version **2.21.0**, select the [Downloads](https://ydb.tech/docs/en/downloads/ydb-cli.md?version=v25.4) section.

### Features

* Added the `--no-discovery` [global option](https://ydb.tech/docs/en/reference/ydb-cli/commands/global-options.md?version=v25.4), which allows skipping discovery and connecting to a user-provided endpoint directly.
* Added new options for workload commands:
  * Added the `--scale` option to the `ydb workload tpch init` and `ydb workload tpcds init` [commands](https://ydb.tech/docs/en/reference/ydb-cli/workload-tpch.md?version=v25.4) to set the percentage of the benchmark's data size and workload to use, relative to full scale.
  * Added the `--retries` option to the `ydb workload <clickbench|tpch|tpcds> run` [commands](https://ydb.tech/docs/en/reference/ydb-cli/workload-click-bench.md?version=v25.4) to specify maximum retry count for every request.
  * Added the `--partition-size` option to the `ydb workload <clickbench|tpcds|tpch> init` [commands](https://ydb.tech/docs/en/reference/ydb-cli/workload-click-bench.md?version=v25.4) to set maximum partition size in megabytes for row tables.
  * Added date range parameters (`--date-to`, `--date-from`) to the `ydb workload log run` command to support uniform primary key distribution.
* Enhanced backup and restore functionality:
  * Added the `--replace` and `--verify-existence` options to the `ydb tools restore` [command](https://ydb.tech/docs/en/reference/ydb-cli/export-import/tools-restore.md?version=v25.4#schema-objects) to control the removal of existing objects that match those in the backup before restoration.
  * Improved the `ydb tools dump` [command](https://ydb.tech/docs/en/reference/ydb-cli/export-import/tools-dump.md?version=v25.4#schema-objects) by not saving [replica tables](https://ydb.tech/docs/en/concepts/async-replication.md?version=v25.4) with ASYNC REPLICATION and their [changefeeds](https://ydb.tech/docs/en/concepts/glossary.md?version=v25.4#changefeed) to local backups. It prevents duplication of changefeeds and reduces the amount of space the backup takes on disk.
* Enhanced CLI usability:
  * Detailed help message (`-hh`) now shows the whole subcommand tree.
  * Added automatic pair insertion for brackets in `ydb` interactive mode.
  * Added support for files with BOM (Byte Order Mark) in the `ydb import file` [commands](https://ydb.tech/docs/en/reference/ydb-cli/export-import/import-file.md?version=v25.4).
* **_(Requires server v25.1+)_** **_(Experimental)_** Improved the `ydb debug latency` command:
  * Added the `--min-inflight` parameter to set minimum number of concurrent requests (default: 1).
  * Added the `--percentile` option to specify custom latency percentiles.
  * Enhanced the output with additional gRPC ping measurements.

### Bug fixes

* The `ydb operation get` [command](https://ydb.tech/docs/en/reference/ydb-cli/operation-get.md?version=v25.4) now properly handles running operations.
* Fixed errors in the `ydb scheme rmdir` [command](https://ydb.tech/docs/en/reference/ydb-cli/commands/dir.md?version=v25.4#rmdir):
  * Fixed an issue where the command was trying to delete subdomains.
  * Fixed deletion order: external tables are now deleted before external data sources due to possible dependencies between them.
  * Added support for coordination nodes in recursive removal.
* Fixed return code of the `ydb workload * run --check-canonical` command when results differ from canonical ones.
* Fixed an issue where CLI was attempting to read parameters from stdin even without available data.
* **_(Requires server v25.1+)_** **_(Experimental)_** Fixed an authorization error in the `ydb admin database restore` [command](https://ydb.tech/docs/en/reference/ydb-cli/export-import/tools-restore.md?version=v25.4#db) when restoring from a backup containing multiple database administrator accounts.

## Version 2.20.0 {#2-20-0}

Released on March 5, 2025. To update to version **2.20.0**, select the [Downloads](https://ydb.tech/docs/en/downloads/ydb-cli.md?version=v25.4) section.

### Features

* Added [topics](https://ydb.tech/docs/en/concepts/datamodel/topic.md?version=v25.4) support in the `ydb tools dump` and `ydb tools restore` [commands](https://ydb.tech/docs/en/reference/ydb-cli/export-import/tools-dump.md?version=v25.4). In this release, only topic settings are retained; messages are not included in the backup.
* Added [coordination nodes](https://ydb.tech/docs/en/concepts/datamodel/coordination-node.md?version=v25.4) support in the `ydb tools dump` and `ydb tools restore` [commands](https://ydb.tech/docs/en/reference/ydb-cli/export-import/tools-dump.md?version=v25.4).
* Added the new `ydb workload log import generator` command.
* Added new global options for client certificates in SSL/TLS connections:
  * `--client-cert-file`: File containing a client certificate for SSL/TLS connections (PKCS#12 or PEM-encoded).
  * `--client-cert-key-file`: File containing a PEM-encoded private key for the client certificate.
  * `--client-cert-key-password-file`: File containing a password for the private key (if the key is encrypted).
* Queries in the `ydb workload run` command are now executed in random order.
* **_(Requires server v25.1+)_** Added support for [external data sources](https://ydb.tech/docs/en/concepts/datamodel/external_data_source.md?version=v25.4) and [external tables](https://ydb.tech/docs/en/concepts/datamodel/external_table.md?version=v25.4) in the `ydb tools dump` and `ydb tools restore` [commands](https://ydb.tech/docs/en/reference/ydb-cli/export-import/tools-dump.md?version=v25.4).
* **_(Experimental)_** Added the `ydb admin node config init` command to initialize a directory with node configuration files.
* **_(Requires server v25.1+)_** **_(Experimental)_** Added the `ydb admin cluster config generate` [command](https://ydb.tech/docs/en/reference/ydb-cli/commands/configuration/cluster/generate.md?version=v25.4) to generate a dynamic configuration file from a cluster static configuration file.
* **_(Requires server v25.1+)_** **_(Experimental)_** Added the [command](https://ydb.tech/docs/en/reference/ydb-cli/export-import/tools-dump.md?version=v25.4#cluster) `ydb admin cluster dump` and the [command](https://ydb.tech/docs/en/reference/ydb-cli/export-import/tools-restore.md?version=v25.4#cluster) `ydb admin cluster restore` for dumping all cluster-level data. These dumps contain a list of databases with metadata, users, and groups but do not include schema objects.
* **_(Requires server v25.1+)_** **_(Experimental)_** Added the `ydb admin database dump` and `ydb admin database restore` commands for dumping all database-level data. These dumps contain database metadata, schema objects, their data, users, and groups.
* **_(Requires server v25.1+)_** **_(Experimental)_** Added the `--dedicated-storage-section` and `--dedicated-cluster-section` options to the `ydb admin cluster config fetch` command, allowing cluster and storage config sections to be fetched separately.

### Bug fixes

* Fixed a bug where the `ydb auth get-token` command attempted to authenticate twice: once while listing endpoints and again while executing the actual token request.
* Fixed a bug where the `ydb import file csv` command was saving progress even if a batch upload had failed.
* Fixed a bug where some errors could be ignored when restoring from a local backup with the `ydb tools restore` command.
* Fixed a memory leak in the data generator for the `ydb workload tpcds` benchmark.

## Version 2.19.0 {#2-19-0}

Released on February 5, 2025. To update to version **2.19.0**, select the [Downloads](https://ydb.tech/docs/en/downloads/ydb-cli.md?version=v25.4) section.

### Features

* Added [changefeeds](https://ydb.tech/docs/en/concepts/cdc.md?version=v25.4) support in the `ydb tools dump` and `ydb tools restore` [commands](https://ydb.tech/docs/en/reference/ydb-cli/export-import/tools-dump.md?version=v25.4).
* Added `CREATE TABLE` text suggestion on schema error during the `ydb import file csv` [command](https://ydb.tech/docs/en/reference/ydb-cli/export-import/import-file.md?version=v25.4).
* Added statistics output on the current progress of the query in the `ydb workload` [command](https://ydb.tech/docs/en/reference/ydb-cli/commands/workload/index.md?version=v25.4).
* Added query text to the error message if a query fails in the `ydb workload run` [command](https://ydb.tech/docs/en/reference/ydb-cli/commands/workload/index.md?version=v25.4).
* Added a message if the global timeout expired in the `ydb workload run` [command](https://ydb.tech/docs/en/reference/ydb-cli/commands/workload/index.md?version=v25.4).
* **_(Requires server v25.1+)_** Added [views](https://ydb.tech/docs/en/concepts/datamodel/view.md?version=v25.4) support in the `ydb export s3` and `ydb import s3`. Views are exported as `CREATE VIEW` YQL statements, which are executed on import.
* **_(Requires server v25.1+)_** Added the `--skip-checksum-validation` option to the `ydb import s3` [command](https://ydb.tech/docs/en/reference/ydb-cli/export-import/import-s3.md?version=v25.4) to skip server-side checksum validation.
* **_(Requires server v25.1+)_** **_(Experimental)_** Added new options for the `ydb debug ping` command: `--chain-length`, `--chain-work-duration`, `--no-tail-chain`.
* **_(Requires server v25.1+)_** **_(Experimental)_** Added new options for the `ydb admin storage fetch` command: `--dedicated-storage-section` and `--dedicated-cluster-section`.
* **_(Requires server v25.1+)_** **_(Experimental)_** Added new options for the `ydb admin storage replace` command: `--filename`, `--dedicated-cluster-yaml`, `--dedicated-storage-yaml`, `--enable-dedicated-storage-section` and `--disable-dedicated-storage-section`.

### Bug fixes

* Fixed a bug where the arm64 YDB CLI binary was downloading the amd64 binary to replace itself during the `ydb update` [command](https://ydb.tech/docs/en/reference/ydb-cli/commands/service.md?version=v25.4). To update already installed binaries to the latest arm64 version, YDB CLI should be reinstalled.
* Fixed the return code of the `ydb workload run` [command](https://ydb.tech/docs/en/reference/ydb-cli/commands/workload/index.md?version=v25.4).
* Fixed a bug where the `ydb workload tpch import generator` and `ydb workload tpcds import generator` [commands](https://ydb.tech/docs/en/reference/ydb-cli/workload-tpch.md?version=v25.4) were failing because not all tables had been created.
* Fixed a bug with backslashes in the `ydb workload` [commands](https://ydb.tech/docs/en/reference/ydb-cli/commands/workload/index.md?version=v25.4) paths on Windows.

## Version 2.18.0 {#2-18-0}

Released on December 24, 2024. To update to version **2.18.0**, select the [Downloads](https://ydb.tech/docs/en/downloads/ydb-cli.md?version=v25.4) section.

### Features

* Added support for [views](https://ydb.tech/docs/en/concepts/datamodel/view.md?version=v25.4) in local backups: `ydb tools dump` and `ydb tools restore`. Views are backed up as `CREATE VIEW` queries saved in the `create_view.sql` files, which can be executed to recreate the original views.
* Added new options to the `ydb workload topic run` [command](https://ydb.tech/docs/en/reference/ydb-cli/workload-topic.md?version=v25.4#run-write): `--tx-commit-interval` and `--tx-commit-messages`, allowing you to specify the interval between transaction commits in milliseconds or in the number of messages written, respectively.
* Made the `--consumer` flag in the `ydb topic read` [command](https://ydb.tech/docs/en/reference/ydb-cli/topic-read.md?version=v25.4) optional. In the non-subscriber reading mode, the partition IDs must be specified with the `--partition-ids` option. In this case, the read is performed without saving the offset commit.
* The `ydb import file csv` [command](https://ydb.tech/docs/en/reference/ydb-cli/export-import/import-file.md?version=v25.4) now saves the import progress. Relaunching the import command will resume the process from the row where it was interrupted.
* In the `ydb workload kv` and `ydb workload stock` commands, the default value of the `--executer` option has been changed to `generic`, which makes them no longer rely on the legacy query execution infrastructure.
* Replaced the CSV format with Parquet for filling tables in the `ydb workload` benchmarks.
* **_(Requires server v25.1+)_** **_(Experimental)_** Added new `ydb admin storage` command with `fetch` and `replace` subcommands to manage server storage configuration.

### Backward incompatible changes

* Replaced the `--query-settings` option with `--query-prefix` in the `ydb workload * run` command.

### Bug fixes

* Fixed a bug where the `ydb workload * run` command could crash in `--dry-run` mode.
* Fixed a bug in the `ydb import file csv` where multiple columns with escaped quotes in the same row were parsed incorrectly.


## Version 2.17.0 {#2-17-0}

Released on December 4, 2024. To update to version **2.17.0**, select the [Downloads](https://ydb.tech/docs/en/downloads/ydb-cli.md?version=v25.4) section.

### Features

* **_(Requires server v25.1+)_** **_(Experimental)_** Added the `ydb debug ping` command for performance and connectivity debugging.

### Performance

* Improved performance of parallel [importing data from the file system](https://ydb.tech/docs/en/reference/ydb-cli/export-import/tools-restore.md?version=v25.4) using the `ydb tools restore` command.

### Bug fixes

* Fixed a bug in the table schema created by the `ydb workload tpch` command where the `partsupp` table contained an incorrect list of key columns.
* Resolved an issue where the `ydb tools restore` command failed with the error "Too much data" if the maximum value of the `--upload-batchbytes` option was set to 16 MB.

## Version 2.16.0 {#2-16-0}

Released on November 26, 2024. To update to version **2.16.0**, select the [Downloads](https://ydb.tech/docs/en/downloads/ydb-cli.md?version=v25.4) section.

### Features

* Improved throughput of the `ydb import file csv` command by up to 3 times.
* Added support for running the [stock benchmark](https://ydb.tech/docs/en/reference/ydb-cli/commands/workload/stock.md?version=v25.4) with [column-oriented tables](https://ydb.tech/docs/en/concepts/datamodel/table.md?version=v25.4#column-oriented-tables).
* Added support for [ISO 8601](https://en.wikipedia.org/wiki/ISO_8601)–formatted timestamps in the `ydb topic` commands.
* Added the `--explain-ast` option to the `ydb sql` command, which prints the query AST.
* Added ANSI SQL syntax highlighting in interactive mode.
* Added support for [PostgreSQL syntax](https://ydb.tech/docs/en/postgresql/intro.md?version=v25.4) in the `ydb workload tpch` and `ydb workload tpcds` benchmarks.
* Introduced the `-c` option for the `ydb workload tpcds run` command to compare results with expected values and display differences.
* Added log events for the `ydb tools dump` and `ydb tools restore` commands.
* Enhanced the `ydb tools restore` command to display error locations.

### Backward incompatible changes

* Changed the default value of the `ydb topic write` command's `--codec` option to `RAW`.

### Bug fixes

* Fixed the progress bar in the `ydb workload import` command.
* Resolved an issue where restoring from a backup using the `--import-data` option could fail if the table's partitioning had changed.

## Version 2.10.0 {#2-10-0}

Released on June 24, 2024. To update to version **2.10.0**, select the [Downloads](https://ydb.tech/docs/en/downloads/ydb-cli.md?version=v25.4) section.

### Features

* Added the `ydb sql` command that runs over QueryService and can execute any DML/DDL command.
* Added `notx` support for the `--tx-mode` option in the `ydb table query execute` command.
* Added start and end times for long-running operation descriptions (export, import).
* Added replication description support in the `ydb scheme describe` and `ydb scheme ls` commands.
* Added big datetime types support: `Date32`, `Datetime64`, `Timestamp64`, `Interval64`.
* `ydb workload` commands rework:

  * Added the `--clear` option to the `init` subcommand, allowing tables from previous runs to be removed before workload initialization.
  * Added the `ydb workload * import` command to prepopulate tables with initial content before executing benchmarks.

### Backward incompatible changes

* `ydb workload` commands rework:

  * The `--path` option was moved to a specific workload level. For example: `ydb workload tpch --path some/tables/path init ...`.
  * The `--store=s3` option was changed to `--store=external-s3` in the `init` subcommand.


### Bug fixes

* Fixed colors in the `PrettyTable` format

## Version 2.9.0 {#2-9-0}

Released on April 25, 2024. To update to version **2.9.0**, select the [Downloads](https://ydb.tech/docs/en/downloads/ydb-cli.md?version=v25.4) section.

### Features

* Improved query logical plan tables: added colors, more information, fixed some bugs.
* The verbose option `-v` is supported for the `ydb workload` commands to provide debug information.
* Added an option to run the `ydb workload tpch` command with an S3 source to measure [federated queries](https://ydb.tech/docs/en/concepts/query_execution/federated_query/index.md?version=v25.4) performance.
* Added the `--rate` option for `ydb workload` commands to control the transactions (or requests) per second limit.
* Added the `--use-virtual-addressing` option for S3 import/export, allowing the switch to [virtual hosting of buckets](https://docs.aws.amazon.com/AmazonS3/latest/userguide/VirtualHosting.html) for the S3 path layout.
* Improved the `ydb scheme ls` command performance due to listing directories in parallel.

### Bug fixes

* Resolved an issue where extra characters were truncated during line transfers in CLI tables.
* Fixed invalid memory access in `tools restore`.
* Fixed the issue of the `--timeout` option being ignored in generic and scan queries, as well as in the import command.
* Added a 60-second timeout to version checks and CLI binary downloads to prevent infinite waiting.
* Minor bug fixes.

## Version 2.8.0 {#2-8-0}

Released on January 12, 2024. To update to version **2.8.0**, select the [Downloads](https://ydb.tech/docs/en/downloads/ydb-cli.md?version=v25.4) section.

### Features

* Added new `ydb admin config` and `ydb admin volatile-config` commands for cluster configuration management.
* Added support for loading PostgreSQL-compatible data types by [ydb import file csv|tsv|json](https://ydb.tech/docs/en/reference/ydb-cli/export-import/import-file.md?version=v25.4) command. Only for row-oriented tables.
* Added support for directory load from an S3-compatible storage in the [ydb import s3](https://ydb.tech/docs/en/reference/ydb-cli/export-import/import-s3.md?version=v25.4) command. Currently only available on Linux and Mac OS.
* Added support for outputting the results of [ydb table query execute](https://ydb.tech/docs/en/reference/ydb-cli/table-query-execute.md?version=v25.4), [ydb yql](https://ydb.tech/docs/en/reference/ydb-cli/yql.md?version=v25.4) and [ydb scripting yql](https://ydb.tech/docs/en/reference/ydb-cli/scripting-yql.md?version=v25.4) commands in the [Apache Parquet](https://parquet.apache.org/docs/) format.
* In the [ydb workload](https://ydb.tech/docs/en/reference/ydb-cli/commands/workload/index.md?version=v25.4) commands, the `--executer` option has been added, which allows to specify which type of queries to use.
* Added a column with median benchmark execution time in the statistics table of the [ydb workload clickbench](https://ydb.tech/docs/en/reference/ydb-cli/workload-click-bench.md?version=v25.4) command.
* **_(Experimental)_** Added the `generic` request type to the [ydb table query execute](https://ydb.tech/docs/en/reference/ydb-cli/table-query-execute.md?version=v25.4) command, which allows performing [DDL](https://en.wikipedia.org/wiki/Data_Definition_Language) and [DML](https://en.wikipedia.org/wiki/Data_Manipulation_Language) operations, returning arbitrarily-sized results, and supporting [MVCC](https://ydb.tech/docs/en/concepts/query_execution/mvcc.md?version=v25.4). The command uses an experimental API, compatibility is not guaranteed.
* **_(Experimental)_** In the `ydb table query explain` command, the `--collect-diagnostics` option has been added to collect query diagnostics and save it to a file. The command uses an experimental API, compatibility is not guaranteed.

### Bug fixes

* Fixed an error displaying tables in `pretty` format with [Unicode](https://en.wikipedia.org/wiki/Unicode) characters.

* Fixed an error substituting the wrong primary key in the command [ydb tools pg-convert](https://ydb.tech/docs/en/postgresql/import.md?version=v25.4#pg-convert).

## Version 2.7.0 {#2-7-0}

Released on October 23, 2023. To update to version **2.7.0**, select the [Downloads](https://ydb.tech/docs/en/downloads/ydb-cli.md?version=v25.4) section.

### Features

* Added the [ydb tools pg-convert](https://ydb.tech/docs/en/postgresql/import.md?version=v25.4#pg-convert) command, which prepares a dump obtained by the [pg_dump](https://www.postgresql.org/docs/current/app-pgdump.html) utility for loading into the YDB postgres-compatible layer.
* Added the `ydb workload query` load testing command, which loads the database with [script execution queries](https://ydb.tech/docs/en/reference/ydb-cli/yql.md?version=v25.4) in multiple threads.
* Added new `ydb scheme permissions list` command to list permissions.
* In the commands [ydb table query execute](https://ydb.tech/docs/en/reference/ydb-cli/table-query-execute.md?version=v25.4), [ydb table query explain](https://ydb.tech/docs/en/reference/ydb-cli/commands/explain-plan.md?version=v25.4), [ydb yql](https://ydb.tech/docs/en/reference/ydb-cli/yql.md?version=v25.4), and [ydb scripting yql](https://ydb.tech/docs/en/reference/ydb-cli/scripting-yql.md?version=v25.4), the `--flame-graph` option has been added, specifying the path to the file in which you need to save the visualization of query execution statistics.
* [Special commands](https://ydb.tech/docs/en/reference/ydb-cli/interactive-cli.md?version=v25.4#spec-commands) in the interactive query execution mode are now case-insensitive.
* Added validation for [special commands](https://ydb.tech/docs/en/reference/ydb-cli/interactive-cli.md?version=v25.4#spec-commands) and their [parameters](https://ydb.tech/docs/en/reference/ydb-cli/interactive-cli.md?version=v25.4#internal-vars).
* Added table reading in the scenario with transactions in the command [ydb workload transfer topic-to-table run](https://ydb.tech/docs/en/reference/ydb-cli/workload-transfer.md?version=v25.4#run).
* Added the `--commit-messages` option to the command [ydb workload transfer topic-to-table run](https://ydb.tech/docs/en/reference/ydb-cli/workload-transfer.md?version=v25.4#run), specifying the number of messages in a single transaction.
* Added the options `--only-table-in-tx` and `--only-topic-in-tx` in the command [ydb workload transfer topic-to-table run](https://ydb.tech/docs/en/reference/ydb-cli/workload-transfer.md?version=v25.4#run), specifying restrictions on the types of queries in a single transaction.
* Added new columns `Select time` and `Upsert time` in the statistics table in the command [ydb workload transfer topic-to-table run](https://ydb.tech/docs/en/reference/ydb-cli/workload-transfer.md?version=v25.4#run).

### Bug fixes

* Fixed an error when loading an empty JSON list by commands: [ydb table query execute](https://ydb.tech/docs/en/reference/ydb-cli/table-query-execute.md?version=v25.4), [ydb scripting yql](https://ydb.tech/docs/en/reference/ydb-cli/scripting-yql.md?version=v25.4) and [ydb yql](https://ydb.tech/docs/en/reference/ydb-cli/yql.md?version=v25.4).

## Version 2.6.0 {#2-6-0}

Released on September 7, 2023. To update to version **2.6.0**, select the [Downloads](https://ydb.tech/docs/en/downloads/ydb-cli.md?version=v25.4) section.

### Features

* Added `--path` option to [ydb workload tpch run](https://ydb.tech/docs/en/reference/ydb-cli/workload-tpch.md?version=v25.4#run), which contains the path to the directory with tables created by the [ydb workload tpch init](https://ydb.tech/docs/en/reference/ydb-cli/workload-tpch.md?version=v25.4#init) command.
* Added [ydb workload transfer topic-to-table run](https://ydb.tech/docs/en/reference/ydb-cli/workload-transfer.md?version=v25.4) command, which loads the database with read requests from topics and write requests to the table.
* Added the option `--consumer-prefix` in the commands [ydb workload topic init](https://ydb.tech/docs/en/reference/ydb-cli/workload-topic.md?version=v25.4#init), [ydb workload topic run read|full](https://ydb.tech/docs/en/reference/ydb-cli/workload-topic.md?version=v25.4#run-read), specifying prefixes of consumer names.
* Added the `--partition-ids` option in the [ydb topic read](https://ydb.tech/docs/en/reference/ydb-cli/topic-read.md?version=v25.4) command, which specifies a comma-separated list of topic partition identifiers to read from.
* Added support for CSV and TSV parameter formats in [YQL query](https://ydb.tech/docs/en/reference/ydb-cli/parameterized-queries-cli.md?version=v25.4) execution commands.
* The [interactive mode of query execution](https://ydb.tech/docs/en/reference/ydb-cli/interactive-cli.md?version=v25.4) has been redesigned. Added [new interactive mode specific commands](https://ydb.tech/docs/en/reference/ydb-cli/interactive-cli.md?version=v25.4#spec-commands): `SET`, `EXPLAIN`, `EXPLAIN AST`. Added saving history between CLI launches and auto-completion of YQL queries.
* Added the command [ydb config info](https://ydb.tech/docs/en/reference/ydb-cli/commands/config-info.md?version=v25.4), which outputs the current connection parameters without connecting to the database.
* Added the command [ydb workload kv run mixed](https://ydb.tech/docs/en/reference/ydb-cli/workload-kv.md?version=v25.4#mixed-kv), which loads the database with write and read requests.
* The `--percentile` option in the [ydb workload topic run write|read|full](https://ydb.tech/docs/en/reference/ydb-cli/workload-topic.md?version=v25.4#run-write) commands can now take floating point values.
* The default values for the `--seconds` and `--warmup` options in the [ydb workload topic run write|read|full](https://ydb.tech/docs/en/reference/ydb-cli/workload-topic.md?version=v25.4#run-write) commands have been increased to 60 seconds and 5 seconds, respectively.
* Changed the default value for the `--supported-codecs` option to `RAW` in the [ydb topic create](https://ydb.tech/docs/en/reference/ydb-cli/topic-create.md?version=v25.4) and [ydb topic consumer add](https://ydb.tech/docs/en/reference/ydb-cli/topic-consumer-add.md?version=v25.4) commands.

### Bug fixes

* Fixed string loss when loading with the [ydb import file json](https://ydb.tech/docs/en/reference/ydb-cli/export-import/import-file.md?version=v25.4) command.
* Fixed ignored statistics during the warm-up of commands [ydb workload topic run write|read|full](https://ydb.tech/docs/en/reference/ydb-cli/workload-topic.md?version=v25.4#run-write).
* Fixed incomplete statistics output in the [ydb scripting yql](https://ydb.tech/docs/en/reference/ydb-cli/scripting-yql.md?version=v25.4) and [ydb yql](https://ydb.tech/docs/en/reference/ydb-cli/yql.md?version=v25.4) commands.
* Fixed incorrect output of progress bar in [ydb tools dump](https://ydb.tech/docs/en/reference/ydb-cli/export-import/tools-dump.md?version=v25.4) and [ydb tools restore](https://ydb.tech/docs/en/reference/ydb-cli/export-import/tools-restore.md?version=v25.4) commands.
* Fixed loading large files with the header in the [ydb import file csv|tsv](https://ydb.tech/docs/en/reference/ydb-cli/export-import/import-file.md?version=v25.4) command.
* Fixed hanging of the [ydb tools restore --import-data](https://ydb.tech/docs/en/reference/ydb-cli/export-import/tools-restore.md?version=v25.4#optional) command.
* Fixed error `Unknown value Rejected` when executing the [ydb operation list build index](https://ydb.tech/docs/en/reference/ydb-cli/operation-list.md?version=v25.4) command.

## Version 2.5.0 {#2-5-0}

Released on June 20, 2023. To update to version **2.5.0**, select the [Downloads](https://ydb.tech/docs/en/downloads/ydb-cli.md?version=v25.4) section.

### Features

* For the `ydb import file` command, a parameter [--timeout](https://ydb.tech/docs/en/reference/ydb-cli/export-import/import-file.md?version=v25.4#optional) has been added that specifies the time within which the operation should be performed on the server.
* Added a progress bar in commands [ydb scheme rmdir --recursive](https://ydb.tech/docs/en/reference/ydb-cli/commands/dir.md?version=v25.4#rmdir) and [ydb import file](https://ydb.tech/docs/en/reference/ydb-cli/export-import/import-file.md?version=v25.4).
* Added the command [ydb workload kv run read-rows](https://ydb.tech/docs/en/reference/ydb-cli/workload-kv.md?version=v25.4#read-rows-kv), which loads the database with requests to read rows using a new experimental API call ReadRows (implemented only in the [main](https://github.com/ydb-platform/ydb) branch), which performs faster key reading than [select](https://ydb.tech/docs/en/reference/ydb-cli/workload-kv.md?version=v25.4#select-kv).
* New parameters `--warmup-time`, `--percentile`, `--topic` have been added to the [ydb workload topic](https://ydb.tech/docs/en/reference/ydb-cli/workload-topic.md?version=v25.4), setting the test warm-up time, the percentile in the statistics output and the topic name, respectively.
* Added the [ydb workload tpch](https://ydb.tech/docs/en/reference/ydb-cli/workload-tpch.md?version=v25.4) command to run the TPC-H benchmark.
* Added the `--ordered` flag in the command [ydb tools dump](https://ydb.tech/docs/en/reference/ydb-cli/export-import/tools-dump.md?version=v25.4), which preserves the order by primary key in tables.

### Performance

* The data loading speed in the `ydb import file` command has been increased by adding parallel loading. The number of threads is set by the new parameter [--threads](https://ydb.tech/docs/en/reference/ydb-cli/export-import/import-file.md?version=v25.4#optional).
* A performance of the [ydb import file json](https://ydb.tech/docs/en/reference/ydb-cli/export-import/import-file.md?version=v25.4) command has been increased by reducing the number of data copies.

## Version 2.4.0 {#2-4-0}

Released on May 24, 2023. To update to version **2.4.0**, select the [Downloads](https://ydb.tech/docs/en/downloads/ydb-cli.md?version=v25.4) section.

### Features

* Added the ability to upload multiple files in parallel with the command [ydb import file](https://ydb.tech/docs/en/reference/ydb-cli/export-import/import-file.md?version=v25.4#multiple-files).
* Added support for deleting column tables for the command [ydb scheme rmdir --recursive](https://ydb.tech/docs/en/reference/ydb-cli/commands/dir.md?version=v25.4#rmdir).
* Improved stability of the command [ydb workload topic](https://ydb.tech/docs/en/reference/ydb-cli/workload-topic.md?version=v25.4).

## Version 2.3.0 {#2-3-0}

Release date: May 1, 2023. To update to version **2.3.0**, select the [Downloads](https://ydb.tech/docs/en/downloads/ydb-cli.md?version=v25.4) section.

### Features

* Added the interactive mode of query execution. To switch to the interactive mode, run [ydb yql](https://ydb.tech/docs/en/reference/ydb-cli/yql.md?version=v25.4) without arguments. This mode is experimental: backward compatibility is not guaranteed yet.
* Added the [ydb index rename](https://ydb.tech/docs/en/reference/ydb-cli/commands/secondary_index.md?version=v25.4#rename) command for [atomic replacement](https://ydb.tech/docs/en/dev/secondary-indexes.md?version=v25.4#atomic-index-replacement) or renaming of a secondary index.
* Added the `ydb workload topic` command for generating the load that reads messages from topics and writes messages to topics.
* Added the [--recursive](https://ydb.tech/docs/en/reference/ydb-cli/commands/dir.md?version=v25.4#rmdir-options) option for the `ydb scheme rmdir` command. Use it to delete a directory recursively, with all its content.
* Added support for the `topic` and `coordination node` types in the [ydb scheme describe](https://ydb.tech/docs/en/reference/ydb-cli/commands/scheme-describe.md?version=v25.4) command.
* Added the [--commit](https://ydb.tech/docs/en/reference/ydb-cli/topic-read.md?version=v25.4#osnovnye-opcionalnye-parametry) option for the `ydb topic consumer` command. Use it to commit messages you have read.
* Added the [--columns](https://ydb.tech/docs/en/reference/ydb-cli/export-import/import-file.md?version=v25.4#optional) option for the `ydb import file csv|tsv` command. Use it as an alternative to the file header when specifying a column list.
* Added the [--newline-delimited](https://ydb.tech/docs/en/reference/ydb-cli/export-import/import-file.md?version=v25.4#optional) option for the `ydb import file csv|tsv` command. Use it to make sure that your data is newline-free. This option streamlines import by reading data from several file sections in parallel.

### Bug fixes

* Fixed the bug that resulted in excessive memory and CPU utilization when executing the `ydb import file` command.

## Version 2.2.0 {#2-2-0}

Release date: March 3, 2023. To update to version **2.2.0**, select the [Downloads](https://ydb.tech/docs/en/downloads/ydb-cli.md?version=v25.4) section.

### Features

* Fixed the error that didn't allow specifying supported compression algorithms when adding a topic consumer.
* Added support for streaming YQL scripts and queries based on options [transferred via `stdin`](https://ydb.tech/docs/en/reference/ydb-cli/parameterized-queries-cli.md?version=v25.4).
* You can now [use a file](https://ydb.tech/docs/en/reference/ydb-cli/parameterized-queries-cli.md?version=v25.4) to provide YQL query options
* Password input requests are now output to `stderr` instead of `stdout`.
* You can now save the root CA certificate path in a [profile](https://ydb.tech/docs/en/reference/ydb-cli/profile/index.md?version=v25.4).
* Added a global option named [--profile-file](https://ydb.tech/docs/en/reference/ydb-cli/commands/global-options.md?version=v25.4#service-options) to use the specified file as storage for profile settings.
* Added a new type of load testing: [ydb workload clickbench](https://ydb.tech/docs/en/reference/ydb-cli/workload-click-bench.md?version=v25.4).

## Version 2.1.1 {#2-1-1}

Release date: December 30, 2022. To update to version **2.1.1**, select the [Downloads](https://ydb.tech/docs/en/downloads/ydb-cli.md?version=v25.4) section.

### Improvements

* Added support for the `--stats` option of the [ydb scheme describe](https://ydb.tech/docs/en/reference/ydb-cli/commands/scheme-describe.md?version=v25.4) command for column-oriented tables.
* Added support for Parquet files to enable their import with the [ydb import](https://ydb.tech/docs/en/reference/ydb-cli/export-import/import-file.md?version=v25.4) command.
* Added support for additional logging and retries for the [ydb import](https://ydb.tech/docs/en/reference/ydb-cli/export-import/import-file.md?version=v25.4) command.

## Version 2.1.0 {#2-1-0}

Release date: November 18, 2022. To update to version **2.1.0**, select the [Downloads](https://ydb.tech/docs/en/downloads/ydb-cli.md?version=v25.4) section.

### Features

* You can now [create a profile non-interactively](https://ydb.tech/docs/en/reference/ydb-cli/profile/create.md?version=v25.4#cmdline).
* Added the [ydb config profile update](https://ydb.tech/docs/en/reference/ydb-cli/profile/create.md?version=v25.4#update) and [ydb config profile replace](https://ydb.tech/docs/en/reference/ydb-cli/profile/create.md?version=v25.4#replace) commands to update and replace profiles, respectively.
* Added the `-1` option for the [ydb scheme ls](https://ydb.tech/docs/en/reference/ydb-cli/commands/scheme-ls.md?version=v25.4) command to enable output of a single object per row.
* You can now save the IAM service URL in a profile.
* Added support for username and password-based authentication without specifying the password.
* Added support for AWS profiles in the [ydb export s3](https://ydb.tech/docs/en/reference/ydb-cli/export-import/auth-s3.md?version=v25.4#auth) command.
* You can now create profiles using `stdin`. For example, you can pass the [YC CLI](https://yandex.cloud/docs/cli/) `yc ydb database get information` command output to the `ydb config profile create` command input.

### Bug fixes

* Fixed the error when request results were output in JSON-array format incorrectly if they included multiple server responses.
* Fixed the error that disabled profile updates so that an incorrect profile was used.

## Version 2.0.0 {#2-0-0}

Release date: September 20, 2022. To update to version **2.0.0**, select the [Downloads](https://ydb.tech/docs/en/downloads/ydb-cli.md?version=v25.4) section.

### Features

* Added the ability to work with topics:

  * `ydb topic create`: Create a topic.
  * `ydb topic alter`: Update a topic.
  * `ydb topic write`: Write data to a topic.
  * `ydb topic read`: Read data from a topic.
  * `ydb topic drop`: Delete a topic.

* Added a new type of load testing:

  * `ydb workload kv init`: Create a table for kv load testing.
  * `ydb workload kv run`: Apply one of three types of load: run multiple `UPSERT` sessions, run multiple `INSERT` sessions, or run multiple sessions of GET requests by primary key.
  * `ydb workload kv clean`: Delete a test table.

* Added the ability to disable current active profile (see the `ydb config profile deactivate` command).
* Added the ability to delete a profile non-interactively with no commit (see the `--force` option under the `ydb config profile remove` command).
* Added CDC support for the `ydb scheme describe` command.
* Added the ability to view the current DB status (see the `ydb monitoring healthcheck` command).
* Added the ability to view authentication information (token) to be sent with DB queries under the current authentication settings (see the `ydb auth get-token` command).
* Added the ability for the `ydb import` command to read data from stdin.
* Added the ability to import data in JSON format from a file or stdin (see the `ydb import file json` command).

### Improvements

* Improved command processing. Improved the accuracy of user input parsing and validation.

## Version 1.9.1 {#1-9-1}

Release date: June 25, 2022. To update to version **1.9.1**, select the [Downloads](https://ydb.tech/docs/en/downloads/ydb-cli.md?version=v25.4) section.

### Features

* Added the ability to compress data when exporting it to S3-compatible storage (see the `--compression` option of the [ydb export s3](https://ydb.tech/docs/en/reference/ydb-cli/export-import/export-s3.md?version=v25.4) command).
* Added the ability to manage new YDB CLI version availability auto checks (see the `--disable-checks` and `--enable-checks` options of the [ydb version](https://ydb.tech/docs/en/reference/ydb-cli/version.md?version=v25.4) command).