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 9 months ago
Relevant content
- Accepted Answerasked 2 months ago
- asked 3 months ago
- asked a year ago
- Accepted Answerasked 2 months ago
- AWS OFFICIALUpdated a year ago
- AWS OFFICIALUpdated 8 months ago
- AWS OFFICIALUpdated a month 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!