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.

Sign up for GitHub

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

Jump to bottom

support for specific where clauses for each relation in the union_relations macro #895

Closed
thisismath opened this issue May 22, 2024 · 2 comments · May be fixed by #897
Closed

support for specific where clauses for each relation in the union_relations macro #895

thisismath opened this issue May 22, 2024 · 2 comments · May be fixed by #897
Labels
enhancement New feature or request Stale triage

Comments

@thisismath
Copy link

thisismath commented May 22, 2024 •
edited
Loading

Describe the feature

currently the union_relations macro uses the provided where clause for all relations passed to it. In some cases, this approach is not ideal. Support for specific where clauses for each relation would allow for more flexibility in the way the macro can be deployed

Describe alternatives you've considered

CTEs would be an alternative but union_relations only takes models as inputs

Who will this benefit?

An example use case: Supports unioning differing periods together

Are you interested in contributing this feature?

sure
@thisismath thisismath added enhancement New feature or request triage labels May 22, 2024
@thisismath thisismath mentioned this issue May 23, 2024
Open
17 tasks
@github-actions GitHub Actions
Copy link

This issue has been marked as Stale because it has been open for 180 days with no activity. If you would like the issue to remain open, please comment on the issue or else it will be closed in 7 days.

@github-actions github-actions bot added the Stale label Nov 19, 2024
@github-actions GitHub Actions
Copy link

Although we are closing this issue as stale, it's not gone forever. Issues can be reopened if there is renewed community interest. Just add a comment to notify the maintainers.

@github-actions github-actions bot closed this as not planned Won't fix, can't repro, duplicate, stale Nov 26, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
enhancement New feature or request Stale triage
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

support for unique where clauses for each relation passed to union_relations thisismath/dbt-utils
1 participant
@thisismath