Use SVV_REDSHIFT_SCHEMAS to view a list of all schemas that a user has access to. This set of schemas includes the schemas on the cluster and the schemas from datashares provided by remote clusters.

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

Table columns

Column name Data type Description
database_name varchar(128) The name of the database where a specified schema exists.
schema_name varchar(128) The namespace or schema name.
schema_owner integer The internal user ID of the schema owner.
schema_type varchar(16) The type of the schema. Possible values are shared and local schemas.
schema_acl varchar(128) The string that defines the permissions for the specified user or user group for the schema.
schema_option varchar(128) The options of the schema.

Sample query

The following example returns the output of SVV_REDSHIFT_SCHEMAS.

SELECT * FROM svv_redshift_schemas WHERE database_name = 'tickit_db' ORDER BY database_name, SCHEMA_NAME; database_name | schema_name | schema_owner | schema_type | schema_acl | schema_option --------------+--------------------+--------------+-------------+------------+--------------- tickit_db | public | 1 | shared | |