'Amazon Glue Crawler - Column names in separate file

I have files in s3 which is separated into two sections. One folder contains the column names and the other folder contains the data files per month


 - S3-bucket-root
   - column_name
     - col_names.csv
   - data
     - data_Jan.csv
     - data_Feb.csv

The col_names file contains the column names/header. The data_.csv file contains the raw data

Is there a way to run the glue crawler using the UI to merge the files and then save the result to be used in Athena?

I've looked around few posts in SO, but none so far seems to help.

Any assistance is appreciated.



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source