Export Athena View as CSV to AWS S3 using Glue

Today we will learn on how to export Athena view to AWS S3 using Glue

Steps:
  • Create a S3 folder
  • Create athena view
  • Create a new Glue python shell job
    • We will use boto3 library to query athena and export the data as csv to S3
  • Import the boto3 library
  • write below code that calls out start_query_execution() function.


Comments