As the native Snowflake connector only supports Basic Authentication, I was attempting to re-create the functionality of the Insert Bulk block for the native connector with in the Oauth2 Raw API Request block.
Can anyone provide some insight on how that Insert Bulk block transforms a list of JSON objects into a SQL statement?
Currently, I have something like this but I keep ending up with a syntax error.
INSERT INTO <TABLE> ({implode: { getkeys: {$.vList} }}) values {implode: {$.vList2}};
vList2 is a variable set by looping over the values in the original vList variable being imploded so I can group the values for each record.
