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
SVV_ROLES
Use SVV_ROLES to view role information.
This table is visible to all users.
Table columns
| Column name | Data type | Description |
|---|---|---|
| role_id | integer | The role ID. |
| role_name | text | The name of the role. |
| role_owner | text | The name of the role owner. |
| external_id | text | The unique identifier of the role in the third-party identity provider. |
Sample query
The following example returns the output of SVV_ROLES.
SELECT role_name,role_owner FROM svv_roles WHERE role_name IN ('role1', 'role2'); role_name | role_owner -----------+------------ role1 | superuser role2 | superuser
