ZIP on SFTP => Snowflake

hi @Oleksandra!

it is not possible to split these into two different tables upon load, however this can be done using a logic step after the fact.

once you load the initial .txt files (note - Rivery will treat this as one table so the schemas should match), you can use a Logic SQL step to parse out into multiple tables. Check out this article on how to use looping to do so: Dynamically create and populate tables using a looping container (this can be done with any Rivery DWH target although the example is using Snowflake)

hope that helps!
Taylor

1 Like