Quartz 5

Project State: Looker Studio Dashboard

Properties1
tagsproject--status--intelligence--thedogwizard

1 min read

Project State: Looker Studio Dashboard

📌 Active Development Context

This document serves as the active short-term memory register for the looker-studio-dashboard project. It contains immediate parameters, workspace paths, and active lineages to keep agents completely aligned on the workspace state.

🛠️ System Paths & Credentials

  • Workspace Path: /home/kevindockman/projects/03_clients/dogwizard/looker-studio-dashboard/
  • GCP Service Account Key: /home/kevindockman/projects/03_clients/dogwizard/dbt-dev-box-key.json
  • BigQuery Project ID: thedogwizard-kpi-dashboards
  • dbt Target Profile: prod
  • Global dbt Path: /home/kevindockman/.local/bin/dbt (Note: the project’s local virtual environment .venv/bin/dbt is missing).

💾 Backfill Status & State Files

  • Progress File: /home/kevindockman/projects/03_clients/dogwizard/looker-studio-dashboard/data/backfill_progress.jsonl (Contains 87,765 conversation IDs marked as success, skipped, or error for resume operations).
  • Historical Calls File: /home/kevindockman/projects/03_clients/dogwizard/looker-studio-dashboard/data/raw_calls.jsonl (193,594 records).
  • Historical Messages File: /home/kevindockman/projects/03_clients/dogwizard/looker-studio-dashboard/data/raw_messages.jsonl (377,746 records).
  • Target Conversations Source: /home/kevindockman/projects/03_clients/dogwizard/looker-studio-dashboard/data/raw_conversations.json.

🔗 Active Lineage & Target Models

When executing incremental builds or manual dbt refreshes for Quo, target the following selection criteria:

/home/kevindockman/.local/bin/dbt run -t prod --full-refresh --select stg_quo_calls mrt_quo_calls_daily pres_quo_calls_daily stg_quo_messages mrt_quo_messages_daily pres_quo_messages_daily
  • Staging Layer (Deduplication):
    • models/staging/quo/stg_quo_calls.sql
    • models/staging/quo/stg_quo_messages.sql
  • Marts Layer (Aggregation):
    • models/marts/quo/mrt_quo_calls_daily.sql
    • models/marts/quo/mrt_quo_messages_daily.sql
  • Presentation Layer (Looker Studio Source):
    • models/presentation/quo/pres_quo_calls_daily.sql
    • models/presentation/quo/pres_quo_messages_daily.sql

Graph View

Backlinks