How do I know how much SPICE capacity does each dataset occupy using API calls or any other method
Hi @KonduruVijay - Welcome to AWS Quick Sight community and thanks for posting the question. There is a very good article written by @Ben_Berliner for calculating SPICE capacity , please have a look on this.
Link - Building a Python App for QuickSight SPICE Capacity - #4 by Ramon_Lopez
Regards - Sanjeeb