CLI Auto Completion

Static Suggestion

Parser Keywords

  • Bytehouse-cli uses a parser to accurately suggest keywords

    • Use Tab or Arrow keys to select and auto-complete your intentions.

    • Pressing Enter will execute the query directly, press the spacebar instead to finish the remaining parts of the SQL Command

Clickhouse Built-In Function

  • As there is a lot of built-in function in gateway, completion will only be triggered after input of 2 or more characters after the last space

  • Also Displays the function signature

Data Type

Table Engine

Format

Setting

  • Attempts to resolve all settings from the server from the start

Dynamic Suggestion

Dynamic Suggestion Invocation requires querying in the background by the bytehouse-cli. To turn off dynamic suggestions, you can add the flag --disable_background or -db

Warehouse

Database

Table


Did this page help you?