Setting for ClickHouse

Answered

Hello.

Please tell, how to set clickhouse settings using datagrip? 

For example,   `allow_experimental_data_skipping_indices` or restrictions on query complexity.

2 comments

@Dariagafurova0803

You can invoke `Startup script` before connection (the feature is available in DataGrip 2019.1 EAP):

and according to ClickHouse documentation you need to run

SET allow_experimental_data_skipping_indices = 1

Also, there are some advanced properties one can set for jdbc driver

https://clickhouse.yandex/docs/en/operations/table_engines/mergetree/

0

If you will set the session_id an Advanced tab, the setting can be set then.

0

Please sign in to leave a comment.