SVV_REDSHIFT_SCHEMA_QUOTA - Amazon Redshift
Table columnsSample query
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

SVV_REDSHIFT_SCHEMA_QUOTA

Displays the quota and the current disk usage for each schema in a database.

SVV_REDSHIFT_SCHEMA_QUOTA is visible to all users. Superusers can see all rows; regular users can see only their own data. For more information, see Visibility of data in system tables and views.

This view is available when querying provisioned clusters or Redshift Serverless workgroups.

Table columns

Column name Data type Description
database_name character(128) The database that contains the schema.
schema_name character(128) The name of the schema.
schema_owner integer The internal user ID of the schema owner.
quota integer The amount of disk space (in MB) that the schema can use.
disk_usage integer The disk space (in MB) that is currently used by the schema.

Sample query

The following example displays the quota and the current disk usage for the schema named sales_schema.

SELECT TRIM(SCHEMA_NAME) "schema_name", QUOTA, disk_usage FROM svv_redshift_schema_quota
WHERE SCHEMA_NAME = 'sales_schema';
                

schema_name   | quota | disk_usage 
--------------+-------+------------
sales_schema  | 2048  | 30