Fetching data with snowflake connector throws EmptyPyArrowIterator error

You have to install pyarrow module via

pip3 install pyarrow

Installation of the snowflake connector does not automatically install it.


Short version: Roll back your snowflake-connector-python to version 2.0.4 by running: pipenv install "snowflake-connector-python~=2.0.4"

Long version: I checked the commits to the github for the connector, and I saw that they're adding ARROW support. Not sure exactly why arrow_result.pyx is unable to include EmptyPyArrowIterator, but it's wrapped in a try, so it still executes. However, when it gets to the reset function, it can't find the reference and throws an exception.


Please use the Python connector version 2.1.1

pip install snowflake-connector-python==2.1.1

OR

pip3 install snowflake-connector-python==2.1.1

Tags:

Python

Snowflake Cloud Data Platform

Related

Why does this code give a "Possible null reference return" compiler warning? C++ - Does resetting stringstream not reset the get position or clear flags? How to upgrade all solution projects .Net framework 4.5.1 to 4.8 Visual Studio 2019 Why does a single number fail to match a Range object in an array? "Error: Too many re-renders. React limits the number of renders to prevent an infinite loop." inheritFromWidgetOfExactType is deprecated use dependOnInheritedWidgetOfExactType instead What is the reason for difference between integer division and float to int conversion in python? Maximize the MSE of a keras model Flutter: Error: Getter not found: 'suspending'. case AppLifecycleState.suspending Unpack value(s) into variable(s) or None (ValueError: not enough values to unpack) JavaScript array re structure Why copy an event handler into another variable

Recent Posts