A data engineer is using an AWS Glue crawler to catalog data that is in an Amazon S3 bucket. The S3 bucket contains both .csv and json files. The data engineer configured the crawler to exclude the…

Question

Options

• AAdjust the AWS Glue crawler settings to ensure that the AWS Glue crawler also excludes .json
• BUse the Athena console to ensure the Athena queries also exclude the .json files.
• CRelocate the .json files to a different path within the S3 bucket.
• DUse S3 bucket policies to block access to the .json files.

• A
  6% (2)
• B
  16% (5)
• C
  71% (22)
• D
  6% (2)

Explanation

Athena does not recognize exclude patterns that you specify an AWS Glue crawler. For example, if you have an Amazon S3 bucket that contains both .csv and .json files and you exclude the .json files from the crawler, Athena queries both groups of files. To avoid this, place the files that you want to exclude in a different location. https://docs.aws.amazon.com/athena/latest/ug/troubleshooting-athena.html

No community discussion yet for this question.