Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Snowflake does not enforce uniqueness of PRIMARY KEY by default #10737

Open
radeusgd opened this issue Aug 2, 2024 · 0 comments
Open

Snowflake does not enforce uniqueness of PRIMARY KEY by default #10737

radeusgd opened this issue Aug 2, 2024 · 0 comments
Labels
-libs Libraries: New libraries to be implemented l-db-connector Libraries: database connectors

Comments

@radeusgd
Copy link
Member

radeusgd commented Aug 2, 2024

Like in the title - for 'Standard' tables, Snowflake does not enforce uniqueness of the primary key.

One can make it enforce it by creating a HYBRID table.

Some of our Upload_Spec tests rely on the PRIMARY KEY uniqueness. We should try adapting them to run the tests on HYBRID tables to actually correctly test this.

Also review if any other operations (like Lookup) do not rely in some ways on the uniqueness.

@radeusgd radeusgd added -libs Libraries: New libraries to be implemented l-db-connector Libraries: database connectors labels Aug 2, 2024
@radeusgd radeusgd self-assigned this Aug 2, 2024
@github-project-automation github-project-automation bot moved this to ❓New in Issues Board Aug 2, 2024
radeusgd added a commit that referenced this issue Aug 2, 2024
@jdunkerley jdunkerley moved this from 📤 Backlog to ❓New in Issues Board Aug 22, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
-libs Libraries: New libraries to be implemented l-db-connector Libraries: database connectors
Projects
Status: New
Development

No branches or pull requests

1 participant