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?