Can we push unflatten JSON (API call) data through Matillion to Snowflake?
Hi @leelakrishnan
Thanks for your post, I spoke with my colleague who advised that you can store JSON in its general form within Snowflake as a variant data type. If you have a job in METL that is reading this JSON from a source it can traverse the job as is to the Snowflake target.
I hope that helps, please keep us posted.
Kind regards, Joe