Setting for ClickHouse

Answered

Permanently deleted user

Created March 13, 2019 09:06

Hello.

Please tell, how to set clickhouse settings using datagrip?

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

2 comments

Created March 18, 2019 09:34

@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

Created March 19, 2019 15:22

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

Please sign in to leave a comment.