Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Quicksight refreshing Anomaly dashboards for real time data

Currently AWS QuickSight has an option to refresh the Dataset from S3 using scheduled refresh. Once the data is refreshed, normal dashboards (visuals chart) gets updated with new data.

For Anomaly dashboards (insights chart), currently if the data is refreshed, we need to manually trigger the "run now" and later run "update".

Is their a way or option to automate the refresh for Anomaly dashboard as well? Can we trigger it using programming?

like image 315
Arvind Purohith Avatar asked Oct 28 '25 00:10

Arvind Purohith


1 Answers

I used AWS CLI with below command:

aws quicksight create-ingestion --aws-account-id <YOUR-AWS-ACCOUNT --ingestion-id <UNIQUE-ID> --data-set-id <DATASET-ID> --region <REGION>

--aws-accout-id -> The account to your desired quicksight

--ingestion-id -> This can be any unique name(string)

--data-set-id -> Go to QuckSight dataset to find the unique string

--region -> Your region for the aws-account

Also I did the same using Python boto3:

import boto3
import calendar
import time

client = boto3.client(
    'quicksight',
    region_name='us-east-1'
)


#to create unique number
ingestionID = calendar.timegm(time.gmtime())
response = client.create_ingestion(
    DataSetId='12345e-d123-4123-b1a1-12f30154b123',
    IngestionId=str(ingestionID),
    AwsAccountId='123456789123'
)


print(response)
like image 66
Nima Najafi Avatar answered Oct 31 '25 11:10

Nima Najafi



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!