1 Risposta
- Più recenti
- Maggior numero di voti
- Maggior numero di commenti
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.
con risposta 10 mesi fa
Contenuto pertinente
AWS UFFICIALEAggiornata 3 anni fa- AWS UFFICIALEAggiornata un anno fa
- AWS UFFICIALEAggiornata 2 anni fa
- AWS UFFICIALEAggiornata 2 anni fa
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!