AWS glue read csv file with two header rows, ignore the first one

1

Hello,

Currently I am trying to read csv files in my s3 bucket with the following format:

header 1, header 2, header 3
value 1, value 2, value 3
header 1, header 2, header 3, header 4
value 1, value 2, value 3, value 4 

as you can see I have two header rows. But I only care about the second header row and everything below. Is there a way to ignore the first two lines with glue and use the second header row as a starting point to create a table?

asked 2 years ago127 views
No Answers

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