I trying to pull some data from Snowflake and the query returns multiple records with each record being a simple array and the returned columns also being a simple array.
I can’t share an example as it’s company data but I’ll try to fake an example:
{
"resultSetMetaData" : {...},
"data" : [
0 : [
0 : <order number>
1 : <part number>
2 : <description>
...
],
1 : [
0 : <order number>
1 : <part number>
2 : <description>
...
],
2 : [...]
]
]
}
The Tulip connector function interface really only seems to support object arrays, not simple arrays.
This kind of works but only returns data for the first record: