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.

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