Implement options for additional table clauses in the DDL compiler
Nobody has claimed this yet.
Assessment
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Newbie friendliness
- 52/100
Research direction
Start with src/databricks/sqlalchemy/_ddl.py and the post_create_table method, then compare its generated CREATE TABLE SQL with the Databricks CREATE TABLE USING clauses listed in the issue. Define which clauses should be exposed through the dialect and verify that LOCATION and the other supported clauses appear correctly in generated DDL.
Written by the indexing model from the issue text.
Description
I would like to create a table with SQL Alchemy that specifies a LOCATION table clause on CREATE - but there is currently no implementation of that in the post_create_table method.
It would be good to have all of the table clauses listed here made available through the dialect. I currently have a work around for this thanks to the help of the maintainer of SQLAlchemy in this discussion here: https://github.com/sqlalchemy/sqlalchemy/discussions/12188. Hopefully this helps get started?
Do you have a roadmap expanding the features available in the dialect? And do you accept PRs outside of the designated maintainers?
- Dominant language
- Python
- Stars
- 24
- Forks
- 18
- PR merge metrics
- No merged PRs in 30d
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.
More from databricks/databricks-sqlalchemy
-
Difficulty 1/5 Under an hour Newbie friendliness 92/100
-
Difficulty 1/5 Under an hour Newbie friendliness 90/100
-
Difficulty 2/5 1-3 hours Newbie friendliness 70/100
-
Difficulty 4/5 3-5 days Newbie friendliness 48/100
databricks/databricks-sqlalchemy#73 · 1 comment ·
-
Difficulty 5/5 Over a week Newbie friendliness 35/100
All issues in databricks/databricks-sqlalchemy
Similar issues
-
Difficulty 2/5 1-3 hours Newbie friendliness 75/100
anthropics/skills#1811 · 1 comment ·
-
Difficulty 2/5 1-3 hours Newbie friendliness 75/100
speaches-ai/speaches#678 ·
-
bug
Difficulty 2/5 1-3 hours Newbie friendliness 75/100
datalayer/mcp-compose#42 ·
-
Difficulty 2/5 1-3 hours Newbie friendliness 75/100
conda-forge/spacy-feedstock#177 ·
-
Difficulty 2/5 1-3 hours Newbie friendliness 70/100
UKGovernmentBEIS/inspect_evals#2523 ·