snowflakedb / snowflakedb/snowpark-python
SNOW-668693: Create_dataframe add quote_identifiers option
Nobody has claimed this yet.
- Dominant language
- Python
- Stars
- 341
- Forks
- 155
- Avg merge
- 4d 16h
- Merged PRs (30d)
- 27
Description
What is the current behavior?
Currently session.create_dataframe forces quoted identifiers when creating a snowpark dataframe from a pandas dataframe.
There is no option to remove quoted identifiers.
What is the desired behavior?
I would like to be able to use session.create_dataframe(.... quote_identifiers = False) to create temp tables with easy to use column names.
How would this improve snowflake-snowpark-python?
Under the hood this utilizes write_pandas functionality which allows you to specify quote_identifiers=True/False. Adding this functionality to create_dataframe would keep our api consistent.
References, Other Background
I am happy to submit this as a pr. Wanted to open a discussion first.
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 at the session.create_dataframe entry point and trace how pandas data is passed through the write_pandas functionality, especially the existing quote_identifiers behavior. Done means accepting quote_identifiers=False while preserving the current default and producing temporary tables with unquoted column identifiers.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- pandas, python
- Domain
- api, data-engineering
- Issue type
- Feature
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100