Cannot release SPICE Capacity on Quicksight

You can check the size of the dataset and the size of the ingestion's using the below API's ->DescribeDataSet ->"ConsumedSpiceCapacityInBytes" response value ->List Ingestions -> "IngestionSizeInBytes" response value

You can refer this existing repost as well->https://repost.aws/questions/QUVpyxVfgTQuOSOYS_x_KhIw/cannot-release-spice-capacity-on-quicksight.

For your questions,

"How can I release all the SPICE Capacity like the time I created the dataset" -> You will only be able to release unused SPICE capacity. https://docs.aws.amazon.com/quicksight/latest/user/managing-spice-capacity.html#spice-capacity-releasing

"Do the analyses still work after release all?" -> I am not completely sure of the ask, however considering the scenario, in case you mean if you release the capacity by deleting the dataset, it will make any analysis based on top of it unusable.

Hello,

In general, Amazon Quicksight return an error if any Dataset occupies size greater than the SPICE Capacity available. The behavior being observed at your end is contradicting expected behavior and need Quicksight team to investigate. Kindly, please raise a case to AWS Support team so that an engineer can investigate and provide you possible mitigation measures.

Thank you !!