Inserting Multiple CSV Files from S3 into Separate Snowflake Tables

Summary

User seeks a solution for inserting multiple CSV files from a tgz compressed S3 bucket into separate tables in Snowflake, as the default behavior merges them into one table. They inquire about the need for a custom connector.


Question

Hello everyone,
I have tgz compressed files on s3 bucket which contains couple of csv files and I want to insert them into separate tables in snowflake. By default it merges all csv files and inserts into one table. Is there any solutions or Do I need to create custom connector for that?
Thanks!



This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want
to access the original thread.

Join the conversation on Slack

['s3', 'csv-files', 'snowflake', 'custom-connector']