AWS redshift documentation change
Summary
Updated terminology from 'Redshift Spectrum queries' to 'data lake queries' and added cluster-specific details for RG provisioned clusters. Deprecated several metrics columns for RG node type clusters (-1 values) and redirected users to STL_S3CLIENT for retry data.
Security assessment
The changes are documentation updates reflecting product terminology changes (Spectrum → data lake) and cluster-specific implementation details. No security vulnerabilities, exploits, or security controls are mentioned. Deprecation notices for RG clusters are operational guidance without security implications.
Diff
diff --git a/redshift/latest/dg/r_SVCS_S3QUERY_SUMMARY.md b/redshift/latest/dg/r_SVCS_S3QUERY_SUMMARY.md index 6091fb0c0..da9f78f53 100644 --- a//redshift/latest/dg/r_SVCS_S3QUERY_SUMMARY.md +++ b//redshift/latest/dg/r_SVCS_S3QUERY_SUMMARY.md @@ -13 +13 @@ Amazon Redshift will no longer support the creation of new Python UDFs starting -Use the SVCS_S3QUERY_SUMMARY view to get a summary of all Redshift Spectrum queries (S3 queries) that have been run on the system. One segment can perform one external table scan. +Use the SVCS_S3QUERY_SUMMARY view to get a summary of all data lake queries that have been run on the system. One segment can perform one external table scan. @@ -42,5 +42,5 @@ is_nested | varchar(1) | If true (`t`), this column value indicates that the nes -s3_scanned_rows | bigint | The number of rows scanned from Amazon S3 and sent to the Redshift Spectrum layer. -s3_scanned_bytes | bigint | The number of bytes scanned from Amazon S3 and sent to the Redshift Spectrum layer, based on compressed data. -s3query_returned_rows | bigint | The number of rows returned from the Redshift Spectrum layer to the cluster. -s3query_returned_bytes | bigint | The number of bytes returned from the Redshift Spectrum layer to the cluster. A large amount of data returned to Amazon Redshift might affect system performance. -files | integer | The number of files that were processed for this Redshift Spectrum query. A small number of files limits the benefits of parallel processing. +s3_scanned_rows | bigint | The number of rows scanned from Amazon S3 and sent to the Redshift Spectrum layer. On RG provisioned clusters, this is the total number of rows scanned directly from Amazon S3 by the cluster's native reader across all slices, before filter pushdown. +s3_scanned_bytes | bigint | The number of bytes scanned from Amazon S3 and sent to the Redshift Spectrum layer, based on compressed data. On RG provisioned clusters, this is the total number of bytes scanned directly from Amazon S3 by the cluster's native reader across all slices, before filter pushdown. +s3query_returned_rows | bigint | The number of rows returned from the Redshift Spectrum layer to the cluster. On RG provisioned clusters, this is the total number of rows returned by the cluster's native reader across all slices, after filter pushdown. +s3query_returned_bytes | bigint | The number of bytes returned from the Redshift Spectrum layer to the cluster. A large amount of data returned to Amazon Redshift might affect system performance. On RG provisioned clusters, this is the total number of bytes returned by the cluster's native reader across all slices, after filter pushdown. +files | integer | The number of files that were processed for this data lake query. A small number of files limits the benefits of parallel processing. @@ -55,8 +55,8 @@ avg_split_size | bigint | The average split size processed, in bytes. -total_retries | bigint | The total number of retries for the Redshift Spectrum query in this segment. -max_retries | integer | The maximum number of retries for one individual processed file. -max_request_duration | bigint | The maximum duration of an individual file request (in microseconds). Long running queries might indicate a bottleneck. -avg_request_duration | bigint | The average duration of the file requests (in microseconds). -max_request_parallelism | integer | The maximum number of parallel requests at one slice for this Redshift Spectrum query. -avg_request_parallelism | double precision | The average number of parallel requests at one slice for this Redshift Spectrum query. -total_slowdown_count | bigint | The total number of Amazon S3 requests with a slow down error that occurred during the external table scan. -max_slowdown_count | integer | The maximum number of Amazon S3 requests with a slow down error that occurred during the external table scan on one slice. +total_retries | bigint | The total number of retries for the Redshift Spectrum query in this segment. On RG node type clusters, this column is deprecated and contains -1. For Amazon S3 client retries on RG, see `STL_S3CLIENT`. +max_retries | integer | The maximum number of retries for one individual processed file. On RG node type clusters, this column is deprecated and contains -1. For Amazon S3 client retries on RG, see `STL_S3CLIENT`. +max_request_duration | bigint | The maximum duration of an individual file request (in microseconds). Long running queries might indicate a bottleneck. On RG node type clusters, this column is deprecated and contains -1. +avg_request_duration | bigint | The average duration of the file requests (in microseconds). On RG node type clusters, this column is deprecated and contains -1. +max_request_parallelism | integer | The maximum number of parallel requests at one slice for this Redshift Spectrum query. On RG node type clusters, this column is deprecated and contains -1. +avg_request_parallelism | double precision | The average number of parallel requests at one slice for this Redshift Spectrum query. On RG node type clusters, this column is deprecated and contains -1. +total_slowdown_count | bigint | The total number of Amazon S3 requests with a slow down error that occurred during the external table scan. On RG node type clusters, this column is deprecated and contains -1. +max_slowdown_count | integer | The maximum number of Amazon S3 requests with a slow down error that occurred during the external table scan on one slice. On RG node type clusters, this column is deprecated and contains -1.