Automatically set max query size in Clickhouse

[alisman]

No description provided.

[dippindots]

we need to assign specific user settings when a user gets created. https://clickhouse.com/docs/en/sql-reference/statements/create/settings-profile#example.

currently we have these settings on the clickhouse cloud, I set it manually last week:

max_query_size = 100000000,
max_ast_elements = 6000000,
max_expanded_ast_elements = 6000000

we need to run this command later whenever a new user (USER_NAME) get created:

CREATE
SETTINGS PROFILE client_user_profile SETTINGS max_query_size = 100000000,max_ast_elements = 6000000,max_expanded_ast_elements = 6000000
TO USER_NAME