Error message when querying WAF logs using Athena

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

주제

분석 보안, 신원 및 규정 준수

태그

아마존 Athena AWS WAF

언어

English

Laurent Vergnes

질문됨 8달 전753회 조회

1개 답변

최신
최다 투표
가장 많은 댓글

이 답변이 도움이 되었나요?커뮤니티가 여러분의 지식을 활용할 수 있도록 정답을 찬성하세요.

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

전문가

Riku_Kobayashi

답변함 8달 전

Error message when querying WAF logs using Athena

관련 콘텐츠