Just curious what does everyone here use for analy...
# randomg
Garret Harp
12/31/2021, 7:43 PMJust curious what does everyone here use for analytics when using DynamoDB?
f
Frank
12/31/2021, 7:55 PM
Hey @Garret Harp, just metrics from CloudWatch for us. DDB has been quite reliable, we’ve been just monitoring the API/Lambda response time, and dig into DDB metrics on demand.
g
Garret Harp
12/31/2021, 7:57 PMSorry should have been a bit more clear on this, I meant analytics as in building out dashboards using the data in the table (like tableau or clicdata etc)
h
Hamed Mamdoohi
12/31/2021, 8:43 PMYou could stream your records to Redshift and query redshift for analytics
t
Thomas Ankcorn
12/31/2021, 10:24 PMS3, Athena, and then https://cube.dev to build an API layer.
c
Carlos Daniel
01/01/2022, 12:30 AMI usually build some sort of data lake using S3, Glue and Athena. for that I:
• Put a Lambda Stream on the desired DDB table. That Lambda will parse the data to Parquet and store it on an S3 bucket;
• Build a crawler with a consistent schema for the S3 data on Glue;
• Generate a table for the Glue schema;
• Go into Athena and query the Glue table;
Don't know if it's the best way, but it's the way I know