dbt-labs/dbt-utils

View on GitHub

Utility functions for dbt projects.

Stars: 1.8k
Forks: 632
Open beginner issues: 0
Indexed issues: 64

Dominant language: Makefile
License: Apache-2.0
Last GitHub push: Sep 1, 2026
Latest indexed: Sep 15, 2026
Contributing guide: Contributing guide
Code of conduct: No code of conduct
Beginner labels: No beginner labels indexed
PR merge metrics: No merged PRs in 30d

Open All

64 open issues indexed

union should explicitly specify table name in casts Open

bug nested Stale

dbt-labs/dbt-utils#173 · 11 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Parameterize union_relations macro to support deduplication with UNION Open

enhancement Stale triage

dbt-labs/dbt-utils#816 · 7 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
union_relations macro unable to union relations with ARRAY on Postgres Open

bug triage

dbt-labs/dbt-utils#857 · 10 comments · 3 reactions · 0 assignees · Indexed Sep 15, 2026
not_accepted_values test didn'd work with fail_calc: "sum(n_records)" config Open

Stale

dbt-labs/dbt-utils#860 · 5 comments · 1 reaction · 0 assignees · Indexed Sep 15, 2026
Support streaming tables in macro databricks get_table_types_sql() Open

bug triage

dbt-labs/dbt-utils#861 · 4 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
[Bug] dbt_utils.date_spine gives Python error Open

bug Stale triage

dbt-labs/dbt-utils#873 · 7 comments · 2 reactions · 0 assignees · Indexed Sep 15, 2026
add description tag to test definition Open

enhancement triage

dbt-labs/dbt-utils#882 · 4 comments · 2 reactions · 0 assignees · Indexed Sep 15, 2026
Quoting of database name appears to be broken in get_tables_by_pattern_sql Open

bug

dbt-labs/dbt-utils#900 · 5 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Improve the documentation for dispatch macros Open

documentation Stale

dbt-labs/dbt-utils#918 · 2 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Union Relations compilation doesn't include all columns Open

bug Stale triage

dbt-labs/dbt-utils#953 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 15, 2026
union_relations guesses data types incorrectly so database fails Open

bug triage

dbt-labs/dbt-utils#957 · 3 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
PostgreSQL - Working with Materialised Views Open

bug Stale triage

dbt-labs/dbt-utils#958 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 15, 2026
`dbt_utils.star`: Remove trailing whitespace in the comment when no column is returned Open

bug triage

dbt-labs/dbt-utils#959 · 2 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Add a new macro to cast all columns based on data types in YAML Open

enhancement triage

dbt-labs/dbt-utils#965 · 1 comment · 3 reactions · 0 assignees · Indexed Sep 15, 2026
`get_relations_by_pattern` does not build downstream tables Open

bug Stale triage

dbt-labs/dbt-utils#966 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Fabric: generate_source doesn't work due to get_tables_by_pattern_sql Open

bug Stale triage

dbt-labs/dbt-utils#968 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 15, 2026
dbt_utils.get_column_values returns error when "values" is a reserved word Open

bug triage

dbt-labs/dbt-utils#972 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
dbt_utils.equal_rowcount error when comparing tables with 0 rows Open

bug triage

dbt-labs/dbt-utils#973 · 2 comments · 2 reactions · 0 assignees · Indexed Sep 15, 2026
not_null_proportion.sql cannot hanlde function in group_by_columns Open

bug triage

dbt-labs/dbt-utils#977 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 15, 2026
dbt_utils.unique_combination_of_columns test produces false failures in Redshift Open

bug triage

dbt-labs/dbt-utils#979 · 0 comments · 1 reaction · 0 assignees · Indexed Sep 15, 2026
`dbt_utils.get_url_parameter` will incorrectly match fields if they end with url_parameter Open

bug triage

dbt-labs/dbt-utils#980 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
`mutually_exclusive_ranges` Test Fails for Duplicated Zero-Length Ranges Open

bug triage

dbt-labs/dbt-utils#981 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
No option for quoting in equality test? Open

bug triage

dbt-labs/dbt-utils#985 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
equal_rowcount pass the test when comparing 2 different tables of the same groupby columns Open

