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.

gefragt vor 2 Jahren4438 Aufrufe
2 Antworten
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
beantwortet vor 2 Jahren
  • 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
beantwortet vor 2 Jahren
AWS
EXPERTE
überprüft vor 2 Jahren

Du bist nicht angemeldet. Anmelden um eine Antwort zu veröffentlichen.

Eine gute Antwort beantwortet die Frage klar, gibt konstruktives Feedback und fördert die berufliche Weiterentwicklung des Fragenstellers.

Richtlinien für die Beantwortung von Fragen