JSON Column in Table not mapping correctly to flex table
mc123
✭
Hi all,
I have a varchar column in one of my regular tables that has json data like so:
{"user"=>"x","newPortfolio"=>"false","tickers_added"=>"["BRK.A", "BA", "MORN", "VITSX"]","tickers_already_in_portfolio"=>"[]","rta"=>"true"}
I called this column "try".
I created a Flex Table (dwh.try_flex), and then copied "try" into the Flex Table:
INSERT INTO dwh.try_flex SELECT try FROM temp_table;
The problem I'm running into is that "try" is now my Key, and the values is the JSON string in the try column.
How can I parse the json from the try column into the flex table properly?
Tagged:
0