I am attempting to extract and load multiple files from S3 to Redshift using Airbyte, but my current solution only works for a single file. When attempting to load multiple files, I am receiving the error message “CSV parse error: Empty CSV file or block: cannot infer number of columns.” I am in need of a solution that can successfully extract and load multiple files from S3 to Redshift using Airbyte.
What connector are you using?