To work around this issue, you can add a Derived Column transformation in the Copy Data activity to explicitly handle these NULL
values before the data is written to the sink. Unfortunately, as you've mentioned, ADF Data Flows do not directly support Azure Table Storage as a source. However, you can use a combination of ADF activities to achieve the desired transformation.
Develop an Azure Function or Azure Logic App to read data from Azure Table Storage and replace NULL
date fields with a specific placeholder (like '1970-01-01'
or another invalid date that you can later identify and replace with NULL
in the sink).
Then , add an HTTP activity in your ADF pipeline to call the Azure Function/Logic App, which processes the data and returns it in a suitable format.
Use the output from the Azure Function/Logic App as the source in your Copy Data activity.