Quicksight API for Refreshing a dataset

0

Is there a quicksight api (REST or any other) available to refresh a dataset? I looked at the API reference guide and did not find on to refresh a dataset. There are API's available to create/update/delete datasets, but none to refresh it:

https://docs.aws.amazon.com/quicksight/latest/APIReference/qs-data.html#qs-datasets

Any help would be appreciated.

已提問 2 年前檢視次數 4433 次
2 個答案
2

It isn't listed in the API guide link above but try -

$ aws quicksight create-ingestion help

NAME create-ingestion -

DESCRIPTION Creates and starts a new SPICE ingestion on a dataset

This blog - https://aws.amazon.com/blogs/big-data/event-driven-refresh-of-spice-datasets-in-amazon-quicksight/, has the following snippet in the Cloud Formation Template .

      def create_ingestion(account_id, data_set_ids):
          logger.info('Creating the SPICE ingestions')

          for data_set_id in data_set_ids:
              dt_string = datetime.now().strftime("%Y%m%d-%H%M%S")
              ingestion_id = dt_string + '-' + data_set_id

              try:
                  response = quicksight.create_ingestion(AwsAccountId=account_id, DataSetId=data_set_id,
                                                          IngestionId=ingestion_id)

                  logger.info('Created ingestion for dataset {} with an ingestion id of {}.'.format(data_set_id, ingestion_id))

              except quicksight.exceptions.ResourceNotFoundException as rnfe:
                  logger.error('Dataset with id {} not found. {}'.format(data_set_id, rnfe))
                  return False
profile pictureAWS
Chris_P
已回答 2 年前
  • please see the other answer for details on the API reference

0

it is available here - https://docs.aws.amazon.com/quicksight/latest/APIReference/qs-data.html. (under "QuickSight API Operations to Refresh SPICE Data (SPICE Ingestion)" section )

AWS
Alex_T
已回答 2 年前
AWS
專家
已審閱 2 年前

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

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

回答問題指南