List of AWS Spice datasets and it's size

Question

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?

Answer

Hi,

you could use the QuickSight APIs to [list the data sets](https://boto3.amazonaws.com/v1/documentation/api/latest/reference/services/quicksight.html#QuickSight.Client.list_data_sets) in the response there is a attribute named `ImportMode` filtering the results where this attribute is set to `SPICE` you can retrieve all the `DataSetId` and `Name` for the dataset.

Then looping on the list of datasets you could use the API [describe_data_set](https://boto3.amazonaws.com/v1/documentation/api/latest/reference/services/quicksight.html#QuickSight.Client.describe_data_set) to retrieve details on the dataset , one of the attribute is: `ConsumedSpiceCapacityInBytes`

Also, for QuickSight related questions we have launched a fully dedicated [community](https://community.amazonquicksight.com/); in case you want to check there to see if there are further answer to your questions.

hope this helps,

List of AWS Spice datasets and it's size

Contenido relevante