Support Questions

Find answers, ask questions, and share your expertise
Welcome to the upgraded Community! Read this blog to see What’s New!

Insert Json Data Into snowflake.

New Contributor

Hi, People. I need to insert the json data which is listen by ListenHttp processor. As of now I am using ExtractText Processor to concat all the json key and value into one string and inserting to table and later doing parse json in snowflake table. But I want insert the Json string to table having two columns(ID, Column1), The issue i am facing is I am not able to insert the json string(concatenated) into a table have two columns. But I am able to insert to a table which has only one column(column1). But I want two columns in table with (ID, Column1) as it is easy to handle data. This is the INSERT statement i am using in putsql, INSERT INTO EMPLOYEE_SCHEMA.TEST4 (COLUMN1) values ('${JsonRecord}'), The is the flow i am using. Any suggestion will be appreciated