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