Dynamic Schema is an advanced feature in Talend subscription products. It allows you to design Jobs without having to know the structure (names, types, and number of columns) of the data to be handled. You can find more information about this feature at How to process changing data structure?
However, not every component supports the dynamic schema feature.
Thanks for your response, I understand the concept of Dynamic Schema with in Talend (been using since 3-4 years).
Currently trying to use the same in one of my projects (using the Subscription Products), how ever, unable to use the same feature with Synapse components as I mentioned above in my original post.
I understand you are saying that it doesn't support dynamic, but the documentation for 'tAzureSynapseOutput' says it does support it, can you confirm if the documentation is wrong?
In the component reference, 'tAzureSynapseOutput' mainly says "Action on data" setting and a note that "The dynamic schema feature can be used in the following modes: Insert, Update, Insert or update, Update or insert, and Delete." with this setting.
It doesn't indicate this component tAzureSynapseOutput does support dynamic schema.
It should be a general note that "The dynamic schema feature can be used in the following modes: Insert, Update, Insert or update, Update or insert, and Delete." on the condition that you are using components that does support dynamic schema feature.
You could skip this section if the current component doesn't support for dynamic schema.
