SNOW-757724: Ability to change the encoding while reading the data from Snowflake

[salmanea]

What is the current behavior?

Currently, we can do df = conn.cursor().execute("""Query""").fetch_pandas_all() with conn being the snowflake.connector.connect()

What is the desired behavior?

The desired behavior is to have an argument where one can determine/change the encoding of the data that is stored in the resulting pd.DataFrame

How would this improve snowflake-connector-python?

Similar to pd.read_csv(encoding=) this makes it easier for users to determine/change the encoding of the data.

References, Other Background

[sfc-gh-aling]

thanks for the feedback, I'm not familiar with not pd.DataFrame encoding. can you help explain a bit more about your scenario?, like what does your data look like (bytes?) and what do you expect the encoding to do within the pd.Dataframe?

[salmanea]

It's about understanding the different character encodings. For example, in the data, there are names that have German special characters. When you read csv with pd.read_csv() you can pass the encoding it is supposed to use when reading the data. My request is that it would be great if we can have the same feature when reading data from Snowflake.