title: How to merge variant column data from two different tables in snowflake
body: <p>I have two tables with around thousands of column each.Table contains variant data columns.I want to merge the variant data column based on key value in variant data.</p>
  
  <p>eg:</p>
  
  <p><strong>Table 1</strong> 
  column name: SRC
  value : {col1:val1,col2:val2,col3:val3}   </p>
  
  <p><strong>Table 2:</strong> 
  column name: SRC
  value : {col1:val1,col2:val2,col4:val4}                    </p>
  
  <p>I want output after merging :
  Table 1 :
  SRC = {col1:val1,col2:val2,col3:val3,col4:val4}</p>
  
  <p>I want existing keys in variant column to update and new keys to insert in table.</p>
  
  <p>I have tried it with <code>object_insert()</code> method but it can update a single field at a time and it is being hard to implement syntactically for thousand of columns.How to achieve this with multiple fields. 
  Can anyone help me on this?</p>