By using AWS re:Post, you agree to the Terms of Use
/Athena Query Result/

Athena Query Result

0

Hi Team,

I followed the steps to create a table in AWS Athena to query VPC flow logs as mentioned here :

https://docs.aws.amazon.com/athena/latest/ug/vpc-flow-logs.html

when I ran the following query in Athena, I had output like this :

r����Z�~:�63y�pt���j��0��_��	�])h}�q ���A�ھ�K����3��肌���cf``������"����	����"������&���xL"E��M�E��M1E��B2

is this because my S3 bucket that contains the VPC flow logs is Encrypted with KMS?

Thank you,

1 Answers
0

You've probably covered the basics but it's hard to tell from the info provided, so

  • are you using an Athena table set up for the same data format as your flow logs, i.e Parquet format or not?
  • are your flow logs in the default format or custom, and does your Athena table DDL match?
answered a month ago
  • it logs in custom format, yes the DDL match

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