Hello,
When i delete a field on the view (Athena) and then refresh the data set on Quicksight, the refresh fails because it cant find this field, how can i delete the field from the data set on Quicksight as well?
Thanks
Hello @InbalK
When you mention refresh, I assume your dataset uses SPICE. The refresh likely failed because a field is missing in the view as you said.
You can do it this way so that the dataset in Quicksight updates as per your view in Athena →
Step 1 - Edit the dataset → Change to Direct query → Save and Publish
Switching to Direct Query helps quicksight to get the updated information from the data source. (in your case you have connected to View so it will get the updated columns information and removes the columns that are not in the View (Athena))
Step 2 - Edit the dataset → Change to SPICE again → Save and Publish
Please let me know if that helped.
Thank you,
Shravya
1 Like
@shravya
Works great, thanks!
Is it work also with field renaming? i mean, if i rename a field from Athena, it will update the dataset in Quicksight as well (include all the visuals and calculations with this field?)
Thanks
1 Like
Hello @InbalK
It will only update the dataset with new columns as like Athena but you need to update the field on the visual and the calculations where this field is used.
Thank you,
Shravya
1 Like