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
| 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