AWS Quicksight - translate IDs to Names Using Foreign Key

Question

I have live data on DocumentDB Provisioning data on Aurora (Postgres)

I would like to have both datasets on Quicksight for BI The DocumentDB data uses internal IDs The SQL holds the mapping to meaningful names

Is there a way to achieve such a thing?

I have a Glue job that extracts the data from the DocumentDB and outputs it as a JSON in S3 Regarding Aurora - Quicksight natively integrates

Thanks

Answer 1

I have managed to achieve this after adding another data source to the same data set. AWS then enables you to do a join between the data sources.