I have a table available on redshift already, I am using that data from the table to create analysis, however there is one column called “Custom Fields” which contains String data as below example: {“site”:{“id”:“site”,“value”:“VCSCRI”,“type”:“String”},“training_manager”:{“id”:“training_manager”,“v…

Dataset query on Redshift cluster

aavugari February 29, 2024, 1:22pm 2

Hello this is solved.

I figured out that it is json, used the function - parsejson.

Thanks.