i am problem with display view from my DB.I configured data source and use non public schema (custom schema name)
After connect over data connector to my DB (in Model) - returns back only tables no views. The user has set permission to select from views.
If I try the same situation with just the public schema, I see tables and views.
Isn't the problem that I have the view in a different schema than the public?
Thank you for your answers
Can you please confirm what GoodData product are you using and also what kind of database?
you are using GoodData cloud and Postgresql DB
You have mentioned that the permission to select from views is there. However, you should also make sure that the user has usage rights to the scheme where the views are created:
Yes, my user has access rights.
I followed the link - https://www.gooddata.com/developers/cloud-native/doc/cloud/connect-data/create-data-sources/postgresql/#configure-user-access-rights
The problem is only when using other schemas instead of public schema.
When I try to connect to the DB with another client (DBeaver) with the same user etc. everything is fine
Have you specified the correct schema as pointed on step 5. in the mentioned doc page?
If you have the correct schema specified on the datasource, can you please confirm if the user/role used on the user has especially those four access rights?
My data source look like this
All grant to user, schema, select, views is set
Thank you for the additional details. I’ve reached out to you internally.
I tried to connect to Postgres datasource with my custom schema and I can see views without an issues given that my user has usage granted on the schema.
I would suggest you try to compare the permissions for your user on the public schema and on your custom schema to see where it differs. Also try to check permissions on the views within your custom schema for your user.
hmm OK. I will try again and check permissions.
I've turned on SQL query logging and we've been testing the SQL that GD calls directly. After manually calling it, we get back both the list of tables and the view
Could the problem be that the interface can't display multiple records? Both tables and views?
Is it possible to contact you (Jan Kos) directly by phone?
please give me a answer..
I’m truly sorry, you followup question slipped under our radar.
Displaying tables and views in LDM modeller shouldn’t be a problem as I didn’t have a problem during my testing. Have you tried setting up a new user with required permissions mentioned above and still unable to see the views?
If you are still unable see the views after, can you please share what are the exact permissions applied to the user? Also what version is your Postgres DB on?