This package should document what permission are needed to use these views

[mikekaminsky]

My default analyst role doesn't have the ability to view this relation:

dwh=> select * from redshift_admin.table_stats limit 5;
ERROR:  permission denied for relation stv_tbl_perm

Nor this one:

dwh=> select * from redshift_admin.users_table_view_privileges limit 5;
ERROR:  permission denied for schema
    dev

Important to note, the dev schema doesn't even exist at this point (I dropped it earlier today).

It seems like these views are only queryable by admins :/

[Limess]

Weirdly even as an admin I have difficulty accessing one of these views.

I get ERROR: permission denied for relation stv_partitions when querying redshift_admin_table_stats but I can happily query that table in isolation.

That could be a separate issue - I can access all the other views.

[clrcrl]

Hmmm can you try installing from this fork and checking what happens?

packages:
 - git: "git@github.com:davehowell/redshift.git"
   revision: "fix/qualify-base-model-schemas"

[Limess]

No luck, I still can't access that view.

Could be something to do with permissions on my side, I can't access a similar view in our own DBT models which uses stv_blocklist but can query that table.

[Limess]

So my issue was that I was creating the users with a non-super user, so even super users could not access the view as it was using the permissions of the original user.

We'll resolve that by having a separate DBT run which uses a superuser to create only these views.

That probably isn't relevant to the original issue.