so i was wondering if there is a possibility to infer data types for the mapping with a recursive method, instead of just looking at the first row. I will try to explain my usecase as detailed as possible:
I downloaded a Database as a json (Zendesk) and uploaded the json into a blob storage and now i want to use the json file as source for a table in azure sql database. The problem is some of the values in the first row/entry have null as value and thus i have to look into the data and search for an row/entry where that field is not null (empty) to determine the datatype and then manually map that data type in ADF. This is a tedious task since I have to push multiple tables to the azure sql as we are currently migrating in our company.
The only related and relevant threads i found are:
But this is currently not a viable solution. As im using the LinkedService (SQL Server) for all tables and dont even have a table in sql to map the linked service to.