Get full query logs in redshift serverless

1

Hi friends, We need to access executed queries in our redshift serverless. It shows there's the sys_query_history table https://docs.aws.amazon.com/redshift/latest/dg/SYS_QUERY_HISTORY.html, but the query_text has a 4000 character limits, longer than that would be truncated. Is there another way for getting full query text in Redshift Serverless?

  • 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!

asked a year ago543 views
1 Answer
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.

profile pictureAWS
answered 9 months ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions