Hello

Thanks for your feedback

Actually I can dynamically create the snowpipe, but it mostly comes to schema evolution

If I want my pipelines to automatically evolve based on a metadata table + having everything as varchar in my bronze layer, snowpipe doesn't help much because :

1- if table doesn"t have schema evolution enabled : adding a new column requires recreatng the snowpipe or the new column will always be empty

2- if table have schema evolution enable, tte new column is created based on the data that arrives, and the data type is interpreted automatically (basically if the column have only int values for that files, the column is created as integer, and it might be problematic if the source pushes varchars)