Hello,
I am getting this error when I try to edit a dataset query.
I am the owner of the dataset and the view on which it is created. what other permissions do I need to edit this dataset totally ?
Hello @Karan_Shah !
I know that you are the owner of the dataset, but did you pull in any extra fields to the dataset before ingesting it into QS? That might be causing the problem.
Hi @Karan_Shah
To edit SQL in dataset, you need to have owner permission on data source ,from which this dataset is created. Can you check if you have owner access to this data source as well ?
If not, please get owner access and try editing the SQL once again.
2 Likes
Hi @Karan_Shah - In addition to above suggestions, also please check the user that is used for connecting Redshift from QS has the access to view. To verify the same, use any client tool, connect to Redshift with the user and do a select * from the view.
Regards - Sanjeeb
1 Like
Hello @Karan_Shah ! Are you still having trouble with this issue?
Hello @Karan_Shah !
We haven’t heard from you in a few days but would still like to help you solve this problem. For now I am going to mark @Ashok 's comment as a solution but if you still need help please feel free to post in the community.
Hey I have all the permissions for data source and dataset as well. I can create my own dataset by connecting the data source with the same query as in this dataset, however it does not let me edit previously owned dataset form other user even though I am the owner in dataset and data source.