Select your cookie preferences

We use essential cookies and similar tools that are necessary to provide our site and services. We use performance cookies to collect anonymous statistics, so we can understand how customers use our site and make improvements. Essential cookies cannot be deactivated, but you can choose “Customize” or “Decline” to decline performance cookies.

If you agree, AWS and approved third parties will also use cookies to provide useful site features, remember your preferences, and display relevant content, including relevant advertising. To accept or decline all non-essential cookies, choose “Accept” or “Decline.” To make more detailed choices, choose “Customize.”

Customize cookie preferences

We use cookies and similar tools (collectively, "cookies") for the following purposes.

Essential

Essential cookies are necessary to provide our site and services and cannot be deactivated. They are usually set in response to your actions on the site, such as setting your privacy preferences, signing in, or filling in forms.

Performance

Performance cookies provide anonymous statistics about how customers navigate our site so we can improve site experience and performance. Approved third parties may perform analytics on our behalf, but they cannot use the data for their own purposes.

Allow performance category

Allowed

Functional

Functional cookies help us provide useful site features, remember your preferences, and display relevant content. Approved third parties may set these cookies to provide certain site features. If you do not allow these cookies, then some or all of these services may not function properly.

Allow functional category

Allowed

Advertising

Advertising cookies may be set through our site by us or our advertising partners and help us deliver relevant marketing content. If you do not allow these cookies, you will experience less relevant advertising.

Allow advertising category

Allowed

Blocking some types of cookies may impact your experience of our sites. You may review and change your choices at any time by selecting Cookie preferences in the footer of this site. We and selected third-parties use cookies or similar technologies as specified in the AWS Cookie Notice.

Unable to save cookie preferences

We will only store essential cookies at this time, because we were unable to save your cookie preferences.

If you want to change your cookie preferences, try again later using the link in the AWS console footer, or contact support if the problem persists.

Developer tools

Create an AWS Account

Amazon Redshift

Database Developer Guide

Introduction
- Amazon Redshift architecture
  Data warehouse architecture
  Performance
  Columnar storage
  Workload management
  Using Amazon Redshift with other services
- Sample database
Best practices
Tutorials
Automatic table optimization
Loading data
Unloading data
User-defined functions
Creating stored procedures
- Stored procedure overview
  Naming stored procedures
  Security and privileges
  Returning a result set
  Managing transactions
  Trapping errors
  Logging stored procedures
  Limitations
- PL/pgSQL language reference
  PL/pgSQL reference conventions
  Structure of PL/pgSQL
  Supported PL/pgSQL statements
Materialized views
Data Catalog views
Querying spatial data
Querying data with federated queries
Amazon Redshift Spectrum
HyperLogLog sketches
Cross-database queries
Apache Iceberg compatibility
Data sharing
Semistructured data in Amazon Redshift
Machine learning
Query performance tuning
Workload management
Database security
SQL reference
System tables and views reference
Configuration reference
Document history

Amazon Redshift

Documentation
Amazon Redshift
Database Developer Guide

SVV metadata views

Focus mode

SVV metadata views - Amazon Redshift

Documentation Amazon Redshift Database Developer Guide

SVV views are system views in Amazon Redshift that contain information about database objects. Note that although they store information such as user permissions or table names, they're not meant for joining with user-created relations.

Note

Amazon Redshift reports a WARNING, not an ERROR, if a database response fails for any reason. Amazon Redshift doesn't send ERROR messages when you're querying objects in a datashare.

Topics

Warning Javascript is disabled or is unavailable in your browser.

To use the Amazon Web Services Documentation, Javascript must be enabled. Please refer to your browser's Help pages for instructions.

Document Conventions

System tables and views reference

SVV_ACTIVE_CURSORS

Did this page help you? - Yes

Thanks for letting us know we're doing a good job!

If you've got a moment, please tell us what we did right so we can do more of it.

Did this page help you? - No

Thanks for letting us know this page needs work. We're sorry we let you down.

If you've got a moment, please tell us how we can make the documentation better.

Next topic:

SVV_ACTIVE_CURSORS

Previous topic:

System tables and views reference

Need help?

Try AWS re:Post
Connect with an AWS IQ expert

Did this page help you?

Provide feedback

Privacy Site terms Cookie preferences

© 2025, Amazon Web Services, Inc. or its affiliates. All rights reserved.