Quicksight API for Refreshing a dataset

Question

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.

Answer

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

Answer

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 )

Quicksight API for Refreshing a dataset

Relevant content