0
votes

I want to map nested json to sql table (Microsoft SSMS) enter image description here

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 ?