How databricks-industry-solutions/ad-genie works
ad-genie is a Databricks marketing-analytics product: Lakeflow Connect supplies platform data, transformations create standardized silver and conformed gold tables, and metric views, a dashboard, and a Genie room provide analytics. The source index and excerpts support the transformation and Genie relationships; README statements identify the documented product capabilities. Dashboard wiring and some deployment configuration are not shown, so those relationships are marked unverified. Test-harness components are excluded.
Main entry points: gold_transforms.py Gold transforms · silver_transforms.py Silver transforms · base.py Source base · genie_space_manager.py Genie space manager
Components 18
Source ingestion
- Lakeflow Connect
- Bronze tables
Data transformations
- Source base
src/pipeline/sources/base.py - Google Ads transforms
src/pipeline/sources/google_ads.py - Meta Ads transforms
src/pipeline/sources/meta_ads.py - TikTok Ads transforms
src/pipeline/sources/tiktok_ads.py - Table schemas
src/pipeline/schemas.py - Silver transforms
src/pipeline/silver_transforms.py - Gold transforms
src/pipeline/gold_transforms.py
Analytics products
- Ad metric view
src/metric_views/metv_ad_performance.py - Ad set metric view
src/metric_views/metv_adset_performance.py - Campaign metric view
src/metric_views/metv_campaign_performance.py - AI/BI dashboard
src/dashboard/ad_genie_dashboard.lvdash.json
Genie assistant
- Genie setup entry
src/genie_space/create_genie_space.py - Genie space manager
src/genie_space/genie_space_manager.py - Genie semantic config
src/genie_space/genie_space_config.py
Other components
- Marketing data
- Databricks workspace
Connections 24
- Marketing data → Lakeflow Connect: provides ad data
README.md - Lakeflow Connect → Bronze tables: ingests to
README.md - Silver transforms → Bronze tables: reads
src/pipeline/silver_transforms.py - Silver transforms → Google Ads transforms: dispatches source
- Silver transforms → Meta Ads transforms: dispatches source
- Silver transforms → TikTok Ads transforms: dispatches source
- Google Ads transforms → Source base: inherits from
src/pipeline/sources/google_ads.py - Meta Ads transforms → Source base: inherits from
src/pipeline/sources/meta_ads.py - TikTok Ads transforms → Source base: inherits from
src/pipeline/sources/tiktok_ads.py - Source base → Table schemas: uses schema constants
src/pipeline/sources/base.py - Silver transforms → Table schemas: uses schemas
src/pipeline/silver_transforms.py - Gold transforms → Silver transforms: reads silver tables
src/pipeline/gold_transforms.py - Gold transforms → Table schemas: uses gold schemas
src/pipeline/gold_transforms.py - Ad metric view → Gold transforms: queries gold tables
src/metric_views/metv_ad_performance.py - Ad set metric view → Gold transforms: queries gold tables
src/metric_views/metv_adset_performance.py - Campaign metric view → Gold transforms: queries gold tables
src/metric_views/metv_campaign_performance.py - AI/BI dashboard → Gold transforms: visualizes trends
README.md - Genie setup entry → Genie space manager: invokes
src/genie_space/create_genie_space.py - Genie space manager → Genie semantic config: builds semantic space
src/genie_space/genie_space_manager.py - Genie space manager → Databricks workspace: calls Genie API
src/genie_space/genie_space_manager.py - Genie setup entry → Databricks workspace: deploys Genie room
README.md - Genie semantic config → Gold transforms: references gold tables
README.md - Genie semantic config → Ad metric view: references metric views
README.md - AI/BI dashboard → Databricks workspace: runs in workspace
README.md