List of AWS Spice datasets and it's size

0

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?

asked 2 years ago886 views
1 Answer
1

Hi,

you could use the QuickSight APIs to list the 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 to retrieve details on the dataset , one of the attribute is: ConsumedSpiceCapacityInBytes

Also, for QuickSight related questions we have launched a fully dedicated community; in case you want to check there to see if there are further answer to your questions.

hope this helps,

AWS
EXPERT
answered 2 years ago
  • Hi,

    Thank you for the response. We did use this but challenge here is, it's difficult to read the output and get it into a tabular format

    And is there a way to restrict response of describe datasets and list datasets? Only thing we need in the result is Name, ConsumedSpiceCapacityInBytes and maybe couple of other things

  • Thank you for the feedback, currently I am not aware of other methods, as for restricting the response currently aside from scripting it there is no other option I will bring the feedback back to the team.

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions