ALTER SYSTEM RESET

ALTER SYSTEM RESET restores the value of a system variable to its default value. This command is an alternative spelling for ALTER SYSTEM SET...TO DEFAULT.

To see the current value of a system variable, use SHOW.

Syntax

RESET variable_name
Field Use
variable_name The system variable name.

System variables

Materialize reserves system variables for region-wide configuration. Although it’s possible to SHOW system variables, you must contact us to set the value of most variables (e.g. increasing the maximum number of AWS PrivateLink connections in your region). Some system variables can be modified by any superuser (i.e. Frontegg admin).

Name Default value Description Settable by superuser
allowed_cluster_replica_sizes 3xsmall, 2xsmall, xsmall, small, medium, large, xlarge The allowed sizes when creating a new cluster replica. No
enable_rbac_checks true Boolean flag indicating whether to apply RBAC checks before executing statements. Yes
max_aws_privatelink_connections 0 The maximum number of AWS PrivateLink connections in the region, across all schemas. No
max_clusters 10 The maximum number of clusters in the region No
max_connections 1000 The maximum number of concurrent connections in the region No
max_credit_consumption_rate 1024 The maximum rate of credit consumption in a region. Credits are consumed based on the size of cluster replicas in use. No
max_databases 1000 The maximum number of databases in the region. No
max_kafka_connections 1000 The maximum number of Kafka connections in the region, across all schemas. No
max_objects_per_schema 1000 The maximum number of objects in a schema. No
max_postgres_connections 1000 The maximum number of PostgreSQL connections in the region, across all schemas. No
max_replicas_per_cluster 5 The maximum number of replicas of a single cluster No
max_result_size 1 GiB The maximum size in bytes for a single query’s result. No
max_roles 1000 The maximum number of roles in the region. No
max_schemas_per_database 1000 The maximum number of schemas in a database. No
max_secrets 100 The maximum number of secrets in the region, across all schemas. No
max_sources 25 The maximum number of sources in the region, across all schemas. No
max_sinks 25 The maximum number of sinks in the region, across all schemas. No
max_tables 25 The maximum number of tables in the region, across all schemas No

Examples

Reset enable RBAC

SHOW enable_rbac_checks;

 enable_rbac_checks
-------------
 on

RESET enable_rbac_checks;

SHOW enable_rbac_checks;

 enable_rbac_checks
-------------
 off
Back to top ↑