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