1 Answer
- Newest
- Most votes
- Most comments
1
In Redshift Serverless the Cloudwatch
logs will capture the full SQL text. You can enable user activity log
from the Namespace configuration
tab, under the Security and encryption
sub-tab.
Once enabled I was able to capture the query text for a dummy query I ran that was 5990 characters in length.
From Cloudwatch you can enable Export data to Amazon S3
and then run queries on the logs itself.
answered 10 months ago
Relevant content
- asked 4 months ago
- Accepted Answerasked 3 months ago
- asked a year ago
- asked a year ago
- AWS OFFICIALUpdated 9 months ago
- AWS OFFICIALUpdated 2 months ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 2 years ago
The connection log, user log, and user activity log can be enabled by using the AWS Management Console (parameter-group). I do not know if the same is also possible with serverless redshift. But I guess it should!