
I'm using the new, still in preview, connector for Snowflake.
I am executing the statement that should be returning over 7K records, but I'm only getting back 3K. Looks like it s chunking the data and only processing the first chunk. Any idea how to get the rest of the data picked up?
Using Snowflake Check the Status and Get Results and doing it as a partition gets the job done to return the next chunk, but if it's a large dataset to run that action for multiple chunks doesn't seem like a manageable scaling solution.
Also running into an issue with the returned results returning the data but not the data type to be able to convert it into consumable data to push to dataverse.