snowflakedb / snowflakedb/snowflake-connector-python
SNOW-687932: Using Temporary tables after write_pandas
Open
Nobody has claimed this yet.
feature
status-triage_done
triaged
- Dominant language
- Python
- Stars
- 730
- Forks
- 574
- Avg merge
- 5h 45m
- Merged PRs (30d)
- 16
Description
What is the current behavior?
When using write_pandas the cursor is closed afterwards regardless of table type
What is the desired behavior?
When table type is temp or temporary cursor should be left open so the temp table can be used after table creation
How would this improve snowflake-connector-python?
Would allow for use of temp tables in other sql queries such as using the temp table in a merge query
References, Other Background
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 write_pandas entry point and trace how the cursor is closed after table creation. Check the handling of temp and temporary table types, then verify that the cursor remains usable for a subsequent query or merge involving the temporary table.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- python, sql
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100