AWS redshift documentation change
Summary
Updated documentation for SVL_S3QUERY view to add RG cluster-specific behavior details and deprecation notes
Security assessment
Changes are purely informational updates about RG cluster metrics behavior and deprecation of certain columns. No security vulnerabilities, fixes, or security features are mentioned. Updates clarify operational behavior without security implications.
Diff
diff --git a/redshift/latest/dg/r_SVL_S3QUERY.md b/redshift/latest/dg/r_SVL_S3QUERY.md index bbff0d41c..b887264e9 100644 --- a//redshift/latest/dg/r_SVL_S3QUERY.md +++ b//redshift/latest/dg/r_SVL_S3QUERY.md @@ -13 +13 @@ Amazon Redshift will no longer support the creation of new Python UDFs starting -Use the SVL_S3QUERY view to get details about Amazon Redshift Spectrum queries at the segment and node slice level. +Use the SVL_S3QUERY view to get details about data lake queries at the segment and node slice level. @@ -37,4 +37,4 @@ is_rrscan | char(1) | If true (`t`), this column value indicates that a range-re -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. -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. +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 number of rows read directly from Amazon S3 by the cluster's native reader, before filter pushdown. +s3_scanned_bytes | bigint | The number of bytes scanned from Amazon S3 and sent to the Redshift Spectrum layer. On RG provisioned clusters, this is the total scan-range size in bytes processed by the cluster's native reader. +s3query_returned_rows | bigint | The number of rows returned from the Redshift Spectrum layer to the cluster. On RG provisioned clusters, this is the number of rows produced by the external table scan after filter pushdown. +s3query_returned_bytes | bigint | The number of bytes returned from the Redshift Spectrum layer to the cluster. On RG provisioned clusters, this is the number of bytes produced by the external table scan after filter pushdown. @@ -42,9 +42,9 @@ files | integer | The number of files that were processed for this S3 scan step -splits | int | The number of splits processed on this slice. With large splitable data files, for example, data files larger than about 512 MB, Redshift Spectrum tries to split the files into multiple S3 requests for parallel processing. -total_split_size | bigint | The total size of all splits processed on this slice, in bytes. -max_split_size | bigint | The maximum split size processed for this slice, in bytes. -total_retries | integer | The total number of retries for the processed files. -max_retries | integer | The maximum number of retries for an individual processed file. -max_request_duration | integer | The maximum duration of an individual Redshift Spectrum request (in microseconds). -avg_request_duration | double precision | The average duration of the Redshift Spectrum requests (in microseconds). -max_request_parallelism | integer | The maximum number of outstanding Redshift Spectrum on this slice for this S3 scan step. -avg_request_parallelism | double precision | The average number of parallel Redshift Spectrum requests on this slice for this S3 scan step. +splits | int | The number of splits processed on this slice. With large splitable data files, for example, data files larger than about 512 MB, Redshift Spectrum tries to split the files into multiple S3 requests for parallel processing. On RG provisioned clusters, this is the number of scan ranges consumed by the cluster's native reader. +total_split_size | bigint | The total size of all splits processed on this slice, in bytes. On RG provisioned clusters, this is the total size of all scan ranges consumed, in bytes. +max_split_size | bigint | The maximum split size processed for this slice, in bytes. On RG provisioned clusters, this is the size of the largest scan range consumed, in bytes. +total_retries | integer | The total number of retries for the 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_retries | integer | The maximum number of retries for an 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 | integer | The maximum duration of an individual Redshift Spectrum request (in microseconds). On RG node type clusters, this column is deprecated and contains -1. +avg_request_duration | double precision | The average duration of the Redshift Spectrum requests (in microseconds). On RG node type clusters, this column is deprecated and contains -1. +max_request_parallelism | integer | The maximum number of outstanding Redshift Spectrum on this slice for this S3 scan step. On RG node type clusters, this column is deprecated and contains -1. +avg_request_parallelism | double precision | The average number of parallel Redshift Spectrum requests on this slice for this S3 scan step. On RG node type clusters, this column is deprecated and contains -1.