Use SVV_ REDSHIFT_DATABASES to view a list of all the databases that a user has access to. This includes the databases on the cluster and the databases created from datashares provided by remote clusters.
SVV_REDSHIFT_DATABASES 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. |
| database_owner | integer | The database owner user ID. |
| database_type | varchar(32) | The type of database. Possible types are local or shared databases. |
| database_acl | varchar(128) | This information is for internal use only. |
| database_options | varchar(128) | The properties of the database. |
| database_isolation_level | varchar(128) | The isolation level of the database. Possible values include: Snapshot Isolation and Serializable. |
Sample query
The following example returns the output for SVV_REDSHIFT_DATABASES.
select database_name, database_owner, database_type, database_options, database_isolation_level
from svv_redshift_databases;
database_name | database_owner | database_type | database_options | database_isolation_level
--------------+----------------+---------------+------------------+------------------
dev | 1 | local | NULL | Serializable
