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 a year ago
Relevant content
- Accepted Answerasked 4 months ago
- asked 5 months ago
- Accepted Answerasked 5 months ago
- asked 2 years ago
- AWS OFFICIALUpdated a year ago
- AWS OFFICIALUpdated 3 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!