how to compare two json data in snowflake

how to compare two json data in snowflake if 2nd json has more key then insert that key and their corresponding value in first json and if 2nd json has less key and value then delete unmatch key and value from 1st json in snowflake

How many English words
do you know?
Test your English vocabulary size, and measure
how many words do you know
Online Test
Powered by Examplum