matquant14 opened a new issue, #1154:
URL: https://github.com/apache/arrow-adbc/issues/1154
I'm trying to run a very simple SQL command in snowflake to show the
warehouses available.
```
SHOW WAREHOUSES;
```
I can execute the command w/ a cursor without any problem. But, if I want
to fetch the data into a pandas dataframe, or say place into an arrow table to
then convert to a polars dataframe, then it raises an exception. Part of the
output from the SQL command has columns with timestamps. Looks like the cursor
is reading the timezone as being 'Local' so when trying to convert, it raises
an exception because there is no TimeZone called 'Local'
Code Example:
```
import polars as pl
import adbc_snowflake_driver.dbapi
from dotenv import load_dotenv
import os
load_dotenv('.env')
conn_kwargs={'account':os.environ['ACCOUNT'],...}
conn= adbc_snowflake_driver.dbapi.connect(db_kwargs=conn_kwargs)
cursor=conn.cursor()
sql="""SHOW WAREHOUSES;"""
cursor.execute(sql)
df = cursor.fetch_df()
# pytz.exceptions.UnknownTimeZoneError: 'Local'
# OR
tbl=cursor.fetcharrowall()
pl.from_arrow(tbl)
# ComputeError: unable to parse time zone: 'Local'
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
