Work Log (2026-05-22)

  • IDE Extensions Parity: Solved VS Code extension mismatch by clearing the empty local extensions folder ~/.antigravity-ide/extensions and adding a declarative out-of-store Nix symlink to ~/.antigravity-ide-server/extensions inside home.nix. Ran home-manager switch cleanly to synchronize 16 essential extensions (including Google Cloud Code and Gemini Code Assist) across both local and remote desktop IDE environments.
  • dbt Service Account Integration: Restored GCP service account-based authentication for the dogwizard dbt project by generating a fresh JSON key file for [email protected] and saving it to the standardized lowercase path ~/projects/03_clients/dogwizard/dbt-dev-box-key.json. Re-mapped ~/.dbt/profiles.yml to target the key file via method: service-account.
  • BigQuery Storage API & IAM Resolution: Resolved compilation failures on mrt_google_search_query_daily, mrt_google_business_location_insight, and mrt_google_ads_stats_by_account_campaign_date by granting the roles/bigquery.readSessionUser role to the service account on the thedogwizard-kpi-dashboards project. Verified 100% successful compilation of all 33 models and 1 seed in 2.6 seconds.
  • Billing Quota Management: Restored default gcloud CLI active configurations ([email protected] and waycup-admin-hub billing quota project) to ensure CLI parity and prevent future quota-trip errors.
  • Cost & Token Optimizations Strategy: Set the foundation for session 2 to tackle rising token and API call costs (yesterday over 50). Documented initial ideas on context-size reduction, more efficient local tools, and setting up dedicated thin-client agent gates.