Hello all, can someone let me know, how to import file from s3 bucket to snowflake with no header. I need to pass schema externally and all the data types are string

Hi Naren! Thanks for your patience - I was out on holiday all last week, catching up with messages now. I haven't seen this question before so need a bit of time to look into it. Could you give me more details on what you mean by passing the schema externally?

Hi @Nataly Merezhuk (Airbyte), thanks for looking into this. but I solved this issue. thanks again for responding

That's wonderful to hear. If you have time, could you please elaborate on how you fixed this? That would help users that might run into this in the future!

In the S3 connection details, it has a option for setting external header, if the csv file doesnt have header in it. And I had datatype issues which I resolved using "latin-1" encoding type instead of "utf8" which is default.

Thanks so much for the info!