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?

已提問 2 年前檢視次數 912 次
1 個回答
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
專家
已回答 2 年前
  • 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.

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南