How to enrich opensearch dataset

I have several datasets buillt from opensearch that have user IDs in them and I’d like to display users names in my quicksight dashboards. I have user information in a separate dataset so it seems like joining it to my opensearch dataset would be the ideal solution but for some reason opensearch doesn’t support joining data even though the documentation for joining states that any datasets can be joined except for IOT

Are there any other options for getting this data into my reports?

Unfortunatley that is a limitation of QuickSight.

I would suggest brining Opensearch to Athena. From Athena, you can do so much more. You can write SQL on it and you can join it to other datasets in QuickSight.

Hi @rbell, did Max’s solution work for you? I am marking his reply as, “Solution,” but let us know if this is not resolved. Thanks for posting your questions on the QuickSight Community Q&A Forum!

It did not. I did discover that I could add opensearch data sources and datasets to other, non opensearch datasources (in my case an rds datasource) so I reversed the order of my mappings and now add the opensearch dataset to the dataset which contains my user data.

A bit clunky but it works.


1 Like