Amazon Aurora zero-ETL for capturing change history

0

I currently use Aurora MySQL and need to capture history on some tables, currently use a custom solution using custom apllication logic to capture history for a given table. Been looking Amazon Aurora zero-ETL to redshift, is it possible to configure so changes are captured in redshift so I can query history for a given table?

AC
質問済み 1ヶ月前276ビュー
1回答
0

Hello AC,

To capture and view the history on the tables, you would need to enable audit logging on the table. To accomplish that

  1. select the database and click on Modify.
  2. In the subsequent screen, scroll all the way to the bottom in the Additional Configuration section and turn on Audit Log in the Log Exports section

You could also follow the steps as described in this re:Post article.

To send the logs from CloudWatch to Redshift enable subscriptions by following the steps here.

Hope this helps.

Best regards, Mukul Dharwadkar

profile picture
回答済み 1ヶ月前
profile picture
エキスパート
レビュー済み 1ヶ月前

ログインしていません。 ログイン 回答を投稿する。

優れた回答とは、質問に明確に答え、建設的なフィードバックを提供し、質問者の専門分野におけるスキルの向上を促すものです。

質問に答えるためのガイドライン

関連するコンテンツ