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!

已提问 1 年前670 查看次数
1 回答
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
已回答 1 年前

您未登录。 登录 发布回答。

一个好的回答可以清楚地解答问题和提供建设性反馈,并能促进提问者的职业发展。

回答问题的准则