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?

posta 2 anni fa912 visualizzazioni
1 Risposta
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
ESPERTO
con risposta 2 anni fa
  • 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.

Accesso non effettuato. Accedi per postare una risposta.

Una buona risposta soddisfa chiaramente la domanda, fornisce un feedback costruttivo e incoraggia la crescita professionale del richiedente.

Linee guida per rispondere alle domande