AWS Quicksight with DynamoDB

Question

I want to visualize data in DynamoDB using Quicksight. I have created a connector between Athena and DynamoDB, The data is now accessible from AThena. however, When I load this data to quicksight from Athena, I am not able to load the data and the dashboard shows error, "The dataset is deleted or became unavailable while ingesting into spice". How can I load the DynamoDB data for visualisation?

Answer

> The dataset is deleted or became unavailable while ingesting into spice

This is almost always due to a permission issue. You should be able to expand the error to see the exact exception you are seeing. If none is available, then you can refer to your Cloudtrail logs.

You can also follow this guide to troubleshoot permission errors with Quciksight:

https://repost.aws/knowledge-center/quicksight-permission-errors

Answer

Hi,

Please, follow the detailed guidance of this blog: https://aws.amazon.com/blogs/big-data/visualize-amazon-dynamodb-insights-in-amazon-quicksight-using-the-amazon-athena-dynamodb-connector-and-aws-glue/

It shows you exactly how to do it.

Best,

Didier

AWS Quicksight with DynamoDB

Contenus pertinents