Forum Discussion
bomme1
Oct 17, 2024Copper Contributor
Column in Common Data Model source always returning null values in ADF
I have a pipeline in ADF where I am fetching data from a Common Data Model (CDM) and this pipeline has been working fine for a long time. We updated one of the Entities in the CDM with a new column of type string which I am now trying to fetch. When I import the new schema into ADF Source I find the new column but all data fetched for that column only returns null.
I have confirmed the following:
- All other columns are working as before and returns data.
- The CSV file referred to by the CDM has values that are not null in the new column, so data exists.
- Data type in the schema matches the data type specified in the CDM for the new column (string)
Does anyone have an idea of what could be the issue?
I saw this post with similar issue but the data type in that case is date: https://learn.microsoft.com/en-us/answers/questions/942876/column-is-always-getting-null-values-in-adf-data-f
No RepliesBe the first to reply