We are trying to use redshift serverless. It shows the query history is stored in the table sys_query_history.
But looking at the table, the query_text field has a 4000 characters limit. They'd truncate the query. Is there another way to get the full executed queries in Redshift Serverless?
Asked
Active
Viewed 482 times
0
lucky_start_izumi
- 2,511
- 13
- 41
- 61
1 Answers
0
No.
The system tables are almost wholly removed (you keep PG, about two hundred, and SYS, about a dozen). It is not possible to manage your own cluster; all you can do is contact Support, wait, and pray.
I'm going to publish a PDF about Serverless this weekend (2023-05-20/21), it'll be be on my Redshift web-site, Google on my name and "Redshift").
Max Ganz II
- 149
- 5