Need Help, my data source is redshift views and I made some changes in view definitions. But I got this error when I run the load data Bricks. What kind of permissions it requires ?

If you are loading data to GoodData, it should be enough to have SELECT permission to the views. If you created new views, I wouod recommend to grant the same privileges as your user (the one used in your redshift data source in GoodData) had to the previous ones.

Hi Waseem, I’d actually suggest to grant both permissions listed below, if possible:

GRANT USAGE ON SCHEMA {schema_name} TO {user_name};
GRANT SELECT ON ALL TABLES IN SCHEMA {schema_name} TO {user_name};

@Ivana Gasparekova where can i give this permission ?

Sorry to hear so. Could you try to alter the default permissions as navigated here: https://repost.aws/knowledge-center/redshift-grant-permissions-new-objects

I did but not worked. @Ivana Gasparekova

Could you share with me the RequestID or the ErrorID from your LOG, please? Feel free to use the DM if you do not want to share such information publicly.

Thank you so much for your help for the yesterday Actually there were some views created by previous devs using their usernames. so new views created under my username and gooddata was configured by the previous devs usernames. I figured out the user later , grant the access and it start working