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 808dcec Merge pull request #12 from
apache/dependabot/github_actions/actions/setup-python-6.2.0
add ad3a294 feat: add Transformation layer using dbt core
new f3686f6 Merge pull request #14 from
airajena/feat/add-dbt-transformation-layer
The 1 revisions listed above as "new" are entirely new to this
repository and will be described in separate emails. The revisions
listed as "add" were already present in the repository and have only
been added to this reference.
Summary of changes:
.gitignore | 5 +
.rat-excludes | 5 +
.rat-excludes => dbt/.gitignore | 13 +-
.asf.yaml => dbt/dbt_project.yml | 59 ++++---
.../macros/generate_schema_name.sql | 11 +-
.../mart_tables.sql => dbt/macros/safe_divide.sql | 10 +-
.../intermediate/int_loan_delinquency_status.sql | 122 +++++++++++++
dbt/models/marts/_marts.yml | 172 ++++++++++++++++++
.../models/marts/dimensions/dim_client.sql | 16 +-
.../models/marts/dimensions/dim_currency.sql | 12 +-
dbt/models/marts/dimensions/dim_date.sql | 39 +++++
.../marts/dimensions/dim_delinquency_bucket.sql | 53 ++++++
.../models/marts/dimensions/dim_office.sql | 26 ++-
.../models/marts/dimensions/dim_product.sql | 31 +++-
dbt/models/marts/facts/fact_delinquency_event.sql | 74 ++++++++
dbt/models/marts/facts/fact_loan_snapshot.sql | 64 +++++++
.../marts/presentations/mart_delinquency_par.sql | 193 +++++++++++++++++++++
dbt/models/sources.yml | 97 +++++++++++
dbt/models/staging/_staging.yml | 154 ++++++++++++++++
dbt/models/staging/stg_m_client.sql | 50 ++++++
.../models/staging/stg_m_currency.sql | 15 +-
dbt/models/staging/stg_m_delinquency.sql | 43 +++++
dbt/models/staging/stg_m_loan.sql | 71 ++++++++
dbt/models/staging/stg_m_loan_transaction.sql | 37 ++++
.../models/staging/stg_m_office.sql | 17 +-
.../models/staging/stg_m_product_loan.sql | 30 +++-
.rat-excludes => dbt/profiles.yml | 21 ++-
.rat-excludes => dbt/requirements.txt | 10 +-
scripts/check_licenses.py | 51 +++++-
29 files changed, 1408 insertions(+), 93 deletions(-)
copy .rat-excludes => dbt/.gitignore (88%)
copy .asf.yaml => dbt/dbt_project.yml (53%)
copy warehouse/schema/mart_tables.sql => dbt/macros/generate_schema_name.sql
(78%)
copy warehouse/schema/mart_tables.sql => dbt/macros/safe_divide.sql (77%)
create mode 100644 dbt/models/intermediate/int_loan_delinquency_status.sql
create mode 100644 dbt/models/marts/_marts.yml
copy warehouse/schema/mart_tables.sql =>
dbt/models/marts/dimensions/dim_client.sql (78%)
copy warehouse/schema/mart_tables.sql =>
dbt/models/marts/dimensions/dim_currency.sql (81%)
create mode 100644 dbt/models/marts/dimensions/dim_date.sql
create mode 100644 dbt/models/marts/dimensions/dim_delinquency_bucket.sql
copy docker/postgres-warehouse/initdb/001_init_warehouse.sql =>
dbt/models/marts/dimensions/dim_office.sql (64%)
copy docker/postgres-warehouse/initdb/001_init_warehouse.sql =>
dbt/models/marts/dimensions/dim_product.sql (59%)
create mode 100644 dbt/models/marts/facts/fact_delinquency_event.sql
create mode 100644 dbt/models/marts/facts/fact_loan_snapshot.sql
create mode 100644 dbt/models/marts/presentations/mart_delinquency_par.sql
create mode 100644 dbt/models/sources.yml
create mode 100644 dbt/models/staging/_staging.yml
create mode 100644 dbt/models/staging/stg_m_client.sql
copy warehouse/schema/mart_tables.sql => dbt/models/staging/stg_m_currency.sql
(67%)
create mode 100644 dbt/models/staging/stg_m_delinquency.sql
create mode 100644 dbt/models/staging/stg_m_loan.sql
create mode 100644 dbt/models/staging/stg_m_loan_transaction.sql
copy warehouse/schema/mart_tables.sql => dbt/models/staging/stg_m_office.sql
(64%)
copy warehouse/schema/mart_tables.sql =>
dbt/models/staging/stg_m_product_loan.sql (53%)
copy .rat-excludes => dbt/profiles.yml (68%)
copy .rat-excludes => dbt/requirements.txt (88%)
