I’m running FME 2024 soon to be 2025.
My workflow is reading tables from SQL Server and writing them to Snowflake.
Can someone please advise if it is possible to have the workflow automatically handle new columns being created on the source table?
I don’t want to have to publish a new version of a workflow just because a source table has a new column added to it.
Thanks in advance.
You need a dynamic writing workspace design.
documentation https://docs.safe.com/fme/html/FME-Form-Documentation/FME-ReadersWriters/!FeatureTypeProperties/workspaces_dynamic_about.htm
Article https://fme.safe.com/blog/2021/02/fme-tips-tricks-creating-dynamic-workflows/
Academy https://academy.safe.com/path/advanced-reading-and-writing and consult the following units
SchemaScanner transformer with the schema and data ports going into a dynamic writer configuration