YDB CLI 2.7.0

Released on October 23, 2023. To update to version 2.7.0, select the Downloads section.

Features:

• Added the ydb tools pg-convert command, which prepares a dump obtained by the pg_dump 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 in multiple threads.

• Added a command ydb scheme permissions list to list permissions.

• In the commands ydb table query execute, ydb table query explain, ydb yql, and ydb scripting yql, 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 in the interactive query execution mode are now case-insensitive.

• Added validation for special commands and their parameters.

• Added table reading in the scenario with transactions in the command ydb workload transfer topic-to-table run.

• Added the --commit-messages option to the command ydb workload transfer topic-to-table 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, 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.

Bug fixes:

• Fixed an error when loading an empty JSON list by commands: ydb table query execute, ydb scripting yql and ydb yql.

Full Changelog: CLI_2.6.0...CLI_2.7.0