I want to map nested json to sql table (Microsoft SSMS)
Source is a Dataset of MongoAtlas & Sink is a Dataset of Azure SQL Database Managed Instance
I am able to map parentArray using collection reference. but not able to select child under it. also childArrays are kind of scalar arrays (they don't have any keys)
Note : I tried the option Map complex values to string but it is putting the values in column cell like ["ABC", PQR] which I dont want is there any way to map it ?