Loading JSON to Snowflake
Hi,
Been trying to load json data into VARIANT data field in Snowflake. I want to avoid writing externally like an S3 bucket and then doing a bulk upload. I prefer to do it straight load to Snowfla...
Forum Discussion
You can push a JSON object into a Snowflake Variant datatype by first formatting it using JSON.stringify($json_object) in a Mapper expression.
4 years now after this post, this trick helped me to solve this problem after 2 weeks losing my hair on that 😂
