How to fix permission denied for relation?

1

Hello!

I’m a new user of redash. I’m getting an error when I try to run a new SQL query that uses the view:

Error running query: permission denied for relation net_income

Can I grant permission to thew view and where can I do it? In redash or in database level?

2

That permissions error comes from your database, not Redash. To fix it, someone with higher privileges needs to GRANT SELECT on net_income to the user/password that Redash uses to connect.