Amazon Redshift will no longer support the creation of new Python UDFs starting Patch 198. Existing Python UDFs will continue to function until June 30, 2026. For more information, see the [ blog post ](https://aws.amazon.com/blogs/big-data/amazon-redshift-python-user-defined-functions-will-reach-end-of-support-after-june-30-2026/). 

# System view mapping for migrating to SYS monitoring views
<a name="sys_view_migration"></a>

 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.

**Topics**
+ [SYS\$1QUERY\$1HISTORY](#sys_view_migration-SYS_QUERY_HISTORY)
+ [SYS\$1QUERY\$1DETAIL](#sys_view_migration-SYS_QUERY_DETAIL)
+ [SYS\$1RESTORE\$1LOG](#sys_view_migration-SYS_RESTORE_LOG)
+ [SYS\$1RESTORE\$1STATE](#sys_view_migration-SYS_RESTORE_STATE)
+ [SYS\$1TRANSACTION\$1HISTORY](#sys_view_migration-SYS_TRANSACTION_HISTORY)
+ [SYS\$1QUERY\$1TEXT](#sys_view_migration-SYS_QUERY_TEXT)
+ [SYS\$1CONNECTION\$1LOG](#sys_view_migration-SYS_CONNECTION_LOG)
+ [SYS\$1SESSION\$1HISTORY](#sys_view_migration-SYS_SESSION_HISTORY)
+ [SYS\$1LOAD\$1DETAIL](#sys_view_migration-SYS_LOAD_DETAIL)
+ [SYS\$1LOAD\$1HISTORY](#sys_view_migration-SYS_LOAD_HISTORY)
+ [SYS\$1LOAD\$1ERROR\$1DETAIL](#sys_view_migration-SYS_LOAD_ERROR_DETAIL)
+ [SYS\$1UNLOAD\$1HISTORY](#sys_view_migration-SYS_UNLOAD_HISTORY)
+ [SYS\$1UNLOAD\$1DETAIL](#sys_view_migration-SYS_UNLOAD_DETAIL)
+ [SYS\$1COPY\$1REPLACEMENTS](#sys_view_migration-SYS_COPY_REPLACEMENTS)
+ [SYS\$1DATASHARE\$1USAGE\$1CONSUMER](#sys_view_migration-SYS_DATASHARE_USAGE_CONSUMER)
+ [SYS\$1DATASHARE\$1USAGE\$1PRODUCER](#sys_view_migration-SYS_DATASHARE_USAGE_PRODUCER)
+ [SYS\$1DATASHARE\$1CROSS\$1REGION\$1USAGE](#sys_view_migration-SYS_DATASHARE_CROSS_REGION_USAGE)
+ [SYS\$1DATASHARE\$1CHANGE\$1LOG](#sys_view_migration-SYS_DATASHARE_CHANGE_LOG)
+ [SYS\$1EXTERNAL\$1QUERY\$1DETAIL](#sys_view_migration-SYS_EXTERNAL_QUERY_DETAIL)
+ [SYS\$1EXTERNAL\$1QUERY\$1ERROR](#sys_view_migration-SYS_EXTERNAL_QUERY_ERROR)
+ [SYS\$1VACUUM\$1HISTORY](#sys_view_migration-SYS_VACUUM_HISTORY)
+ [SYS\$1ANALYZE\$1HISTORY](#sys_view_migration-SYS_ANALYZE_HISTORY)
+ [SYS\$1ANALYZE\$1COMPRESSION\$1HISTORY](#sys_view_migration-SYS_ANALYZE_COMPRESSION_HISTORY)
+ [SYS\$1MV\$1REFRESH\$1HISTORY](#sys_view_migration-SYS_MV_REFRESH_HISTORY)
+ [SYS\$1MV\$1STATE](#sys_view_migration-SYS_MV_STATE)
+ [SYS\$1PROCEDURE\$1CALL](#sys_view_migration-SYS_PROCEDURE_CALL)
+ [SYS\$1PROCEDURE\$1MESSAGES](#sys_view_migration-SYS_PROCEDURE_MESSAGES)
+ [SYS\$1UDF\$1LOG](#sys_view_migration-SYS_UDF_LOG)
+ [SYS\$1USERLOG](#sys_view_migration-SYS_USERLOG)
+ [SYS\$1SCHEMA\$1QUOTA\$1VIOLATIONS](#sys_view_migration-SYS_SCHEMA_QUOTA_VIOLATIONS)
+ [SYS\$1SPATIAL\$1SIMPLIFY](#sys_view_migration-SYS_SPATIAL_SIMPLIFY)

## SYS\$1QUERY\$1HISTORY
<a name="sys_view_migration-SYS_QUERY_HISTORY"></a>

Some or all of the columns in the following tables are also defined in [SYS\$1QUERY\$1HISTORY](SYS_QUERY_HISTORY.md).
+ [STL\$1DDLTEXT](r_STL_DDLTEXT.md)
+ [STL\$1ERROR](r_STL_ERROR.md)
+ [STL\$1QUERY](r_STL_QUERY.md)
+ [STL\$1UTILITYTEXT](r_STL_UTILITYTEXT.md)
+ [STL\$1WLM\$1QUERY](r_STL_WLM_QUERY.md)
+ [STV\$1INFLIGHT](r_STV_INFLIGHT.md)
+ [STV\$1RECENTS](r_STV_RECENTS.md)
+ [STV\$1WLM\$1QUERY\$1STATE](r_STV_WLM_QUERY_STATE.md)
+ [SVL\$1COMPILE](r_SVL_COMPILE.md)
+ [SVL\$1MULTI\$1STATEMENT\$1VIOLATIONS](r_SVL_MULTI_STATEMENT_VIOLATIONS.md)
+ [SVL\$1QLOG](r_SVL_QLOG.md)
+ [SVL\$1QUERY\$1QUEUE\$1INFO](r_SVL_QUERY_QUEUE_INFO.md)
+ [SVL\$1STATEMENTTEXT](r_SVL_STATEMENTTEXT.md)
+ [SVL\$1TERMINATE](r_SVL_TERMINATE.md)

## SYS\$1QUERY\$1DETAIL
<a name="sys_view_migration-SYS_QUERY_DETAIL"></a>

Some or all of the columns in the following tables are also defined in [SYS\$1QUERY\$1DETAIL](SYS_QUERY_DETAIL.md).
+ [STL\$1AGGR](r_STL_AGGR.md)
+ [STL\$1ALERT\$1EVENT\$1LOG](r_STL_ALERT_EVENT_LOG.md)
+ [STL\$1BCAST](r_STL_BCAST.md)
+ [STL\$1DELETE](r_STL_DELETE.md)
+ [STL\$1DIST](r_STL_DIST.md)
+ [STL\$1EXPLAIN](r_STL_EXPLAIN.md)
+ [STL\$1HASH](r_STL_HASH.md)
+ [STL\$1HASHJOIN](r_STL_HASHJOIN.md)
+ [STL\$1INSERT](r_STL_INSERT.md)
+ [STL\$1LIMIT](r_STL_LIMIT.md)
+ [STL\$1MERGE](r_STL_MERGE.md)
+ [STL\$1MERGEJOIN](r_STL_MERGEJOIN.md)
+ [STL\$1NESTLOOP](r_STL_NESTLOOP.md)
+ [STL\$1PARSE](r_STL_PARSE.md)
+ [STL\$1PLAN\$1INFO](r_STL_PLAN_INFO.md)
+ [STL\$1PROJECT](r_STL_PROJECT.md)
+ [STL\$1QUERY\$1METRICS](r_STL_QUERY_METRICS.md)
+ [STL\$1RETURN](r_STL_RETURN.md)
+ [STL\$1SAVE](r_STL_SAVE.md)
+ [STL\$1SCAN](r_STL_SCAN.md)
+ [STL\$1SORT](r_STL_SORT.md)
+ [STL\$1STREAM\$1SEGS](r_STL_STREAM_SEGS.md)
+ [STL\$1UNIQUE](r_STL_UNIQUE.md)
+ [STL\$1WINDOW](r_STL_WINDOW.md)
+ [STV\$1EXEC\$1STATE](r_STV_EXEC_STATE.md)
+ [STV\$1QUERY\$1METRICS](r_STV_QUERY_METRICS.md)
+ [SVCS\$1QUERY\$1SUMMARY](r_SVCS_QUERY_SUMMARY.md)
+ [SVL\$1QUERY\$1METRICS](r_SVL_QUERY_METRICS.md)
+ [SVL\$1QUERY\$1METRICS\$1SUMMARY](r_SVL_QUERY_METRICS_SUMMARY.md)
+ [SVL\$1QUERY\$1REPORT](r_SVL_QUERY_REPORT.md)
+ [SVL\$1QUERY\$1SUMMARY](r_SVL_QUERY_SUMMARY.md)
+ [SVV\$1QUERY\$1STATE](r_SVV_QUERY_STATE.md)

## SYS\$1RESTORE\$1LOG
<a name="sys_view_migration-SYS_RESTORE_LOG"></a>

Some or all of the columns in the following table are also defined in [SYS\$1RESTORE\$1LOG](SYS_RESTORE_LOG.md).
+ [SVL\$1RESTORE\$1ALTER\$1TABLE\$1PROGRESS](r_SVL_RESTORE_ALTER_TABLE_PROGRESS.md)

## SYS\$1RESTORE\$1STATE
<a name="sys_view_migration-SYS_RESTORE_STATE"></a>

Some or all of the columns in the following table are also defined in [SYS\$1RESTORE\$1STATE](SYS_RESTORE_STATE.md).
+ [STV\$1XRESTORE\$1ALTER\$1QUEUE\$1STATE](r_STV_XRESTORE_ALTER_QUEUE_STATE.md)

## SYS\$1TRANSACTION\$1HISTORY
<a name="sys_view_migration-SYS_TRANSACTION_HISTORY"></a>

Some or all of the columns in the following tables are also defined in [SYS\$1TRANSACTION\$1HISTORY](SYS_TRANSACTION_HISTORY.md).
+ [STL\$1COMMIT\$1STATS](r_STL_COMMIT_STATS.md)
+ [STL\$1TR\$1CONFLICT](r_STL_TR_CONFLICT.md)
+ [STL\$1UNDONE](r_STL_UNDONE.md)

## SYS\$1QUERY\$1TEXT
<a name="sys_view_migration-SYS_QUERY_TEXT"></a>

Some or all of the columns in the following table are also defined in [SYS\$1QUERY\$1TEXT](SYS_QUERY_TEXT.md).
+ [STL\$1QUERYTEXT](r_STL_QUERYTEXT.md)

## SYS\$1CONNECTION\$1LOG
<a name="sys_view_migration-SYS_CONNECTION_LOG"></a>

Some or all of the columns in the following table are also defined in [SYS\$1CONNECTION\$1LOG](SYS_CONNECTION_LOG.md).
+ [STL\$1CONNECTION\$1LOG](r_STL_CONNECTION_LOG.md)

## SYS\$1SESSION\$1HISTORY
<a name="sys_view_migration-SYS_SESSION_HISTORY"></a>

Some or all of the columns in the following tables are also defined in [SYS\$1SESSION\$1HISTORY](SYS_SESSION_HISTORY.md).
+ [STL\$1SESSIONS](r_STL_SESSIONS.md)
+ [STL\$1RESTARTED\$1SESSIONS](r_STL_RESTARTED_SESSIONS.md)
+ [STV\$1SESSIONS](r_STV_SESSIONS.md)

## SYS\$1LOAD\$1DETAIL
<a name="sys_view_migration-SYS_LOAD_DETAIL"></a>

Some or all of the columns in the following table are also defined in [SYS\$1LOAD\$1DETAIL](SYS_LOAD_DETAIL.md).
+ [STL\$1LOAD\$1COMMITS](r_STL_LOAD_COMMITS.md)

## SYS\$1LOAD\$1HISTORY
<a name="sys_view_migration-SYS_LOAD_HISTORY"></a>

Some or all of the columns in the following table are also defined in [SYS\$1LOAD\$1HISTORY](SYS_LOAD_HISTORY.md).
+ [STL\$1LOAD\$1COMMITS](r_STL_LOAD_COMMITS.md)

## SYS\$1LOAD\$1ERROR\$1DETAIL
<a name="sys_view_migration-SYS_LOAD_ERROR_DETAIL"></a>

Some or all of the columns in the following tables are also defined in [SYS\$1LOAD\$1ERROR\$1DETAIL](SYS_LOAD_ERROR_DETAIL.md).
+ [STL\$1LOADERROR\$1DETAIL](r_STL_LOADERROR_DETAIL.md)
+ [STL\$1LOAD\$1ERRORS](r_STL_LOAD_ERRORS.md)

## SYS\$1UNLOAD\$1HISTORY
<a name="sys_view_migration-SYS_UNLOAD_HISTORY"></a>

Some or all of the columns in the following table are also defined in [SYS\$1UNLOAD\$1HISTORY](SYS_UNLOAD_HISTORY.md).
+ [STL\$1UNLOAD\$1LOG](r_STL_UNLOAD_LOG.md)

## SYS\$1UNLOAD\$1DETAIL
<a name="sys_view_migration-SYS_UNLOAD_DETAIL"></a>

Some or all of the columns in the following table are also defined in [SYS\$1UNLOAD\$1DETAIL](SYS_UNLOAD_DETAIL.md).
+ [STL\$1UNLOAD\$1LOG](r_STL_UNLOAD_LOG.md)

## SYS\$1COPY\$1REPLACEMENTS
<a name="sys_view_migration-SYS_COPY_REPLACEMENTS"></a>

Some or all of the columns in the following table are also defined in [SYS\$1COPY\$1REPLACEMENTS](SYS_COPY_REPLACEMENTS.md).
+ [STL\$1REPLACEMENTS](r_STL_REPLACEMENTS.md)

## SYS\$1DATASHARE\$1USAGE\$1CONSUMER
<a name="sys_view_migration-SYS_DATASHARE_USAGE_CONSUMER"></a>

Some or all of the columns in the following table are also defined in [SYS\$1DATASHARE\$1USAGE\$1CONSUMER](SYS_DATASHARE_USAGE_CONSUMER.md).
+ [SVL\$1DATASHARE\$1USAGE\$1CONSUMER](r_SVL_DATASHARE_USAGE_CONSUMER.md)

## SYS\$1DATASHARE\$1USAGE\$1PRODUCER
<a name="sys_view_migration-SYS_DATASHARE_USAGE_PRODUCER"></a>

Some or all of the columns in the following table are also defined in [SYS\$1DATASHARE\$1USAGE\$1PRODUCER](SYS_DATASHARE_USAGE_PRODUCER.md).
+ [SVL\$1DATASHARE\$1USAGE\$1PRODUCER](r_SVL_DATASHARE_USAGE_PRODUCER.md)

## SYS\$1DATASHARE\$1CROSS\$1REGION\$1USAGE
<a name="sys_view_migration-SYS_DATASHARE_CROSS_REGION_USAGE"></a>

Some or all of the columns in the following table are also defined in [SYS\$1DATASHARE\$1CROSS\$1REGION\$1USAGE](r_SYS_DATASHARE_CROSS_REGION_USAGE.md).
+ [SVL\$1DATASHARE\$1CROSS\$1REGION\$1USAGE](r_SVL_DATASHARE_CROSS_REGION_USAGE.md)

## SYS\$1DATASHARE\$1CHANGE\$1LOG
<a name="sys_view_migration-SYS_DATASHARE_CHANGE_LOG"></a>

Some or all of the columns in the following table are also defined in [SYS\$1DATASHARE\$1CHANGE\$1LOG](SYS_DATASHARE_CHANGE_LOG.md).
+ [SVL\$1DATASHARE\$1CHANGE\$1LOG](r_SVL_DATASHARE_CHANGE_LOG.md)

## SYS\$1EXTERNAL\$1QUERY\$1DETAIL
<a name="sys_view_migration-SYS_EXTERNAL_QUERY_DETAIL"></a>

Some or all of the columns in the following tables are also defined in [SYS\$1EXTERNAL\$1QUERY\$1DETAIL](SYS_EXTERNAL_QUERY_DETAIL.md).
+ [SVL\$1FEDERATED\$1QUERY](r_SVL_FEDERATED_QUERY.md)
+ [SVL\$1S3LIST](r_SVL_S3LIST.md)
+ [SVL\$1S3QUERY](r_SVL_S3QUERY.md)
+ [SVL\$1S3QUERY\$1SUMMARY](r_SVL_S3QUERY_SUMMARY.md)

## SYS\$1EXTERNAL\$1QUERY\$1ERROR
<a name="sys_view_migration-SYS_EXTERNAL_QUERY_ERROR"></a>

Some or all of the columns in the following tables are also defined in [SYS\$1EXTERNAL\$1QUERY\$1ERROR](SYS_EXTERNAL_QUERY_ERROR.md).
+ [SVL\$1SPECTRUM\$1SCAN\$1ERROR](r_SVL_SPECTRUM_SCAN_ERROR.md)

## SYS\$1VACUUM\$1HISTORY
<a name="sys_view_migration-SYS_VACUUM_HISTORY"></a>

Some or all of the columns in the following tables are also defined in [SYS\$1VACUUM\$1HISTORY](SYS_VACUUM_HISTORY.md).
+ [STL\$1VACUUM](r_STL_VACUUM.md)
+ [SVL\$1VACUUM\$1PERCENTAGE](r_SVL_VACUUM_PERCENTAGE.md)
+ [SVV\$1VACUUM\$1PROGRESS](r_SVV_VACUUM_PROGRESS.md)
+ [SVV\$1VACUUM\$1SUMMARY](r_SVV_VACUUM_SUMMARY.md)

## SYS\$1ANALYZE\$1HISTORY
<a name="sys_view_migration-SYS_ANALYZE_HISTORY"></a>

Some or all of the columns in the following tables are also defined in [SYS\$1ANALYZE\$1HISTORY](SYS_ANALYZE_HISTORY.md).
+ [STL\$1ANALYZE](r_STL_ANALYZE.md)

## SYS\$1ANALYZE\$1COMPRESSION\$1HISTORY
<a name="sys_view_migration-SYS_ANALYZE_COMPRESSION_HISTORY"></a>

Some or all of the columns in the following tables are also defined in [SYS\$1ANALYZE\$1COMPRESSION\$1HISTORY](r_SYS_ANALYZE_COMPRESSION_HISTORY.md).
+ [STL\$1ANALYZE\$1COMPRESSION](r_STL_ANALYZE_COMPRESSION.md)

## SYS\$1MV\$1REFRESH\$1HISTORY
<a name="sys_view_migration-SYS_MV_REFRESH_HISTORY"></a>

Some or all of the columns in the following tables are also defined in [SYS\$1MV\$1REFRESH\$1HISTORY](SYS_MV_REFRESH_HISTORY.md).
+ [SVL\$1MV\$1REFRESH\$1STATUS](r_SVL_MV_REFRESH_STATUS.md)

## SYS\$1MV\$1STATE
<a name="sys_view_migration-SYS_MV_STATE"></a>

Some or all of the columns in the following tables are also defined in [SYS\$1MV\$1STATE](SYS_MV_STATE.md).
+ [STL\$1MV\$1STATE](r_STL_MV_STATE.md)

## SYS\$1PROCEDURE\$1CALL
<a name="sys_view_migration-SYS_PROCEDURE_CALL"></a>

Some or all of the columns in the following tables are also defined in [SYS\$1PROCEDURE\$1CALL](SYS_PROCEDURE_CALL.md).
+ [SVL\$1STORED\$1PROC\$1CALL](r_SVL_STORED_PROC_CALL.md)

## SYS\$1PROCEDURE\$1MESSAGES
<a name="sys_view_migration-SYS_PROCEDURE_MESSAGES"></a>

Some or all of the columns in the following tables are also defined in [SYS\$1PROCEDURE\$1MESSAGES](SYS_PROCEDURE_MESSAGES.md).
+ [SVL\$1STORED\$1PROC\$1MESSAGES](r_SVL_STORED_PROC_MESSAGES.md)

## SYS\$1UDF\$1LOG
<a name="sys_view_migration-SYS_UDF_LOG"></a>

Some or all of the columns in the following tables are also defined in [SYS\$1UDF\$1LOG](SYS_UDF_LOG.md).
+ [SVL\$1UDF\$1LOG](r_SVL_UDF_LOG.md)

## SYS\$1USERLOG
<a name="sys_view_migration-SYS_USERLOG"></a>

Some or all of the columns in the following tables are also defined in [SYS\$1USERLOG](SYS_USERLOG.md).
+ [STL\$1USERLOG](r_STL_USERLOG.md)

## SYS\$1SCHEMA\$1QUOTA\$1VIOLATIONS
<a name="sys_view_migration-SYS_SCHEMA_QUOTA_VIOLATIONS"></a>

Some or all of the columns in the following tables are also defined in [SYS\$1SCHEMA\$1QUOTA\$1VIOLATIONS](r_SYS_SCHEMA_QUOTA_VIOLATIONS.md).
+ [STL\$1SCHEMA\$1QUOTA\$1VIOLATIONS](r_STL_SCHEMA_QUOTA_VIOLATIONS.md)

## SYS\$1SPATIAL\$1SIMPLIFY
<a name="sys_view_migration-SYS_SPATIAL_SIMPLIFY"></a>

Some or all of the columns in the following tables are also defined in [SYS\$1SPATIAL\$1SIMPLIFY](SYS_SPATIAL_SIMPLIFY.md).
+ [SVL\$1SPATIAL\$1SIMPLIFY](r_SVL_SPATIAL_SIMPLIFY.md)