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
Hi @Harsxh,
It’s been awhile since last communication on this thread, were you able to find a work around for your case or are you still encountering the same issues?
If you are encountering a bug while trying to complete, I would suggest submitting a support ticket with the AWS support team to get more in depth assistance.
If we do not hear back within the next 3 business days, I’ll close out this topic.
Thank you!
Hi @Harsxh,
Since we haven’t heard back, I’ll go ahead and 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!