How to Merge Variant columns in Snowflake
Currently, Snowflake does not have a native function to merge JSON data type, the workaround is to continuously use the OBJECT_INSERT, which can have performance implications. Please see the example below: Table setup In order to add more properties, we have to use the OBJECT_INSERT: You can see how cumbersome it is to do so. […]