dbt-audit-helper

dbt-audit-helper copied to clipboard

lf/issue-49 compare all columns macro for testing

6

## Description & motivation This PR creates a macro `compare_all_columns` which can be included in a dbt test suite to test whether any values in any columns have changed. The...

leoebfolsom

Easier toggle between summary and diff when comparing relations and queries

3

### Describe the feature I've found the compare_queries and compare_relations very useful. It would be great to add an optional parameter when calling the compare_queries and compare_relations macros which would...

PhilipCorr

File "/usr/local/lib/python3.9/dist-packages/dbt/parser/manifest.py", line 526, in macro_depends_on possible_macro_calls = statically_extract_macro_calls( File "/usr/local/lib/python3.9/dist-packages/dbt/clients/jinja_static.py", line 43, in statically_extract_macro_calls ad_macro_calls = statically_parse_adapter_dispatch( File "/usr/local/lib/python3.9/dist-packages/dbt/clients/jinja_static.py", line 147, in statically_parse_adapter_dispatch macro = db_wrapper.dispatch(func_name, macro_namespace=macro_namespace).macro File "/usr/local/lib/python3.9/dist-packages/dbt/context/providers.py",...

klxsxian

### Describe the feature I would like to build a macro that can be used repeatedly to create dbt tests that test whether all column values match between two versions...

leoebfolsom

## Description & motivation The [dbt Audit Helper package](https://github.com/dbt-labs/dbt-audit-helper#compare_column_values-source) includes a macro called `compare_column_values` that takes two queries and compares the values in a specific column. In the documentation, it...

davesgonechina

## Description & motivation This pull request adds two macros which extend the functionality of the `compare_column_values` macro, as follows: - `compare_columns_values` extends the existing `compare_column_values` macro in the following...

badge

When using this package, I got an ambiguous column name warning message from audit_helper/macros/compare_relation_columns.sql line 24 "full outer join b_cols using (column_name)" I believe this can be fixed by joining...

cecil185

### Describe the bug I have a dbt macro that _drops a table if it exists._ However, the subsequent code that is supposed to **_recreate the table fails_** since it...

asmurthy

### Describe the bug I used `compare_queries` and the generated view reported that there are some gaps between the target tables. However, according to my research, many records existed in...

yu-iskw

Package tidy up

1

# Repo checklist: ## Urgent: - [x] A `require-dbt-version` parameter in the `dbt_project.yml`: ``` require-dbt-version: [">=0.17.0", "

clrcrl