VARIANT – Snowflake Guide

How to Merge Variant columns in Snowflake

Posted on 31 August 202231 August 2022 by Eric Lin

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. […]

JavaScript UDF fails with error: TIME inside VARIANT value – not supported

Posted on 24 May 202124 May 2021 by Eric Lin

When running Javascript UDF with VARIANT data type passed into it as parameter, it fails with error: TIME inside VARIANT value – not supported This issue can be reproduced using below steps: And the last SELECT statement will fail with above mentioned error. This is because Javascript does not support the TIME data type, as […]