v.23.12Improvement

Add Command Line Query Parameter Support in ClickHouse Local

Official CH changelog text
Add support for specifying query parameters in the command line in clickhouse-local #58210 (Pradeep Chhetri).
clickhouse-local now supports specifying query parameters directly via the command line.

Why it matters

This feature allows users to pass query parameters to clickhouse-local when executing SQL queries, improving flexibility and enabling parameterized queries without modifying query texts. It simplifies running ad-hoc or parameterized queries locally.

How to use it

Use the new command line options in clickhouse-local to specify query parameters when running queries. Parameters can be passed directly, enabling substitution in SQL statements with standard parameter syntax.

Related resources

PreviousNext