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

[CT-2222] [Redshift] Add model-level constraints to get_columns_spec_ddl #343

Closed
Tracked by #6747
MichelleArk opened this issue Feb 28, 2023 · 0 comments · Fixed by #395
Closed
Tracked by #6747

[CT-2222] [Redshift] Add model-level constraints to get_columns_spec_ddl #343

MichelleArk opened this issue Feb 28, 2023 · 0 comments · Fixed by #395
Assignees

Comments

@MichelleArk
Copy link
Contributor

Core issue: dbt-labs/dbt-core#6754

Redshift supports not_null, primary_key, foreigh_key, and unique constraints

constraint type support
not_null enforced
primary_key not enforced
foreign_key not enforced
unique not enforced
check not supported

constraints specified at the model-level should be rendered to the column spec ddl after column-level constraints are rendered: https://github.com/dbt-labs/dbt-redshift/blob/main/dbt/include/redshift/macros/utils/get_columns_spec_ddl.sql#L35

Constraint docs: https://docs.aws.amazon.com/redshift/latest/dg/r_CREATE_TABLE_NEW.html

@github-actions github-actions bot changed the title [Redshift] Add model-level constraints to get_columns_spec_ddl [CT-2222] [Redshift] Add model-level constraints to get_columns_spec_ddl Feb 28, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants