Search code examples
amazon-web-servicesamazon-cloudwatchamazon-cloudwatch-metricsamazon-qldb

Is there tooling to publish the ENTIRE content FROM an AWS QLDB table to Cloudwatch using CloudWatch putMetric API?

I have a use-case where QLDB table contains this :

customer-id | customer-name | customer-item-count

I have a need to publish the metrics per customer-id every 5 minutes to cloudwatch and this data is available is in the QLDB table.

Is there a way to do?

QLDB has export jobs to export the content to S3, is there tooling to dump contents to cloudwatch?

Solution

  • Many customers use periodic S3 exports (or Kinesis integration, if you signed up for the preview) to keep some sort of analytics DB up to date. For example, you might copy data into Redshift or ElasticSearch every minute. I don't have code examples to share with you right now. The tricky part is getting the data into the right shape for the destination. For example, QLDB supports nested content while Redshift does not.

    Once the data is available and aggregated in the way you wish to query it, it should be a simple matter to run a report and write the results into CloudWatch.