Get full query logs in redshift serverless

Question

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?

Answer

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.

Get full query logs in redshift serverless

Contenido relevante