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

Add filter to get_column_values #582

Closed
epapineau opened this issue May 11, 2022 · 0 comments · Fixed by #583
Closed

Add filter to get_column_values #582

epapineau opened this issue May 11, 2022 · 0 comments · Fixed by #583
Labels
enhancement New feature or request triage

Comments

@epapineau
Copy link
Contributor

Describe the feature

Add an optional argument to the get_column_values macro that allows a where clause to be passed to the generated SQL.

Describe alternatives you've considered

The alternative is using run_query to get these values, but the docs state:

Here's an example of using this (though if you're using run_query to return the values of a column, check out the get_column_values macro in the dbt-utils package).

Additional context

No additional context comes to mind

Who will this benefit?

ME :) But also anyone trying to get a narrow list for cross-filtering models without a join.

Are you interested in contributing this feature?

Heck yea 😎

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request triage
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant