You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@fineract.apache.org by "airajena (via GitHub)" <gi...@apache.org> on 2026/06/22 07:54:13 UTC
[PR] doc: add README and some script changes [fineract-business-intelligence]
airajena opened a new pull request, #22:
URL: https://github.com/apache/fineract-business-intelligence/pull/22
### Summary
- Added a complete README.md covering architecture, setup (9 steps from Fineract clone to Superset), keeping dashboards fresh, troubleshooting, and project structure
- Added scripts/bootstrap_source.sh : one-time setup that creates bi_connector_source compatibility views and fineract_reader read-only role on the Fineract DB
- Added scripts/run_pipeline.sh : orchestrates extractor → dbt → Superset refresh loop
- Added warehouse/seed/seed_fineract_source.sql : demo dataset (25 clients, 71 loans across 3 offices, 4 products, all PAR buckets populated)
- Fixed dbt/requirements.txt : pinned dbt-postgres<2.0.0a1 to prevent dbt Fusion (which dropped PostgreSQL support) from being installed
- Fixed dbt/models/marts/facts/fact_delinquency_event.sql : added unique_key config to prevent duplicate rows on incremental runs
- Fixed docker/extractor/Dockerfile : added Docker CE CLI so the extractor can orchestrate dbt and Superset containers from inside the container
- Fixed compose.yaml : attached extractor to fineract_default Docker network and mounted Docker socket so it can reach fineract-db-1 by container name
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: issues-unsubscribe@fineract.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [PR] doc: add README and some script changes [fineract-business-intelligence]
Posted by "Aman-Mittal (via GitHub)" <gi...@apache.org>.
Aman-Mittal commented on code in PR #22:
URL: https://github.com/apache/fineract-business-intelligence/pull/22#discussion_r3487563179
##########
dbt/requirements.txt:
##########
@@ -15,4 +15,4 @@
# specific language governing permissions and limitations
# under the License.
-dbt-postgres>=1.10.0,<2.0
+dbt-postgres>=1.8.0,<2.0.0a1
Review Comment:
ok
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: issues-unsubscribe@fineract.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [PR] doc: add README and some script changes [fineract-business-intelligence]
Posted by "Aman-Mittal (via GitHub)" <gi...@apache.org>.
Aman-Mittal merged PR #22:
URL: https://github.com/apache/fineract-business-intelligence/pull/22
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: issues-unsubscribe@fineract.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [PR] doc: add README and some script changes [fineract-business-intelligence]
Posted by "Aman-Mittal (via GitHub)" <gi...@apache.org>.
Aman-Mittal commented on code in PR #22:
URL: https://github.com/apache/fineract-business-intelligence/pull/22#discussion_r3476093466
##########
dbt/requirements.txt:
##########
@@ -15,4 +15,4 @@
# specific language governing permissions and limitations
# under the License.
-dbt-postgres>=1.10.0,<2.0
+dbt-postgres>=1.8.0,<2.0.0a1
Review Comment:
why downgrade?
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: issues-unsubscribe@fineract.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [PR] doc: add README and some script changes [fineract-business-intelligence]
Posted by "airajena (via GitHub)" <gi...@apache.org>.
airajena commented on code in PR #22:
URL: https://github.com/apache/fineract-business-intelligence/pull/22#discussion_r3476477442
##########
dbt/requirements.txt:
##########
@@ -15,4 +15,4 @@
# specific language governing permissions and limitations
# under the License.
-dbt-postgres>=1.10.0,<2.0
+dbt-postgres>=1.8.0,<2.0.0a1
Review Comment:
The original pin >=1.10.0,<2.0 was unintentionally allowing pip to resolve to dbt-postgres==2.0.0a1 (dbt Fusion alpha) because pip treats 2.0.0a1 as less than 2.0.0 and therefore within the <2.0 bound. dbt Fusion dropped PostgreSQL adapter support in this alpha, causing dbt run to fail inside the container. Changed to <2.0.0a1 to explicitly exclude the pre-release and keep pip on the latest stable 1.x release.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: issues-unsubscribe@fineract.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org