By using AWS re:Post, you agree to the Terms of Use
/Quicksight API for Refreshing a dataset/

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.

asked 4 months ago222 views
2 Answers
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
answered 4 months ago
  • 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 )

answered 4 months ago
EXPERT
reviewed 4 months ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions