github.com/dbt-labs/dbt-utils issues | Ecosyste.ms: OpenCollective

not_null_proportion.sql cannot hanlde function in group_by_columns

chaubilly opened this issue 6 days ago

Update not_null_proportion.sql to handle function in group_by_columns

chaubilly opened this pull request 6 days ago

[Cosmetic Change] Minor correction to readme.md for better macros hierarchy

asarraf opened this pull request 10 days ago

Fix: return 0 in `equal_rowcount` when both models have 0 rows

i-125 opened this pull request 11 days ago

dbt_utils.equal_rowcount error when comparing tables with 0 rows

i-125 opened this issue 11 days ago

dbt_utils.get_column_values returns error when "values" is a reserved word

rfeith2 opened this issue 24 days ago

Use pull_request_target trigger for CI

emmyoop opened this issue 30 days ago

Trigger CI off `pull_request_target` so workflow runs in the context of the base branch

emmyoop opened this pull request 30 days ago

dbt_utils.get_filtered_columns_in_relation has inconsistent type between parsing and runtime

cvm-a opened this issue about 1 month ago

Fabric: generate_source doesn't work due to get_tables_by_pattern_sql

boxysean opened this issue about 1 month ago

chore/apply 717530c

tconbeer opened this pull request about 1 month ago

`get_relations_by_pattern` does not build downstream tables

jeremy-thomas-roc opened this issue about 1 month ago

Add a new macro to cast all columns based on data types in YAML

b-per opened this issue about 2 months ago

feat(nulltest): add not_null option to unique_combination_of_columns.sql

halfos opened this pull request about 2 months ago

feat(nulltest): add not_null option to unique_combination_of_columns

halfos opened this issue about 2 months ago

Replace hyperlink for using a SQL expression in a data test

dbeatty10 opened this pull request about 2 months ago

Add documentation and usage example for ignore_time_component

amishas157 opened this pull request 2 months ago

`dbt_utils.star`: Remove trailing whitespace in the comment when no column is returned

mcasara opened this pull request 2 months ago

`dbt_utils.star`: Remove trailing whitespace in the comment when no column is returned

mcasara opened this issue 2 months ago

PostgreSQL - Working with Materialised Views

moseleyi opened this issue 3 months ago

union_relations guesses data types incorrectly so database fails

EugenioGastelumGBR opened this issue 3 months ago

Update get_table_types_sql.sql

lachlanclulow opened this pull request 3 months ago

`get_relations_by_pattern` macro fails for`clone` tables in BigQuery

lachlanclulow opened this issue 3 months ago

TESTING

emmyoop opened this pull request 3 months ago

Union Relations compilation doesn't include all columns

moseleyi opened this issue 3 months ago

`dbt_utils.not_null_proportion` does not work with clickhouse

camerondavison opened this issue 4 months ago

Equality test causes failures in docs generate if model hasn't been built

glsdown opened this issue 4 months ago

Unable to install dbt-utils

pranjalbhatt opened this issue 4 months ago

Convert tox tests to central workflow

emmyoop opened this pull request 4 months ago

Alias column selection in group_by_columns to enable timestamp wrapping

macklin-fluehr opened this issue 4 months ago

Create/update a macro to verify sum of row counts of n relations

aranke opened this issue 5 months ago

BigQuery `deduplicate` macro doesn't support downstream partition pruning

austinclooney opened this issue 6 months ago

Warnings in CI about not finding matching node

dbeatty10 opened this issue 6 months ago

Improve the documentation for dispatch macros

dbeatty10 opened this issue 7 months ago

Remove "I have added an entry to CHANGELOG.md" from the PR template

dbeatty10 opened this issue 7 months ago

Quoting of database name appears to be broken in get_tables_by_pattern_sql

skion opened this issue 7 months ago

support for unique where clauses for each relation passed to union_relations

thisismath opened this pull request 8 months ago

When using `--empty`, `adapter.get_columns_in_relation()` returns an error

zeev-finaloop opened this issue 8 months ago

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

thisismath opened this issue 8 months ago

feat: add callable where clause in union_relations

tnightengale opened this pull request 8 months ago

Support for other Databases

xpegenaute opened this issue 8 months ago

`dbt run-operation` command as documentation

mik-laj opened this issue 8 months ago

Re-enable auto-generation of table of contents (TOC)

dbeatty10 opened this issue 8 months ago

get_url_parameter does not work for small parameters that are included in other params

Stephen986 opened this issue 9 months ago

add description tag to test definition

maares opened this issue 9 months ago

Resolve support for Materialized views on databricks in dbt_utils.get_table_types_sql

SLe-Corre opened this issue 9 months ago

`pivot` macro `quote_identifiers` not working

Ishankoradia opened this issue 9 months ago

run_query macro throws syntax error with each example I try

vincentclaes opened this issue 10 months ago

get_tables_by_pattern_sql, ilike doesn't work with SQL Server

craiha opened this issue 10 months ago

[Bug] `not_null_proportion` uses `cast(count(*) as numeric)`, which is sometimes expected to evaluate to `null` when using the `dbt-databricks` adapter

garfieldthesam opened this issue 10 months ago

[Bug] dbt_utils.date_spine gives Python error

hazvk opened this issue 10 months ago

make column name to be fully qualified to prevent BQ confusion

adrian3ka opened this pull request 12 months ago

include streaming_table and fix materialized_view in databricks__get_table_types_sql()

w0ut0 opened this pull request almost 1 year ago

Support streaming tables in macro databricks get_table_types_sql()

w0ut0 opened this issue almost 1 year ago

not_accepted_values test didn'd work with fail_calc: "sum(n_records)" config

La1x opened this issue about 1 year ago

union_relations macro unable to union relations with ARRAY on Postgres

pcreux opened this issue about 1 year ago

`union_relations` macro unable to union relations that have apostrophe/single quote in relation name

agyemangg-accelins opened this issue about 1 year ago

ENHANCEMENT: dbt-utils should not allow `GROUP BY` clauses that reference column aliases

dataders opened this issue about 1 year ago

Test Descriptions

madarez opened this issue over 1 year ago

Equality test calculation doesn't make sense

foundinblank opened this issue over 1 year ago

Output '*' in union_relations when no columns are found in compile mode

martinshjung opened this pull request over 1 year ago

Linting `union_relation` with SQLFluff gives an empty select

martinshjung opened this issue over 1 year ago

Parameterize `union_relations` macro to support deduplication with `UNION DISTINCT` #816

will-hou opened this pull request over 1 year ago

Parameterize union_relations macro to support deduplication with UNION

will-hou opened this issue over 1 year ago

Methods to achieve null safety for `deduplicate`

dbeatty10 opened this pull request over 1 year ago

deduplicate bug in Spark in case of a null column.

clintf1982 opened this issue over 1 year ago

Default implementation of `deduplicate` is not null-safe

dbeatty10 opened this issue over 2 years ago

dbt_utils.pivot function fails on empty table

aadityahippo opened this issue over 4 years ago

union should explicitly specify table name in casts

wearpants opened this issue about 5 years ago

Feature: length macro

axelazaid opened this pull request about 6 years ago

run tests on all adapters

drewbanin opened this pull request about 6 years ago

Feature: right macro

axelazaid opened this pull request about 6 years ago

Feature: get url host

axelazaid opened this pull request about 6 years ago

get_url_host

jthandy opened this issue about 6 years ago

get_url_path

jthandy opened this issue about 6 years ago

Create a -m flag for --models

jwerderits opened this issue about 6 years ago

casting timestamp to date for BQ

DanielWFrancis opened this pull request about 6 years ago

Add expression_is_true schema test

clrcrl opened this pull request about 6 years ago

Upgrade schema.yml to v2

clrcrl opened this pull request about 6 years ago

Implement a whitelist argument for `union_tables` macro

clrcrl opened this issue about 6 years ago

try_cast only works for strings

jwerderits opened this issue about 6 years ago

get_table_by_prefix doesn't work on Bigquery

LeTristanB opened this issue about 6 years ago

Add slug option to pivot macro

abelsonlive opened this pull request about 6 years ago

Update pivot macro

dwallace0723 opened this pull request about 6 years ago

integration tests

drewbanin opened this issue over 6 years ago

remove list_relations call in materialization

beckjake opened this pull request over 6 years ago

fix for excluding last column in unpivot macro

alexcampana opened this pull request over 6 years ago

make union work on bq

drewbanin opened this pull request over 6 years ago

add error for union macro when table does not exist

drewbanin opened this issue over 6 years ago

Add sql_delimited_list macro

clrcrl opened this pull request over 6 years ago

Star macro optional alias argument

dwallace0723 opened this pull request over 6 years ago

Version out of date

mplovepop opened this issue over 6 years ago

Add support for schema.yml version 2

beckjake opened this pull request over 6 years ago

try to force dbt upgrade and run dbt --version during tests

beckjake opened this pull request over 6 years ago

upgrade dbt-utils to support v2 and v1 schema.ymls

cmcarthur opened this issue over 6 years ago

hash macro + update surrogate_key

jtcohen6 opened this pull request over 6 years ago

Add coalesce_0 macro

clrcrl opened this pull request over 6 years ago

Add "unpivot" macro

dwallace0723 opened this pull request over 6 years ago

fix for old versions of jinja

drewbanin opened this pull request over 6 years ago

Extending Pivot

ltchikindas opened this pull request over 6 years ago