AWS redshift documentation change
Summary
Updated terminology from 'Redshift Spectrum queries' to 'data lake queries', added RG provisioned cluster-specific details to column descriptions, and deprecated several metrics for RG node type clusters
Security assessment
The changes involve terminology updates and technical clarifications about cluster-specific behavior. There is no evidence of security vulnerabilities being addressed, no security features added, and no references to security incidents, vulnerabilities, or mitigations. The changes focus on functionality documentation for different cluster types.
Diff
diff --git a/redshift/latest/dg/r_SVL_S3QUERY_SUMMARY.md b/redshift/latest/dg/r_SVL_S3QUERY_SUMMARY.md index 19e6a133d..711f0141d 100644 --- a//redshift/latest/dg/r_SVL_S3QUERY_SUMMARY.md +++ b//redshift/latest/dg/r_SVL_S3QUERY_SUMMARY.md @@ -13 +13 @@ Amazon Redshift will no longer support the creation of new Python UDFs starting -Use the SVL_S3QUERY_SUMMARY view to get a summary of all Amazon Redshift Spectrum queries (S3 queries) that have been run on the system. SVL_S3QUERY_SUMMARY aggregates detail from SVL_S3QUERY at the segment level. +Use the SVL_S3QUERY_SUMMARY view to get a summary of all data lake queries that have been run on the system. SVL_S3QUERY_SUMMARY aggregates detail from SVL_S3QUERY at the segment level. @@ -40,5 +40,5 @@ is_nested | char(1) | If true (`t`), this column value indicates that the nested -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. @@ -53,8 +53,8 @@ avg_split_size | bigint | The average split size processed, in bytes. -total_retries | integer | The total number of retries for one individual processed file. -max_retries | integer | The maximum number of retries for any of processed files. -max_request_duration | integer | The maximum duration of an individual file request (in microseconds). Long running queries might indicate a bottleneck. -avg_request_duration | double precision | 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 | integer | The total 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_retries | integer | The maximum number of retries for any of processed files. 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 | integer | 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 | double precision | 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.