SVV_REDSHIFT_SCHEMAS

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