bug triage

dbt-labs/dbt-utils#986 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Functional Dependency Test Macro Open

enhancement triage

dbt-labs/dbt-utils#989 · 5 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Add CTE as a valid option to a star() macro Open

enhancement triage

dbt-labs/dbt-utils#996 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 15, 2026
[Bug] dbt run `--empty` tag doesn't work with `dbt_utils.get_column_values()` Open

bug triage

dbt-labs/dbt-utils#1009 · 10 comments · 2 reactions · 0 assignees · Indexed Sep 15, 2026
uniqueness constraint on fact_claims is broken Open

bug triage

dbt-labs/dbt-utils#999 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Allow setting different compare_columns for each table/model in equality generic test Open

enhancement triage

dbt-labs/dbt-utils#1000 · 2 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
generate_surrogate_key() macro has different results in different databases for timestamp columns Open

bug triage

dbt-labs/dbt-utils#1004 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
mutually_exclusive_ranges.sql does not work in Teradata Open

bug triage

dbt-labs/dbt-utils#1005 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
document macro argument names and types in yml Open

enhancement triage

dbt-labs/dbt-utils#1008 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Macros to encode/decode URL Open

enhancement triage

dbt-labs/dbt-utils#1013 · 0 comments · 12 reactions · 0 assignees · Indexed Sep 15, 2026
get_url_parameter not taking the good parameter filled in url_parameter Open

bug triage

dbt-labs/dbt-utils#1014 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Selecting custom field delimiter in generate_surrogate_key Open

enhancement triage

dbt-labs/dbt-utils#1015 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
generate_surrogate_key macro fails for boolean types in Redshift Open

bug triage

dbt-labs/dbt-utils#1016 · 1 comment · 1 reaction · 0 assignees · Indexed Sep 15, 2026
union_relations: passing `include` parameter makes column_override fields case sensitive in data types quietly Open

bug Stale triage

dbt-labs/dbt-utils#1017 · 2 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Add functional_dependency test (PR included) Open

enhancement Stale triage

dbt-labs/dbt-utils#1020 · 2 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
dbt run fails for microbatch strategy with dbt_utils.star() Open

bug Stale triage

dbt-labs/dbt-utils#1025 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 15, 2026
expression_is_true tests for not-false: should test for true Open

dbt-labs/dbt-utils#1026 · 5 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Union Relations - Can we use UNION BY NAME? Open

enhancement Stale triage

dbt-labs/dbt-utils#1028 · 1 comment · 1 reaction · 0 assignees · Indexed Sep 15, 2026
Warning messages dbt package macros like generate_surrogate_key.sql, get_relation.sql, upload_exposures.sql etc Open

bug Stale triage

dbt-labs/dbt-utils#1029 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Union Relations - Make it work with external tables Open

enhancement Stale triage

dbt-labs/dbt-utils#1031 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Enhance get_relations_by_pattern macro for Snowflake users to allow escape characters in pattern params Open

enhancement Stale triage

dbt-labs/dbt-utils#1033 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 15, 2026
All examples use deprecated functionality Open

enhancement triage

dbt-labs/dbt-utils#1034 · 2 comments · 8 reactions · 0 assignees · Indexed Sep 15, 2026
Add a new macro - get_columns_by_pattern Open

enhancement Stale triage

dbt-labs/dbt-utils#1037 · 1 comment · 4 reactions · 0 assignees · Indexed Sep 15, 2026
[Docs/Contributing] Clarify "target" variable usage in Makefile (adapter selection) Open

Stale

dbt-labs/dbt-utils#1038 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Support dbt-athena adapter Open

enhancement Stale triage

dbt-labs/dbt-utils#1042 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Unable to install dbt-utils package inside Snowsight Workspace Open

bug triage

dbt-labs/dbt-utils#1046 · 2 comments · 1 reaction · 0 assignees · Indexed Sep 15, 2026
Add is_null generic data test to test for null values Open

enhancement Stale triage

dbt-labs/dbt-utils#1047 · 3 comments · 2 reactions · 0 assignees · Indexed Sep 15, 2026

dbt-labs/dbt-utils

Get new issues in your inbox