How to delete a deprecated dataset I don't own anymore but still notifying me everyday?

0

Hi,

I used to own a quicksight dashboard and all dataset. But I left the team and already transferred all dataset to other member, and that team memeber left the team as well. This dashboard was deprecated recently and I got the dataset refresh failed notification everyday. I tried to delete it since an existing team member confirmed it is not needed anymore, but it showed that I have no view/modify access. The team member I talked to also does not own the dataset hence he could not delete them. Can someone share how to delete those dataset or stop the notifications?

Thanks, -Alice

asked a year ago201 views
1 Answer
2

Hello Alice!

To resolve your issue, you can ask a Quicksight admin to update the permissions for your dataset.

First, they will need to verify who is the current owner of the dataset by running the below command from the CLI:

aws quicksight describe-data-set-permissions --aws-account-id <account-ID> --data-set-id <dataset-id>

[+] https://awscli.amazonaws.com/v2/documentation/api/latest/reference/quicksight/describe-data-set-permissions.html

  • If it belongs to a current employee, you can ask them to delete the dataset or share them with the admin. Please refer the below documentations,

[+] Deleting datasets - https://docs.aws.amazon.com/quicksight/latest/user/delete-a-data-set.html

[+] Sharing datasets - https://docs.aws.amazon.com/quicksight/latest/user/sharing-data-sets.html

  • If the dataset belongs to ex-employee, the admin can update dataset permission using the below:

aws quicksight update-data-set-permissions --aws-account-id <account-id> --data-set-id <dataset-id> --grant-permissions file://permissions.json

[+] https://awscli.amazonaws.com/v2/documentation/api/latest/reference/quicksight/update-data-set-permissions.html

The content of permissions.json is similar to the permissions below:

[
   {
      "Actions":[
         "quicksight:DescribeDataSet",
         "quicksight:DescribeDataSetPermissions",
         "quicksight:PassDataSet",
         "quicksight:DescribeIngestion",
         "quicksight:ListIngestions",
         "quicksight:UpdateDataSet",
         "quicksight:DeleteDataSet",
         "quicksight:CreateIngestion",
         "quicksight:CancelIngestion",
         "quicksight:UpdateDataSetPermissions"
      ],
      "Principal": "<full arn of new user>"
   }
] 

The new owner can later delete the dataset.

You can also consider deleting the user account of an ex-employee to stop the notifications. When removing an inactive user from AWS QuickSight account, it will give an option to either delete or transfer it's resources to an active user present :

  • Transfer ownership of all orphaned resources to a different user
  • Delete all orphaned resources.

Please refer the below documentation for more information:

[+] Managing user access inside Amazon QuickSight - Deleting a user account - https://docs.aws.amazon.com/quicksight/latest/user/managing-users.html#delete-a-user-account

You can also refer to the below article to manage Orphaned Resources of a Deleted Quicksight User:

[+] https://aws.amazon.com/premiumsupport/knowledge-center/quicksight-access-resource-deleted-user/

I hope the above helps!

AWS
answered a year ago
profile picture
EXPERT
iwasa
reviewed a year ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions