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년 전930회 조회
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.

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인