I have a JSON Field in my PostgreSQL database with this format
![](https://uploads-us-west-2.insided.com/striim-en/attachment/3942e110-8bd1-4a00-8559-e3b243081403.png)
I want to take all the fields in this flat JSON structure and turn each of them into fields in a typed stream. How would I go about doing that? I tried using the ‘makeJSON’ function on the JSON string column but I’m unable to run JSONNode function on it.
![](https://uploads-us-west-2.insided.com/striim-en/attachment/c0b34e8b-c8bb-4c57-89d8-5921b8ba9709.png)
![](https://uploads-us-west-2.insided.com/striim-en/attachment/ba5429d2-746f-4bbd-aaf2-5f4f76662305.png)
Running the above query results in a ‘CRASH, cannot map’ exception.
Best answer by Sid
View original