2023-01-31 10:43:07
Released
myBI dbt Core and
myBI Market showcase
myBI dbt Core module allows quick start transformations on top of data synced by myBI Connect along with multiple useful macros.
— Supported Adapters: Clickhouse, PostgreSQL
— Reference any data source as simple as select * from source('general', 'dates')
— Build staging layer in one command with filters on account_id applied, pre-join with date dimension, comprehensive data testing (unique, not_null, relationships)
— Leverage macros: source_filter_rows to limit rows for dev/test environments, any macro from dbt_utils package
myBI Market showcase guides you through building Modern Data Stack analytics:
— Configure environment
— Install and configure mybi_dbt_core package
— Configure data sources
— Build staging layer models
— Model Data Marts
— Visualize on a dashboard
— Publish dbt project docs
— Introduce Continuous Integration
Check it out and leave your comments and questions in Tg discussions.
I will follow up with detailed publications on Habr soon.
121 viewsArtemiy Kzr, 07:43