Hi SAM, Actually it worked for me now. No error now. Thank you for your help.  ... View more

Hi SAM, Thank you for response. I am facing one more error, while inserting data into table. Even though i have tables named test4 in my snowflake table, The PUTSQL processor keep telling "The Table 'test4' doesn't exist or not Authorized(I did give permission too). This is my sql statement(INSERT INTO test4 (JSON_DATA) values ('${JsonRecord}').  Any help will be appreciated.  ... View more

Hi, SAM. Thank you for response. I am using ListenHTTP to get json data-->ConvertRecord(to validate json) -->SplitJson(to split)-->Now I have individial Json Objects. Now I have concatenate all the keys and values of each json object and insert to a table have single column called JSON_DATA.   This is my input data,  [ {"Name":"Joh ","Age": 2,"Occupation":"Developer",      "Location": "New York","Salary": 75780}, {"Name": "Ja","Age": 9,"Occupation": "Designer",        "Location": "San Francisco","Salary": 87800}, {"Name": "Bb kkkk","Age": 5,"Occupation": "Manager",        "Location": "London","Salary": 90870} ]...I want insert each json obj inot each new row as string like this in a snowflake table   ' {"Name":"Joh ","Age": 2,"Occupation":"Developer",      "Location": "New York","Salary": 75780} '  ... View more