BOLT-906: Expose device-domain *tag tables in Metabase
completedGrace asked for all *tag tables in the device schema to be available in Metabase. Three tag tables in device prisma schema: WorkspaceTag (already in dbt), Tag, WorkspaceDeviceTag (both missing from dbt sources). Plan: (1) verify devices_tag and devices_workspacedevicetag exist in AIRBYTE.raw via Snowflake; if missing add to Airbyte connector, (2) add source decls to dbt/models/staging/airbyte/_sources.yml, (3) add clean models in dbt/models/clean/devices/ following devices_workspacetag.sql pattern, (4) update _schema.yml with not_null/unique on id, (5) ship PR to TextureHQ/dbt, (6) trigger dbt prod run, (7) re-sync Metabase Snowflake connection. Blocker: snow CLI install needs sudo (not available from Slack); also need Snowflake creds to verify table existence. Awaiting Sergey on either elevated install or running the snow install + sharing creds.
Event Timeline
created
status_change
queued → in_progress
progress
PR #51 pushed and opened. CI 4/5 green. dbt-tests red is PRE-EXISTING (PR #50 merged red same way) — leap_revenue_finalized model needs dbt seed but workflow only runs dbt run. My device_tag models built clean. Notified Sergey via Slack DM, recommended split approach: ship BOLT-906 + open separate CI-fix PR. Awaiting decision.
failed
lease expired — re-queued for retry
in_progress → queued
progress
Updated PR #51 description with pre-existing-CI-red note. Created Linear ALL-884 + opened companion PR #52 (havoc/fix-dbt-test-ci-seed) — adds dbt seed step before dbt run. Single-line workflow change. CI starting on #52 now. BOLT-906 unchanged, ready for Sergey review on whatever path he picks (split A is in motion).
status_change
queued → completed