Hi, i have a usecase where i have one dynamo db in one account while some other dynamo db in different aws account. I want to create a dataset with these two databases and visualise it using quicksight. How can i do so? Also i want to have latest snapshot of data everytime i refresh my quicksight dashboard.
Although DynamoDB is not a natively supported dataset type in QuickSight, you can use Amazon Athena Federate Query to query the data on DynamoDB even in a cross account scenario. Also, in order for the dashboard to display the latest data as it loads, you can choose direct query (not SPICE) as the query mode when you create that Athena dataset.
The following blog posts would be of interest for you.
1 Like
Hi, i was trying doing the things mentioned over the links, i am not able to see share data source option. Also for me datasource type generated is federated not data source connector