Hi there! I am new to Airbyte and I am trying to load 36 different sets of csv files from s3 to Snowflake. I am able to do this directly on Snowflake but wanted to test Airbyte. Is it possible to define a single S3 source that will understand the s3 "folder" structure and create separate tables in the DB? The structure is: s3://<bucket>/<table name>/yyyy/mm/dd/<table name>.csv.gz and I'd like to have a table for each <table name> created in the DB. Thanks!

Yes, it’s possible: https://docs.airbyte.com/integrations/sources/s3#path-pattern

Hi Marcos, I can see how I can select multiple files to be loaded in the same table regardless of where they are, but I am missing how I could extract the desired table name from the s3 path.

Unfortunately it’s not possible 😞

Got it. Is this doable architecturally? If so, I'll formalize it as a product suggestion.

@Pedro Machado Did you create an issue for this already?

Hi Melker. I did not. We went in a different direction.