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

Nita_S · 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

Raj · 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

Relevant content