Is it possible to make authors unable to edit/save custom SQL of a dataset(but still able to view it and use)?

Q&A
, , ,
1

Is it possible to make authors unable to edit/save datasets(but still able to view them and use)?

Maybe removing certain permissions, which then prevent them to edit/save dataset?
Perhaps using custom profiles?

Thank you for your help :slight_smile:

2

Hi @Raphael_Tan,

To allow users to view and use a dataset but not allow them to edit it, you have to choose the “Viewer” permission.

3

However, as a viewer, there is no way for them to see things like the schema or the custom SQL.

Viewers cannot use the editor UI - thus they cannot see the schema of the dataset nor the custom SQL in that regard.
So i was thinking maybe authors without the access to the “Save & Publish” or ‘Add data’ buttons. Is this possible?

4

Hi @Raphael_Tan - Did you try to give only Data Set describe permission to author and check whether they are able to the custom sql or not? I am not 100% sure as well, but give a try.

Regards - Sanjeeb

5

@Raphael_Tan,

Viewers don’t have the “Edit Dataset” button. Without clicking on that button, there’s no way to see the schema or custom SQL query.

Viewer permission comes with the following actions:
“quicksight:DescribeRefreshSchedule”,
“quicksight:ListIngestions”,
“quicksight:ListRefreshSchedules”,
“quicksight:DescribeDataSetPermissions”,
“quicksight:PassDataSet”,
“quicksight:DescribeDataSet”,
“quicksight:DescribeIngestion”

Owner permission comes with the following:
“quicksight:DeleteDataSet”,
“quicksight:UpdateDataSetPermissions”,
“quicksight:PutDataSetRefreshProperties”,
“quicksight:CreateRefreshSchedule”,
“quicksight:CancelIngestion”,
“quicksight:ListRefreshSchedules”,
“quicksight:PassDataSet”,
“quicksight:UpdateRefreshSchedule”,
“quicksight:DeleteRefreshSchedule”,
“quicksight:DescribeDataSetRefreshProperties”,
“quicksight:DescribeDataSet”,
“quicksight:CreateIngestion”,
“quicksight:DescribeRefreshSchedule”,
“quicksight:ListIngestions”,
“quicksight:UpdateDataSet”,
“quicksight:DescribeDataSetPermissions”,
“quicksight:DeleteDataSetRefreshProperties”,
“quicksight:DescribeIngestion”

1 Like
6

Hi @David_Wong - Just thinking, can we also have an approach to see the custom sql logic without having edit option. Possibly when a user just move the mouse so kind of pop up to see the logic. Not sure whether it will be a useful feature or not, please advise. If it is going to helpful from developer experience prospective, we can always request QS team to add this as feature request.

Regards - Sanjeeb

7

hi @Raphael_Tan ,

at this moment, Viewer can’t see the scheme or the custom SQL on the dataset. I will tag this as feature request. thank you for posting question!

kind reagrds,
Wakana