skip to Main Content

How to read JSON in Snowflake?

Im converting a JSON file into columns, but this one column I'm not able to read it, it shows null not the value. CREATE OR REPLACE TEMPORARY TABLE SAMPLE_J ( SAMPLE_JSON VARCHAR(100) ); INSERT INTO SAMPLE_J (SAMPLE_JSON) VALUES ('{"ident":["Product:Tires","sender_id:12345","sender_name:John Who","Tire_Condition:New"]}'…

VIEW QUESTION
Back To Top
Search