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!

  1. What version of Python are you using (python --version)? Python 3.8.1

  2. What operating system and processor architecture are you using (python -c 'import platform; print(platform.platform())')? Windows-10-10.0.17763-SP0

  3. What are the component versions in the environment (pip list)? Attached - requirements.txt requirements.txt

  4. 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())
  1. What did you expect to see? df head

  2. What did you see instead? Raised error: “snowflake.connector.errors.NotSupportedError: Unknown error” but query runs fine using SQLAlchemy & pd.read_sql() approach though.

  3. 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)

Most upvoted comments

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!