Skip to main content
Skip to main content
Edit this page

CREATE SETTINGS PROFILE

Creates settings profiles that can be assigned to a user or a role.

Syntax:

ON CLUSTER clause allows creating settings profiles on a cluster, see Distributed DDL.

Example

Create a user:

Create the max_memory_usage_profile settings profile with value and constraints for the max_memory_usage setting and assign it to user robin:

Try ClickHouse Cloud for FREE

Easy data ingestion, automatic scaling, built-in SQL console and lots more.

Try it for Free