Hi I am reading the value from cosmos and moving to SQl and since it is complex and unstructured we need to move that part of json from cosmos as nvarchar (max) in sql.

I connected to Cosmos and casted in derived column as string.

Derived Columns setting

However, While adding in SINK as SQL ,I am getting error “Referencing is only allowed on structure types or array of structure types”

Any suggestion how can I move Object type(Complex Json) as Nvarchar(max) for sql