Query AWS S3 ALB Access Logs with Amazon Athena

Поделиться
HTML-код
  • Опубликовано: 20 дек 2024

Комментарии • 9

  • @DesiAustrianDreams
    @DesiAustrianDreams 5 месяцев назад +2

    Thank. I have setup exactly like this and I was able to query until a particular date and then recently I noticed that when querying it doesnot return results since that date(24th May was the last date for which query returns result). I checked s3 and the logs are getting generated for each and every day

    • @DigitalCloudTraining
      @DigitalCloudTraining  5 месяцев назад

      Hi there, we recommend posting your question in our Facebook group. Our community members are always happy to share their knowledge and help each other out.
      If you're not already a member of our Facebook community, we'd love to have you join us! 

      Here's the link to sign up: facebook.com/groups/awscertificationqa
      Once you're in, you can post your question and get some helpful insights.
      Thank you for your understanding, and we wish you all the best in your exam preparations!

    • @Dougie_Peart
      @Dougie_Peart 4 месяца назад +1

      Hey, I have the exact same issue. I recreated the table and it works again. Bizarre!

    • @TheMikeAngelus
      @TheMikeAngelus 2 месяца назад

      I have precisely the same problem, affected at the same date! AWS must've broken something on that day.

  • @danghuynguyen8579
    @danghuynguyen8579 3 месяца назад

    This solution is not optimized yet. What if you have TB of log files? Athena will scan all the raw file -> increasing cost and performance. It would be nice if you can do optimization analysis

    • @DigitalCloudTraining
      @DigitalCloudTraining  2 месяца назад

      Hi there, we recommend posting your question in our Facebook group. Our community members are always happy to share their knowledge and help each other out.
      If you're not already a member of our Facebook community, we'd love to have you join us! 

      Here's the link to sign up: facebook.com/groups/awscertificationqa
      Once you're in, you can post your question and get some helpful insights.

  • @kajalkuchekar5293
    @kajalkuchekar5293 7 месяцев назад

    where is the query for creating table

    • @DigitalCloudTraining
      @DigitalCloudTraining  7 месяцев назад

      This is only part of our full course, You can get the full course by getting our monthly/annual plan here: digitalcloud.training/plans/