AWS redshift documentation change

Service: redshift · 2025-05-10 · Documentation low

File: redshift/latest/dg/r_STL_QUERY.md

Summary

Added example query to verify transaction commit status via sys_transaction_history

Security assessment

Adds operational documentation for transaction verification but does not address security concerns.

Diff

diff --git a/redshift/latest/dg/r_STL_QUERY.md b/redshift/latest/dg/r_STL_QUERY.md
index e7c9388f0..7ffd14778 100644
--- a//redshift/latest/dg/r_STL_QUERY.md
+++ b//redshift/latest/dg/r_STL_QUERY.md
@@ -18,0 +19,15 @@ Some or all of the data in this table can also be found in the SYS monitoring vi
+###### Note
+
+To verify whether a transaction containing the executed query was successfully committed, you need to perform a join operation between system tables and the `sys_transaction_history` table. For example:
+    
+    
+    SELECT 
+        stlq.xid AS transaction_id,
+        stlq.query AS query_id,
+        TRIM(stlq.querytxt) AS query_text,
+        th.status AS transaction_status
+    FROM 
+        stl_query stlq
+    LEFT JOIN 
+        sys_transaction_history th ON stlq.xid = th.transaction_id;
+