Snowflake column name case-sensitive
Nobody has claimed this yet.
Assessment
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Newbie friendliness
- 45/100
Research direction
Start in src/datajudge/db_access.py around line 346, where Snowflake column-name capitalization is normalized. Reproduce the KeyError with the quoted "ALTER" column and the add_uniques_equality_constraint call. Done means the constraint test runs without a KeyError while preserving the schema's case-sensitive column name.
Written by the indexing model from the issue text.
Description
I am trying to specify constraints for a Snowflake table with a schema that includes a column named "ALTER". After adding an add_uniques_equality_constraint constraint, testing the code results in a KeyError: 'alter' error.
Steps to Reproduce
- Create a Snowflake table with the following schema:
create or replace TABLE EXAMPLE (
JAHR FLOAT,
"ALTER" FLOAT
);
- Add a
add_uniques_equality_constraintconstraint:
requirement.add_uniques_equality_constraint(
["ALTER"], list(range(0, 100 + 1))
)
- Test the constraints
Expected Behavior
The code should run without errors.
Actual Behavior
Running the code results in a KeyError: 'alter' error.
Root Cause
The issue is caused by the Snowflake capitalization fix (https://github.com/Quantco/datajudge/blob/main/src/datajudge/db_access.py#L346). This fix forces the column name to be lowercase, which interferes with the case-sensitive "ALTER" column name in the table schema.
- Dominant language
- Python
- Stars
- 46
- Forks
- 3
- PR merge metrics
- No merged PRs in 30d
Contributor guide
No contributing guide indexed for this repository
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 Quantco/datajudge
-
Difficulty 2/5 1-3 hours Newbie friendliness 62/100
-
enhancement help wanted
Difficulty 5/5 Over a week Newbie friendliness 25/100
-
good first issue refactoring
Difficulty 3/5 1-2 days Newbie friendliness 48/100
-
Difficulty 4/5 3-5 days Newbie friendliness 35/100
-
infrastructure
Difficulty 1/5 Under an hour Newbie friendliness 55/100
All issues in Quantco/datajudge
Similar issues
-
area/auth bug comp/agent P3 platform/discord type/security
Difficulty 2/5 1-3 hours Newbie friendliness 88/100
NousResearch/hermes-agent#117848 ·
-
Difficulty 2/5 1-3 hours Newbie friendliness 74/100
bancolombia/sentinel#23 ·
-
test md OpenCI
Difficulty 2/5 1-3 hours Newbie friendliness 74/100
-
integration:quickjs org:external priority:backlog topic:code-interpreter topic:middleware type:feature
Difficulty 2/5 1-3 hours Newbie friendliness 74/100
langchain-ai/deepagents#6450 ·
-
bug client
Difficulty 2/5 1-3 hours Newbie friendliness 88/100