View a markdown version of this page

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

Amazon Redshift will no longer support the use of Python UDFs after June 30, 2026. We will start enforcing it in phases. For more information on the details of Python end of life and migration options, see the blog post that was published on June 30, 2025.

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 by default. To control access to your database's metadata, enable metadata security for your provisioned cluster or serverless workgroup. Metadata security lets you separate view permissions for object metadata by users and roles. For more information, see Metadata security.

For more information about best practices when querying system tables and views, see Querying System Tables.

Note

Use the SHOW DATABASES command for database discovery. SHOW DATABASES works consistently across local, datashare, and external catalog contexts and is updated as new features are released. For more information, see Best practices for discovering metadata.

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