Redshift superuser permission denied to STL tables

Question

After creating a Redshift Serverless cluster with superuser admin I cannot query the view STL_LOAD_ERRORS or the table STLL_LOAD_ERRORS.   I'm getting a permission denied error for the following query:

```
SELECT *
FROM dev.pg_catalog.stl_load_errors
LIMIT 10
```
`[42501] ERROR: permission denied for relation stl_load_errors`
 
I have confirmed that my current user is a superuser using the query:
```
SELECT * FROM pg_user
```

**What am I missing here? Shouldn't the super user be able to view all tables?**

Here's some of the documentation I've already referenced:

https://docs.aws.amazon.com/redshift/latest/dg/r_superusers.html
https://docs.aws.amazon.com/redshift/latest/dg/c_visibility-of-data.html
https://docs.aws.amazon.com/redshift/latest/mgmt/serverless-security.html
https://docs.aws.amazon.com/redshift/latest/gsg/t_querying_redshift_system_tables.html

Accepted Answer

Please try

1.	select * from sys_load_history

2.	select * from SYS_LOAD_ERROR_DETAIL

New monitoring views in serverless 
•	SYS_QUERY_HISTORY
•	SYS_QUERY_DETAIL
•	SYS_EXTERNAL_QUERY_DETAIL 
•	SYS_LOAD_HISTORY • SYS_LOAD_ERROR_DETAIL 
•	SYS_UNLOAD_HISTORY
•	SYS_SERVERLESS_USAGE

You can't query STL, STV, SVCS, SVL, and some SVV system tables and views with Amazon Redshift Serverless, except certain SVV tables.

for additional details please refer following.
https://docs.aws.amazon.com/redshift/latest/mgmt/serverless-monitoring.html#serverless_views-monitoring

Answer

Recently we migrated from provisioned to server less cluster. We are using svl_stored_proc_messages to get information about stored procedure messages. but it is not working in serverless. is there an alternative for this please?

Redshift superuser permission denied to STL tables

相關內容