⚙️ 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.
🌐 @data_apps | Навигация по каналу
