This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(102.4, 84%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESH%3C/text%3E%3C/svg%3E)
It appears that there is not a way to ingest from Common Data Model as a source in mapping data flow using dynamic schema. The "Allow Schema Drift" option is not exposed for the Common Data Model inline dataset, and validation does not allow the Projection to be blank. Validation will provide error similar to:
Is this a bug or just a missing feature? Ideally, we want to by dynamic / metadata-driven. Is this not possibly when using Common Data Model as a source? Must we create a separate explicit mapping data flow for each entity we wish to ingest from the Common Data Model?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 9%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
Hi @Anonymous ,
Welcome to Microsoft Q&A forum and thanks for your query.
We are reaching out to product team to get additional clarification on this behavior and will get back to you as soon as we have an update.
Thank you for your patience.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(137.6, 61%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMK%3C/text%3E%3C/svg%3E)
Schema drift is a bit antithetical to the concepts behind a well-defined schema format like CDM, so it is not currently enabled in ADF for CDM scenarios. That being said, we are looking at opening up ways to allow schema changes in a more dynamic CDM implementation. Will announce some changes in this regard soon.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
@KranthiPakala-MSFT / @Mark Kromer MSFT / others ---
We have encountered this same issue consuming CDM data source via ADF --- is there an update allowing schema drift functionality when dynamically consuming CDM entities?
Thanks --
Walt
The real goal is to iterate over the entities using an automatic/dynamic schema mapping. Otherwise we must create an explicit mapping for each entity. For most ingestion, we attempt to be table-driven or metadata-driven so new entities can easily be added/removed via configuration data without requiring a new deployment. For now we can workaround using an explicit mapping data flow per entity. I just wanted to confirm that this was a current limitation before moving away from the dynamic approach.
@Anonymous - Yes, this looks like a current limitation and as Mark Kromer mentioned product team are looking to improve ways to allow schema changes in more dynamic way.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(243.2, 96%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAG%3C/text%3E%3C/svg%3E)
Hello, is it possible to use parameters in data source of type "Inline set Common Data Service" for settings of that service? I mean - its schema remais same, but I want to be capable to configure location of the CDM and all releant folders by parameters.