Forum Discussion

bomme1's avatar
bomme1
Copper Contributor
Oct 17, 2024

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