AWS config with Athena - Issue

0

Hi, I followed this article - https://aws.amazon.com/blogs/mt/how-to-query-your-aws-resource-configuration-states-using-aws-config-and-amazon-athena/ When I check the Lambda logs - It is trying to query "ConfigHistory" too. Not sure why. Seems like it is getting triggered not only when configsnapshot is updated, but the confighistory path is updated as well.

Error 1: Ignoring event for non-configuration snapshot object key AWSLogs/<Acct>/Config/us-east-1/2022/3/13/ConfigHistory/*.json.gz

Error 2: However, it is adding and dropping tables, adding dt=latest as well. But, still I do see these while executing the 1st sample query in the document for - '$.instancetype') = 't3a.large'

Row is not a valid JSON Object - JSONException: Duplicate key "name" This query ran against the "sampledb" database, unless qualified by the query. Please post the error message on our forum or contact customer support with Query Id: cd87ba3c-018c-49e5-9724-fbd0cf201ab4

At a high level, AWS config is sending configsnapshots to the S3 bucket and the Lambda is triggered, but something is missing which I couldn't find it. Any help is greatly appreciated. Thank you.

  • Have you verified your Cloudtrail Logs?

No Answers

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions