How to change Quota allocated to a Schema in Redshift database

Check the current quota and disk usage of the schema by running the below query where schemaname is the name of the schema.

select schema_name, quota, disk_usage from svv_schema_quota_state where schema_name='schemaname';

Above query does not return any output if the quota is set to ‘UNLIMITED’ .

You can set quota for a schema by running the below command:

ALTER SCHEMA schema_name QUOTA amount unit;

Examples:

ALTER SCHEMA maps QUOTA 500 MB;   
ALTER SCHEMA maps QUOTA 500 GB;   
ALTER SCHEMA maps QUOTA UNLIMITED;
See also  How to view all active sessions in Redshift database

Leave a Reply

Your email address will not be published. Required fields are marked *