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