Hi, from Using Amazon OpenSearch Service with Amazon QuickSight - Amazon QuickSight, quicksight is able to ingest dataset from opensearch. Is there a way to programmatically set this up to ingest specified datasets/create analysis from OpenSearch, as we cannot manually repeat this process for every dataset added to our Opensearch cluster?
Thank you!
Hello @zhan2819,
I have not done this myself and I cannot find any blog adressing this question, but I will start by looking at what information the cloudtrail events for AddDataSource gives you.
If you catch this event using EventBridge
You can then use this event to trigger another process, e.g. Lambda, to automatically create the dataset in QuickSight.
Hope this helps getting you in the right direction!
Hi @zhan2819,
It’s been awhile since we last heard from you, did you have any additional questions regarding your initial post?
If we do not hear back within the next 3 business days, I’ll go ahead and close out this topic.
Thank you!
Hi @zhan2819,
Since we haven’t heard back, I’ll close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed.
Thank you!