Configuring Profiles

Setting up profiles for groups of ClickHouse® users

Profiles allow you to give a name to a group of user settings, then easily apply those settings to users of your ClickHouse® cluster.

Configuring a profile

Figure 1 - The Profiles view

Clicking the button takes you to the Profile Details dialog:

Defining a profile

Figure 2 - The Profile Details dialog

To edit the settings in the profile, click Edit Settings on the right-hand side of the list of profiles as shown in Figure 14 above. You’ll see a list of all the settings in this profile:

Defining a profile

Figure 3 - The Profile Settings list

Clicking the button takes you to the Profile Setting Details dialog:

Details of a profile setting

Figure 4 - The Profile Setting Details dialog

Clicking the down arrow displays a drop-down menu that lists all the settings. Selecting any setting in the list updates the dialog with a hint for that setting:

Details of a profile setting

Figure 5 - A different hint for a different setting

You can switch to another profile while in edit mode. Clicking the PROFILE button displays a dropdown list of all your profiles:

Selecting a profile to edit

Figure 6 - Selecting a profile to edit

In the Profile list, clicking the vertical dots icon lets you either Edit or Delete a profile. Clicking Edit on the vertical dots menu takes you back to the Profile Details dialog shown in Figure 15 above. As you would expect, the delete button takes you to the Delete Profile dialog:

Delete a profile

Figure 7 - The Delete Profile dialog