System view mapping for migrating to SYS monitoring views - Amazon Redshift

System view mapping for migrating to SYS monitoring views

When you migrate your Amazon Redshift provisioned cluster to Amazon Redshift Serverless, your monitoring or diagnostic queries might reference system views that are only available on provisioned clusters. You can update your queries to use the SYS monitoring views. This page provides provisioned-only to SYS view mappings for you to reference when updating your queries.

SYS_QUERY_HISTORY

Some or all of the columns in the following tables are also defined in SYS_QUERY_HISTORY.

SYS_QUERY_DETAIL

Some or all of the columns in the following tables are also defined in SYS_QUERY_DETAIL.

SYS_RESTORE_LOG

Some or all of the columns in the following table are also defined in SYS_RESTORE_LOG.

SYS_RESTORE_STATE

Some or all of the columns in the following table are also defined in SYS_RESTORE_STATE.

SYS_TRANSACTION_HISTORY

Some or all of the columns in the following tables are also defined in SYS_TRANSACTION_HISTORY.

SYS_QUERY_TEXT

Some or all of the columns in the following table are also defined in SYS_QUERY_TEXT.

SYS_CONNECTION_LOG

Some or all of the columns in the following table are also defined in SYS_CONNECTION_LOG.

SYS_SESSION_HISTORY

Some or all of the columns in the following tables are also defined in SYS_SESSION_HISTORY.

SYS_LOAD_DETAIL

Some or all of the columns in the following table are also defined in SYS_LOAD_DETAIL.

SYS_LOAD_HISTORY

Some or all of the columns in the following table are also defined in SYS_LOAD_HISTORY.

SYS_LOAD_ERROR_DETAIL

Some or all of the columns in the following tables are also defined in SYS_LOAD_ERROR_DETAIL.

SYS_UNLOAD_HISTORY

Some or all of the columns in the following table are also defined in SYS_UNLOAD_HISTORY.

SYS_UNLOAD_DETAIL

Some or all of the columns in the following table are also defined in SYS_UNLOAD_DETAIL.

SYS_COPY_REPLACEMENTS

Some or all of the columns in the following table are also defined in SYS_COPY_REPLACEMENTS.

SYS_DATASHARE_USAGE_CONSUMER

Some or all of the columns in the following table are also defined in SYS_DATASHARE_USAGE_CONSUMER.

SYS_DATASHARE_USAGE_PRODUCER

Some or all of the columns in the following table are also defined in SYS_DATASHARE_USAGE_PRODUCER.

SYS_DATASHARE_CROSS_REGION_USAGE

Some or all of the columns in the following table are also defined in SYS_DATASHARE_CROSS_REGION_USAGE.

SYS_DATASHARE_CHANGE_LOG

Some or all of the columns in the following table are also defined in SYS_DATASHARE_CHANGE_LOG.

SYS_EXTERNAL_QUERY_DETAIL

Some or all of the columns in the following tables are also defined in SYS_EXTERNAL_QUERY_DETAIL.

SYS_EXTERNAL_QUERY_ERROR

Some or all of the columns in the following tables are also defined in SYS_EXTERNAL_QUERY_ERROR.

SYS_VACUUM_HISTORY

Some or all of the columns in the following tables are also defined in SYS_VACUUM_HISTORY.

SYS_ANALYZE_HISTORY

Some or all of the columns in the following tables are also defined in SYS_ANALYZE_HISTORY.

SYS_ANALYZE_COMPRESSION_HISTORY

Some or all of the columns in the following tables are also defined in SYS_ANALYZE_COMPRESSION_HISTORY.

SYS_MV_REFRESH_HISTORY

Some or all of the columns in the following tables are also defined in SYS_MV_REFRESH_HISTORY.

SYS_MV_STATE

Some or all of the columns in the following tables are also defined in SYS_MV_STATE.

SYS_PROCEDURE_CALL

Some or all of the columns in the following tables are also defined in SYS_PROCEDURE_CALL.

SYS_PROCEDURE_MESSAGES

Some or all of the columns in the following tables are also defined in SYS_PROCEDURE_MESSAGES.

SYS_UDF_LOG

Some or all of the columns in the following tables are also defined in SYS_UDF_LOG.

SYS_USERLOG

Some or all of the columns in the following tables are also defined in SYS_USERLOG.

SYS_SCHEMA_QUOTA_VIOLATIONS

Some or all of the columns in the following tables are also defined in SYS_SCHEMA_QUOTA_VIOLATIONS.

SYS_SPATIAL_SIMPLIFY

Some or all of the columns in the following tables are also defined in SYS_SPATIAL_SIMPLIFY.