Error message when querying WAF logs using Athena

Question

Hi all,

I have an error message when I want to query Waf logs with Athena following these procedures described here below
https://docs.aws.amazon.com/athena/latest/ug/waf-logs.html

I created a partitioned table awf_logs as explained but when I launch any query, I have this error message.
Sorry, I am not experimented at all and not familiar with data management.

INVALID_TABLE_PROPERTY: The 'storage.location.template' table property must contain templates for all partition columns!

Thanks for your support

Laurent

Answer

Hello.  
That error can occur if there is a mistake in the partitions set when the table is created.  
I would need to compare the partition and S3 location sections to make sure they are set up correctly.  
https://stackoverflow.com/questions/75747678/athena-query-returns-invalid-table-property-for-daily-partition-projection-pre

Error message when querying WAF logs using Athena

Contenido relevante