snowflake-connector-python: SNOW-151365: fetch_pandas_all() not working - looks to be an issue with pyarrow from log
Please answer these questions before submitting your issue. Thanks!
-
What version of Python are you using (
python --version)? Python 3.8.1 -
What operating system and processor architecture are you using (
python -c 'import platform; print(platform.platform())')? Windows-10-10.0.17763-SP0 -
What are the component versions in the environment (
pip list)? Attached - requirements.txt requirements.txt -
What did you do?
import snowflake.connector
import pandas as pd
ctx = snowflake.connector.connect(
user='XXXX',
password='XXXX',
account='XXXX',
protocol='https')
# Create a cursor object.
cur = ctx.cursor()
# Execute a statement that will generate a result set.
sql = """
select *
from DATABASE.SCHEMA.TABLE
limit 10
"""
cur.execute(sql)
df = cur.fetch_pandas_all()
print(df.head())
-
What did you expect to see? df head
-
What did you see instead? Raised error: “snowflake.connector.errors.NotSupportedError: Unknown error” but query runs fine using SQLAlchemy & pd.read_sql() approach though.
-
Can you set logging to DEBUG and collect the logs? Attached logs - API.log API.log
About this issue
- Original URL
- State: closed
- Created 4 years ago
- Comments: 22 (3 by maintainers)
This issue is happening for me on the following setup Python - 3.9.6 Pandas - 1.2.5 Pyarrow - 3.0.0 snowflake-connector - 2.5.1
I am facing this issue on the following Windows setup
Python - 3.9.7 Pandas - 1.2.5 Pyarrow - 6.0.1 Snowflake Connector - 2.7.4
@hjvouch I had the same issue and I downgraded the Pyarrow dependency to 6.0.0 and it works
Hi @tomslade1 , we don’t support pyarrow on Windows 10 with Python 3.8 yet for this reason. Sorry for the inconvenience, we’re working on it!