In Redshift, we can use below query to get list of tables and it’s size
select table, size from svv_table_info where “database” = ‘dev’ and “schema” = ‘public’
Do we have anything similar in quicksight?
1 Like
No, I think you did not understand my question. I need individual dataset size
You could use a step function to ListDataSets then use a map to DescribeDataSet for each dataset.
One of the response fields is ConsumedSpiceCapacityInBytes.
There’s a blog entry that describes how one could use the API called by Lambda to create S3 files that are then used as a datasource for QS to monitor the size of QS spice datasets. Centrally tracking dashboard lineage, permissions, and more with Amazon QuickSight administrative dashboards | AWS Big Data Blog.
We have some that are approaching the current limits of QS.
