snowflakedb / snowflakedb/snowflake-connector-python
SNOW-778840: describe pandas result of query
Nobody has claimed this yet.
- Dominant language
- Python
- Stars
- 730
- Forks
- 574
- Avg merge
- 5h 45m
- Merged PRs (30d)
- 16
Description
What is the current behavior?
I can use describe to get a description of the results in terms of ResultMetadata. To figure out the pandas dtypes, I have to issue a query like SELECT * FROM X LIMIT 1 and then do fetch_pandas_all on the result.
What is the desired behavior?
I would like to get a description in terms of pandas dtypes, i.e. if I ran the query, which pandas dtypes would I get?
How would this improve snowflake-connector-python?
Can get metadata of a table in pandas terms without executing a query
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start with the connector's describe and fetch_pandas_all entry points, comparing ResultMetadata with the pandas dtypes produced by the current sample-query approach. The payload names no implementation file or test; done means callers can obtain the expected pandas dtype information from metadata without executing the query.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- pandas, python, sql
- Domain
- api, database
- Issue type
- Feature
- Difficulty
- 5/5
- Estimated time
- Over a week
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 30/100