I want my colleague kanglee to be able to do any adjustments on the quicksight dashboards I have built, including changing the underlying analysis and the custom sql datasource.
I think I gave him all permissions, but he is only able to adjust the analysis, he is not able to edit the custom SQL.
Error message: You can’t execute the custom SQL query because you don’t have sufficient permissions to connect to the underlying data source – but that is in fact not true, he has the permissions and would be able to connect to the same datasource table when setting up a new Custom SQL dataset.
This is what I have done:
I have shared the dashboard and set kanglee as Co-owner; I allowed “save as”
I have shared the analysis with kanglee, and see him displayed as COOWNER
I went into the dataset and gave him permissions as Owner:
In addition, the datasource permissions are required for the same user if they are to edit the custom sql.
To view datasources created
Datasets > New dataset
Scroll down > FROM EXISTING DATA SOURCES
Example :
Datasource is : Athena-Default-Database
Screenshot (Left Side) > The user (saa-rls-reader) has access .
Screenshot (Right Side) > The user is now able to edit the custom SQL.
Thanks @Koushik_Muthanna this worked for me as well. I am a bit new to this so took sometime to understand datasource context here.
I followed this :
Go to Datasets → New Dataset → click on the datasource that was used to create the dataset (If someone else created the dataset, the datasource would be visible to them and in the case they would need to follow the steps) from the “FROM EXISTING DATA SOURCES” → Click on “Share data source” → add the relevant permissions through “Invite users”. Done!