有工具可以使用CloudWatch putMetric API将AWS QLDB表的全部内容发布到Cloudwatch吗?

huangapple go评论65阅读模式
英文:

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

问题

我有一个使用案例,其中QLDB表包含以下内容:

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

我需要每5分钟为每个customer-id发布云监控指标,这些数据在QLDB表中可用。

是否有方法可以实现这个目标?

QLDB有导出作业可以将内容导出到S3,是否有工具可以将内容导出到CloudWatch?

英文:

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?

答案1

得分: 2

许多客户使用定期的S3导出(或者如果您已经预览注册,可以使用Kinesis集成)来保持某种类型的分析数据库的最新状态。例如,您可能每分钟将数据复制到Redshift或ElasticSearch中。我现在没有代码示例与您分享。棘手的部分是将数据整理成目标所需的正确格式。例如,QLDB支持嵌套内容,而Redshift不支持。

一旦数据可用并按您希望查询的方式聚合,运行报告并将结果写入CloudWatch应该是一件简单的事情。

英文:

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.

huangapple
  • 本文由 发表于 2020年1月7日 01:43:23
  • 转载请务必保留本文链接:https://go.coder-hub.com/59616616.html
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定