This is an automated email from the ASF dual-hosted git repository.
Aman-Mittal pushed a change to branch main
in repository
https://gitbox.apache.org/repos/asf/fineract-business-intelligence.git
from 79601d7 Merge pull request #49 from
airajena/test/add-extractor-unit-tests
add 8e1430f test: add dbt transformation layer tests with dbt-utils and
singular SQL checks
add f5de51c fix: install dbt-utils before dbt parse in compilation-checks
job
add 19e163b Merge pull request #50 from
airajena/test/add-dbt-transformation-tests
No new revisions were added by this update.
Summary of changes:
.github/workflows/ci.yml | 6 ++-
.rat-excludes | 1 +
dbt/dbt_project.yml | 3 ++
dbt/models/marts/_marts.yml | 38 +++++++++++++++
dbt/package-lock.yml | 5 ++
dbt/{requirements.txt => packages.yml} | 4 +-
..._borrower_count_never_exceeds_transactions.sql} | 16 ++++---
...assert_collection_efficiency_within_bounds.sql} | 15 +++---
...assert_marts_have_no_orphan_dimension_keys.sql} | 36 +++++++++------
.../assert_no_future_dated_facts.sql} | 32 +++++++------
dbt/tests/assert_no_negative_amounts_or_counts.sql | 46 ++++++++++++++++++
dbt/tests/assert_no_pii_columns_in_marts.sql | 54 ++++++++++++++++++++++
...sert_par_components_never_exceed_portfolio.sql} | 32 ++++++-------
.../assert_par_hierarchy_never_violated.sql} | 24 ++++++----
.../assert_par_ratios_within_bounds.sql} | 22 +++++----
...ert_repayment_components_dont_exceed_total.sql} | 44 +++++++++---------
.../assert_waived_never_exceeds_charged.sql} | 13 +++---
17 files changed, 287 insertions(+), 104 deletions(-)
create mode 100644 dbt/package-lock.yml
copy dbt/{requirements.txt => packages.yml} (91%)
copy dbt/{models/marts/dimensions/dim_currency.sql =>
tests/assert_borrower_count_never_exceeds_transactions.sql} (70%)
copy dbt/{models/marts/dimensions/dim_currency.sql =>
tests/assert_collection_efficiency_within_bounds.sql} (74%)
copy dbt/{models/staging/stg_m_office.sql =>
tests/assert_marts_have_no_orphan_dimension_keys.sql} (55%)
copy dbt/{models/staging/stg_m_office.sql =>
tests/assert_no_future_dated_facts.sql} (60%)
create mode 100644 dbt/tests/assert_no_negative_amounts_or_counts.sql
create mode 100644 dbt/tests/assert_no_pii_columns_in_marts.sql
copy dbt/{models/marts/dimensions/dim_office.sql =>
tests/assert_par_components_never_exceed_portfolio.sql} (61%)
copy dbt/{models/marts/dimensions/dim_client.sql =>
tests/assert_par_hierarchy_never_violated.sql} (68%)
copy dbt/{models/marts/dimensions/dim_client.sql =>
tests/assert_par_ratios_within_bounds.sql} (72%)
copy dbt/{models/marts/dimensions/dim_product.sql =>
tests/assert_repayment_components_dont_exceed_total.sql} (58%)
copy dbt/{models/marts/dimensions/dim_currency.sql =>
tests/assert_waived_never_exceeds_charged.sql} (79%)
