databend-py icon indicating copy to clipboard operation
databend-py copied to clipboard

Add option for databend connector to return values in client.execute() to native python datatypes. As of now retuning only string for all records.

Open gkllkg opened this issue 11 months ago • 1 comments

While returning data from databend connector we are getting data in string. could you please add an option to return value in native python datatpye based on data type defined in databend?

It will be good if we add this functionality : https://docs.snowflake.com/en/developer-guide/python-connector/python-connector-example#querying-data

gkllkg avatar Dec 31 '24 12:12 gkllkg

So while returning the values from an execute statement, we get a list of values. Here we observed that the values are almost all the time in the form of a string i.e., enclosed in single quotes, making it hard to process the data based on their data types. This was observed mainly for decimal(38, 0) types being stored as strings after retrieval.

anirudhsathya74 avatar Jan 02 '25 05:01 anirudhsathya74