Does Quick Sight support using a dynamo db as a data set?
I found an internal wiki that says the feature will be added as a data source in the future.
1 Like
@Rainhard : Thanks for posting this, this is an interesting question, at present i can see below data sources are supported by Quick Sight.
I think NO SQL DB is not supported, one approach may be ( not 100% sure), you can export this data to S3 and then either use S3 as data source or create an athena table on top of S3 and use athena as a data source for temp solution.
See the link how you can read dyanmodb table as S3 export and athena - https://stackoverflow.com/questions/65495999/load-and-sql-query-dynamodb-map-data-type-in-athena#:~:text=I%20have%20exported%20this%20DynamoDB%20data%20to%20S3,EXISTS%20mytable%20(Item%20struct%20<%20orgName%3Astruct<S%3Astring>%2C%20typeSavings%3AMAP<string%2Cstring>%20>)
Regards - San
2 Likes
Hi @rainmatt,
San is right. Some additional information about the Athena DynamoDB connector is here:
Thanks,
Ian
2 Likes