1 réponse
- Le plus récent
- Le plus de votes
- La plupart des commentaires
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.
répondu il y a 10 mois
Contenus pertinents
- demandé il y a un an
- demandé il y a un mois
- demandé il y a un an
AWS OFFICIELA mis à jour il y a 2 ans- AWS OFFICIELA mis à jour il y a 2 ans
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!