How do I know how much SPICE capacity does each dataset occupy using API calls or any other method
Hi @KonduruVijay - Welcome to AWS QuickSight 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 - Article -- Building a Python App for QuickSight SPICE Capacity - #4 by Ramon_Lopez
Regards - Sanjeeb