Hi @HAlblas ,

if the structure of the json inside the column is the same for all records and you are loading this through CData you can easily decompose the JSON. If the structure is more varied it will involve .rsd scripting.

If the data does not come in through CData but is simply JSON inside SQL, you can use SQL Server's JSON data capabilities: https://learn.microsoft.com/en-us/sql/relational-databases/json/json-data-sql-server?view=sql-server-ver16

Hi @HAlblas does Rory’s comment above answer your question? If so please help us by marking the best answer above. Please let us know if you have any follow up questions

Please also see the below post which might be relevant:

Dear Christian Hauggaard, I indeed saw your post in the community. Ultimately this will be the best solution. Thanks for your responses.