By using AWS re:Post, you agree to the Terms of Use

Redshift superuser permission denied to STL tables

0

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

1 Answer
1
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

answered 5 months ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions