SVV_REDSHIFT_DATABASES - Amazon Redshift
Table columnsSample query
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

SVV_REDSHIFT_DATABASES

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