Dbt Model Graph
blockdevopsdbt Cloud style data modeling DAG dependency graph, compiled SQL view, and model documentation with lineage tree, Jinja/SQL source editor, compiled warehouse query, and column contract test suite.
Installation
$pnpm dlx shadcn-vue@latest add https://uipkge.dev/r/vue/dbt-model-graph.json$npx shadcn-vue@latest add https://uipkge.dev/r/vue/dbt-model-graph.json$yarn dlx shadcn-vue@latest add https://uipkge.dev/r/vue/dbt-model-graph.json$bunx shadcn-vue@latest add https://uipkge.dev/r/vue/dbt-model-graph.jsonNamed registry:
npx shadcn-vue@latest add @uipkge/dbt-model-graphInstalls to:app/components/blocks/Variants
Loading interactive previews…
Loading interactive previews…
Props
| Name | Type / Values | Default | Required |
|---|---|---|---|
class | HTMLAttributes['class'] | — | optional |
Schema
Type aliases exported from this item's source. Use these to shape the data you pass in.
ModelColumninterface ModelColumn {
name: string
dataType: string
nullable: boolean
isPrimaryKey?: boolean
isForeignKey?: boolean
foreignKeyRef?: string
isClusterKey?: boolean
tests: Array<{
name: 'unique' | 'not_null' | 'relationships' | 'accepted_values'
status: 'pass' | 'warn' | 'fail'
detail?: string
}>
testDuration: string
description: string
}UpstreamNodeinterface UpstreamNode {
id: string
name: string
type: 'view' | 'table' | 'source'
package: string
rowCount: string
freshness: string
freshnessStatus: 'pass' | 'warn'
description: string
}DownstreamNodeinterface DownstreamNode {
id: string
name: string
type: 'table' | 'incremental' | 'exposure'
package: string
consumers: string
sla: string
description: string
}Files installed (1)
app/components/blocks/DbtModelGraph.vue48.4 kB
<script setup lang="ts"> import { computed, ref } from 'vue' import type { HTMLAttributes } from 'vue' import { ArrowUpRight, Check, CheckCircle2, Clock, Code2, Copy, Database, FileCode, GitBranch, HardDrive, Info, Key, Layers, Link2, Loader2, Play, Search, ShieldCheck, Table2, Tag, User, Workflow, Zap, } from 'lucide-vue-next' import { cn } from '@/lib/utils' import { Badge } from '@/components/ui/badge' import { Button } from '@/components/ui/button' import { Card } from '@/components/ui/card' import { Input } from '@/components/ui/input' import { Table, TableBody, TableCell, TableHead, TableHeader, TableRow } from '@/components/ui/table' import { Tabs, TabsContent, TabsList, TabsTrigger } from '@/components/ui/tabs' interface ModelColumn { name: string dataType: string nullable: boolean isPrimaryKey?: boolean isForeignKey?: boolean foreignKeyRef?: string isClusterKey?: boolean tests: Array<{ name: 'unique' | 'not_null' | 'relationships' | 'accepted_values' status: 'pass' | 'warn' | 'fail' detail?: string }> testDuration: string description: string } interface UpstreamNode { id: string name: string type: 'view' | 'table' | 'source' package: string rowCount: string freshness: string freshnessStatus: 'pass' | 'warn' description: string } interface DownstreamNode { id: string name: string type: 'table' | 'incremental' | 'exposure' package: string consumers: string sla: string description: string } const props = defineProps<{ class?: HTMLAttributes['class'] }>() // --- State --- const activeTab = ref<'model-sql' | 'compiled-sql' | 'contract'>('model-sql') const columnSearch = ref('') const isBuilding = ref(false) const isTesting = ref(false) const copiedRef = ref(false) const dbtMacroRef = "{{ ref('fct_orders') }}" const copiedSql = ref(false) const copiedCompiled = ref(false) const buildStatusText = ref('Success · Built in 14.2s') const lastBuildTime = ref('12 mins ago') const selectedNodeId = ref<string>('fct_orders') const wrapLines = ref(false) // --- Data --- const modelSqlSource = `{{ config( materialized = 'incremental', unique_key = 'order_id', on_schema_change = 'sync_all_columns', incremental_strategy = 'merge', cluster_by = ['order_date', 'customer_id'], tags = ['finance', 'core', 'daily_sla'] ) }} WITH payments AS ( SELECT payment_id, order_id, payment_method, amount_usd, gateway_fee_usd, status AS payment_status, created_at AS payment_created_at FROM {{ ref('stg_stripe__payments') }} {% if is_incremental() %} WHERE updated_at >= (SELECT coalesce(max(payment_created_at), '1970-01-01') FROM {{ this }}) {% endif %} ), orders_source AS ( SELECT order_id, customer_id, order_number, order_status, total_amount_usd, tax_amount_usd, discount_amount_usd, currency_code, order_date, created_at, updated_at FROM {{ ref('stg_shopify__orders') }} {% if is_incremental() %} WHERE updated_at >= (SELECT coalesce(max(updated_at), '1970-01-01') FROM {{ this }}) {% endif %} ), customers AS ( SELECT customer_id, customer_tier, country_code, lifetime_order_count FROM {{ ref('dim_customers') }} ), aggregated_payments AS ( SELECT order_id, sum(case when payment_status = 'succeeded' then amount_usd else 0 end) as total_paid_usd, sum(gateway_fee_usd) as total_fees_usd, count(payment_id) as payment_attempts_count, max(payment_created_at) as last_payment_at FROM payments GROUP BY 1 ), final_model AS ( SELECT ord.order_id, ord.order_number, ord.customer_id, cust.customer_tier, cust.country_code, ord.order_status, ord.order_date, ord.currency_code, ord.total_amount_usd, ord.tax_amount_usd, ord.discount_amount_usd, coalesce(pay.total_paid_usd, 0.00) as total_paid_usd, coalesce(pay.total_fees_usd, 0.00) as payment_fees_usd, round(ord.total_amount_usd - coalesce(pay.total_fees_usd, 0.00), 2) as net_revenue_usd, case when pay.total_paid_usd >= ord.total_amount_usd then 'fully_paid' when pay.total_paid_usd > 0 then 'partially_paid' else 'unpaid' end as payment_settlement_status, coalesce(pay.payment_attempts_count, 0) as payment_attempts, ord.created_at, ord.updated_at FROM orders_source ord LEFT JOIN aggregated_payments pay ON ord.order_id = pay.order_id LEFT JOIN customers cust ON ord.customer_id = cust.customer_id ) SELECT * FROM final_model` const compiledSqlSource = `-- Compiled target warehouse query: Snowflake / AWS us-east-1 -- Execution target: "ANALYTICS_PROD"."MARTS"."fct_orders" -- Incremental Merge Strategy with cluster keys [order_date, customer_id] MERGE INTO "ANALYTICS_PROD"."MARTS"."fct_orders" AS target USING ( WITH payments AS ( SELECT payment_id, order_id, payment_method, amount_usd, gateway_fee_usd, status AS payment_status, created_at AS payment_created_at FROM "ANALYTICS_PROD"."STAGING"."stg_stripe__payments" WHERE updated_at >= (SELECT coalesce(max(payment_created_at), '1970-01-01') FROM "ANALYTICS_PROD"."MARTS"."fct_orders") ), orders_source AS ( SELECT order_id, customer_id, order_number, order_status, total_amount_usd, tax_amount_usd, discount_amount_usd, currency_code, order_date, created_at, updated_at FROM "ANALYTICS_PROD"."STAGING"."stg_shopify__orders" WHERE updated_at >= (SELECT coalesce(max(updated_at), '1970-01-01') FROM "ANALYTICS_PROD"."MARTS"."fct_orders") ), customers AS ( SELECT customer_id, customer_tier, country_code, lifetime_order_count FROM "ANALYTICS_PROD"."CORE"."dim_customers" ), aggregated_payments AS ( SELECT order_id, sum(case when payment_status = 'succeeded' then amount_usd else 0 end) as total_paid_usd, sum(gateway_fee_usd) as total_fees_usd, count(payment_id) as payment_attempts_count, max(payment_created_at) as last_payment_at FROM payments GROUP BY 1 ), final_model AS ( SELECT ord.order_id, ord.order_number, ord.customer_id, cust.customer_tier, cust.country_code, ord.order_status, ord.order_date, ord.currency_code, ord.total_amount_usd, ord.tax_amount_usd, ord.discount_amount_usd, coalesce(pay.total_paid_usd, 0.00) as total_paid_usd, coalesce(pay.total_fees_usd, 0.00) as payment_fees_usd, round(ord.total_amount_usd - coalesce(pay.total_fees_usd, 0.00), 2) as net_revenue_usd, case when pay.total_paid_usd >= ord.total_amount_usd then 'fully_paid' when pay.total_paid_usd > 0 then 'partially_paid' else 'unpaid' end as payment_settlement_status, coalesce(pay.payment_attempts_count, 0) as payment_attempts, ord.created_at, ord.updated_at FROM orders_source ord LEFT JOIN aggregated_payments pay ON ord.order_id = pay.order_id LEFT JOIN customers cust ON ord.customer_id = cust.customer_id ) SELECT * FROM final_model ) AS source ON target.order_id = source.order_id WHEN MATCHED THEN UPDATE SET order_number = source.order_number, customer_id = source.customer_id, customer_tier = source.customer_tier, country_code = source.country_code, order_status = source.order_status, order_date = source.order_date, total_amount_usd = source.total_amount_usd, tax_amount_usd = source.tax_amount_usd, discount_amount_usd = source.discount_amount_usd, total_paid_usd = source.total_paid_usd, payment_fees_usd = source.payment_fees_usd, net_revenue_usd = source.net_revenue_usd, payment_settlement_status = source.payment_settlement_status, payment_attempts = source.payment_attempts, updated_at = source.updated_at WHEN NOT MATCHED THEN INSERT ( order_id, order_number, customer_id, customer_tier, country_code, order_status, order_date, currency_code, total_amount_usd, tax_amount_usd, discount_amount_usd, total_paid_usd, payment_fees_usd, net_revenue_usd, payment_settlement_status, payment_attempts, created_at, updated_at ) VALUES ( source.order_id, source.order_number, source.customer_id, source.customer_tier, source.country_code, source.order_status, source.order_date, source.currency_code, source.total_amount_usd, source.tax_amount_usd, source.discount_amount_usd, source.total_paid_usd, source.payment_fees_usd, source.net_revenue_usd, source.payment_settlement_status, source.payment_attempts, source.created_at, source.updated_at );` const upstreamNodes: UpstreamNode[] = [ { id: 'stg_stripe__payments', name: 'stg_stripe__payments', type: 'view', package: 'analytics_dw.staging.stripe', rowCount: '1,420,800 rows', freshness: 'Pass · 12m ago', freshnessStatus: 'pass', description: 'Raw webhook payment charges, refunds, and gateway fee captures from Stripe API.', }, { id: 'stg_shopify__orders', name: 'stg_shopify__orders', type: 'view', package: 'analytics_dw.staging.shopify', rowCount: '984,200 rows', freshness: 'Pass · 5m ago', freshnessStatus: 'pass', description: 'E-commerce transactional headers, tax summaries, discount allocations, and checkout states.', }, { id: 'dim_customers', name: 'dim_customers', type: 'table', package: 'analytics_dw.core', rowCount: '248,500 rows', freshness: 'Pass · 1h ago', freshnessStatus: 'pass', description: 'Type-2 slowly changing dimension master record for authenticated customer accounts.', }, ] const downstreamNodes: DownstreamNode[] = [ { id: 'mart_finance_mrr', name: 'mart_finance_mrr', type: 'table', package: 'analytics_dw.marts.finance', consumers: 'Finance Team & NetSuite Sync', sla: 'Tier 1 · Daily 06:00 UTC', description: 'Monthly recurring revenue waterfall and cohort retention analysis table.', }, { id: 'mart_executive_kpis', name: 'mart_executive_kpis', type: 'table', package: 'analytics_dw.marts.executive', consumers: 'Executive Dashboard & Board Reports', sla: 'Tier 1 · Daily 07:00 UTC', description: 'High-level business health rollup metrics: GMV, net revenue, CAC payback, and refund rates.', }, { id: 'tableau_revenue_dashboard', name: 'tableau_revenue_dashboard', type: 'exposure', package: 'exposures.bi.tableau', consumers: '120 Active BI Users', sla: 'Hourly Sync', description: 'Production executive revenue tracking workbook and daily pacing alerts.', }, ] const columns: ModelColumn[] = [ { name: 'order_id', dataType: 'STRING (VARCHAR)', nullable: false, isPrimaryKey: true, tests: [ { name: 'unique', status: 'pass' }, { name: 'not_null', status: 'pass' }, ], testDuration: '12.4ms', description: 'Surrogate primary key generated for each transactional order record.', }, { name: 'order_number', dataType: 'STRING (VARCHAR)', nullable: false, tests: [ { name: 'unique', status: 'pass' }, { name: 'not_null', status: 'pass' }, ], testDuration: '14.1ms', description: 'Human-readable sequential invoice reference number from checkout.', }, { name: 'customer_id', dataType: 'STRING (VARCHAR)', nullable: false, isForeignKey: true, foreignKeyRef: 'dim_customers.customer_id', tests: [ { name: 'not_null', status: 'pass' }, { name: 'relationships', status: 'pass', detail: 'dim_customers' }, ], testDuration: '28.6ms', description: 'Foreign key reference linking order to the verified master customer account.', }, { name: 'customer_tier', dataType: 'STRING (VARCHAR)', nullable: true, tests: [ { name: 'accepted_values', status: 'pass', detail: 'enterprise, pro, starter, free', }, ], testDuration: '9.2ms', description: 'Customer loyalty and billing subscription tier at the time of purchase.', }, { name: 'country_code', dataType: 'STRING (CHAR(2))', nullable: false, tests: [{ name: 'not_null', status: 'pass' }], testDuration: '8.4ms', description: 'ISO 3166-1 alpha-2 two-letter billing destination country code.', }, { name: 'order_status', dataType: 'STRING (VARCHAR)', nullable: false, tests: [ { name: 'accepted_values', status: 'pass', detail: 'completed, processing, shipped, cancelled, refunded', }, { name: 'not_null', status: 'pass' }, ], testDuration: '15.3ms', description: 'Current order fulfillment and delivery lifecycle state.', }, { name: 'order_date', dataType: 'DATE', nullable: false, isClusterKey: true, tests: [{ name: 'not_null', status: 'pass' }], testDuration: '7.9ms', description: 'Calendar transaction date used as primary cluster and pruning key.', }, { name: 'currency_code', dataType: 'STRING (CHAR(3))', nullable: false, tests: [ { name: 'accepted_values', status: 'pass', detail: 'USD, EUR, GBP, CAD', }, ], testDuration: '6.8ms', description: 'ISO 4217 three-letter currency code in which the charge was denominated.', }, { name: 'total_amount_usd', dataType: 'DECIMAL(12,2)', nullable: false, tests: [{ name: 'not_null', status: 'pass' }], testDuration: '10.1ms', description: 'Gross order amount in base USD currency including tax and discounts.', }, { name: 'tax_amount_usd', dataType: 'DECIMAL(10,2)', nullable: false, tests: [{ name: 'not_null', status: 'pass' }], testDuration: '9.0ms', description: 'Total sales tax and VAT amount captured for remittance.', }, { name: 'discount_amount_usd', dataType: 'DECIMAL(10,2)', nullable: false, tests: [{ name: 'not_null', status: 'pass' }], testDuration: '8.1ms', description: 'Promotional discount and coupon deductions applied at checkout.', }, { name: 'total_paid_usd', dataType: 'DECIMAL(12,2)', nullable: false, tests: [{ name: 'not_null', status: 'pass' }], testDuration: '11.3ms', description: 'Sum of all verified cleared customer payments from Stripe ledger.', }, { name: 'payment_fees_usd', dataType: 'DECIMAL(10,2)', nullable: false, tests: [{ name: 'not_null', status: 'pass' }], testDuration: '9.8ms', description: 'Merchant interchange and gateway transaction processing fees.', }, { name: 'net_revenue_usd', dataType: 'DECIMAL(12,2)', nullable: false, tests: [{ name: 'not_null', status: 'pass' }], testDuration: '10.5ms', description: 'Net recognized revenue after deducting gateway processing fees.', }, { name: 'payment_settlement_status', dataType: 'STRING (VARCHAR)', nullable: false, tests: [ { name: 'accepted_values', status: 'pass', detail: 'fully_paid, partially_paid, unpaid', }, { name: 'not_null', status: 'pass' }, ], testDuration: '8.7ms', description: 'Payment clearing and reconciliation flag calculated against order total.', }, { name: 'payment_attempts', dataType: 'INTEGER', nullable: false, tests: [{ name: 'not_null', status: 'pass' }], testDuration: '6.2ms', description: 'Number of authorization attempts recorded in the payment gateway.', }, { name: 'created_at', dataType: 'TIMESTAMP_TZ', nullable: false, tests: [{ name: 'not_null', status: 'pass' }], testDuration: '8.0ms', description: 'Initial order creation timestamp in UTC timezone.', }, { name: 'updated_at', dataType: 'TIMESTAMP_TZ', nullable: false, tests: [{ name: 'not_null', status: 'pass' }], testDuration: '8.3ms', description: 'Last modified timestamp used as incremental watermark boundary.', }, ] // --- Computed --- const modelSqlLines = computed(() => modelSqlSource.split('\n')) const compiledSqlLines = computed(() => compiledSqlSource.split('\n')) const filteredColumns = computed(() => { const query = columnSearch.value.trim().toLowerCase() if (!query) return columns return columns.filter( (col) => col.name.toLowerCase().includes(query) || col.dataType.toLowerCase().includes(query) || col.description.toLowerCase().includes(query) || col.tests.some( (t) => t.name.toLowerCase().includes(query) || (t.detail && t.detail.toLowerCase().includes(query)), ), ) }) const passingTestsCount = computed(() => { return columns.reduce((acc, col) => acc + col.tests.filter((t) => t.status === 'pass').length, 0) }) // --- Syntax Highlighting Helpers --- function escapeHtml(str: string): string { return str .replace(/&/g, '&') .replace(/</g, '<') .replace(/>/g, '>') .replace(/"/g, '"') .replace(/'/g, ''') } function highlightJinjaSqlLine(line: string): string { if (!line) return '' const escaped = escapeHtml(line) // SQL & Jinja Comments if (escaped.trim().startsWith('--') || escaped.trim().startsWith('{#')) { return `<span class="text-muted-foreground/60 italic">${escaped}</span>` } // Highlight Jinja tags: {{ ... }} and {% ... %} let result = escaped.replace(/(\{\{[\s\S]*?\}\}|\{%[\s\S]*?%\})/g, (jinjaMatch) => { let inner = jinjaMatch .replace( /\b(config|ref|source|is_incremental|this|var|materialized|unique_key|on_schema_change|incremental_strategy|cluster_by|tags)\b/g, '<span class="text-warning font-semibold">$1</span>', ) .replace(/(\{\{|\}\}|\{%|%\})/g, '<span class="text-chart-1 font-bold">$1</span>') return `<span class="bg-chart-1/10 px-1 py-0.5 rounded text-chart-1">${inner}</span>` }) // SQL Keywords result = result.replace( /\b(WITH|SELECT|FROM|JOIN|LEFT JOIN|INNER JOIN|RIGHT JOIN|FULL JOIN|ON|WHERE|GROUP BY|ORDER BY|AND|OR|NOT|AS|CASE|WHEN|THEN|ELSE|END|MERGE INTO|USING|WHEN MATCHED|WHEN NOT MATCHED|INSERT|UPDATE|SET|VALUES|OVER|PARTITION BY)\b/g, '<span class="text-info font-semibold">$1</span>', ) // SQL Aggregate & Utility Functions result = result.replace( /\b(coalesce|sum|count|max|min|avg|round|cast|date_trunc|concat)\b/gi, '<span class="text-chart-2 font-medium">$1</span>', ) // Strings result = result.replace(/('[^']*')/g, '<span class="text-success">$1</span>') return result } function highlightCompiledSqlLine(line: string): string { if (!line) return '' const escaped = escapeHtml(line) // Comments if (escaped.trim().startsWith('--')) { return `<span class="text-muted-foreground/60 italic">${escaped}</span>` } let result = escaped.replace( /\b(MERGE INTO|USING|WHEN MATCHED|WHEN NOT MATCHED|THEN UPDATE SET|THEN INSERT|VALUES|WITH|SELECT|FROM|LEFT JOIN|INNER JOIN|RIGHT JOIN|JOIN|ON|WHERE|GROUP BY|ORDER BY|AND|OR|NOT|AS|CASE|WHEN|THEN|ELSE|END)\b/g, '<span class="text-info font-semibold">$1</span>', ) result = result.replace( /\b(coalesce|sum|count|max|min|avg|round|cast)\b/gi, '<span class="text-chart-2 font-medium">$1</span>', ) // Qualified warehouse identifiers in double quotes result = result.replace(/("[A-Z0-9_]+")/g, '<span class="text-warning font-medium">$1</span>') // Strings result = result.replace(/('[^']*')/g, '<span class="text-success">$1</span>') return result } // --- Actions --- function handleBuildModel() { if (isBuilding.value) return isBuilding.value = true setTimeout(() => { isBuilding.value = false buildStatusText.value = 'Success · Built in 14.2s (Just now)' lastBuildTime.value = 'Just now' }, 1200) } function handleTestModel() { if (isTesting.value) return isTesting.value = true setTimeout(() => { isTesting.value = false }, 900) } function copyModelRef() { if (typeof navigator !== 'undefined' && navigator.clipboard) { navigator.clipboard.writeText("{{ ref('fct_orders') }}") copiedRef.value = true setTimeout(() => { copiedRef.value = false }, 2000) } } function copySourceSql() { if (typeof navigator !== 'undefined' && navigator.clipboard) { navigator.clipboard.writeText(modelSqlSource) copiedSql.value = true setTimeout(() => { copiedSql.value = false }, 2000) } } function copyCompiledSql() { if (typeof navigator !== 'undefined' && navigator.clipboard) { navigator.clipboard.writeText(compiledSqlSource) copiedCompiled.value = true setTimeout(() => { copiedCompiled.value = false }, 2000) } } </script> <template> <div data-slot="dbt-model-graph" :class=" cn( 'bg-background text-foreground border-border flex w-full flex-col overflow-hidden rounded-xl border shadow-xs', props.class, ) " > <!-- TOP HEADER --> <header class="border-border bg-card/70 border-b px-4 py-3 sm:px-6"> <div class="flex flex-col gap-3 lg:flex-row lg:items-center lg:justify-between"> <!-- Left: Model Identity & Badges --> <div class="flex flex-wrap items-center gap-2.5"> <div class="bg-primary/10 text-primary flex size-8 items-center justify-center rounded-lg shadow-xs"> <Workflow class="size-4" /> </div> <div class="flex flex-wrap items-center gap-2"> <div class="flex items-center gap-1.5 font-mono text-sm font-semibold tracking-tight"> <span class="text-muted-foreground font-normal">model.analytics.</span> <span class="text-foreground">fct_orders</span> </div> <!-- Copy ref pill --> <button type="button" class="border-border bg-muted/50 text-muted-foreground hover:text-foreground hover:bg-muted inline-flex min-h-6 items-center gap-1 rounded-md border px-2 py-0.5 font-mono text-xs transition-colors" title="Copy dbt ref() macro" @click="copyModelRef" > <Check v-if="copiedRef" class="text-success size-3" /> <Copy v-else class="size-3" /> <span>{{ copiedRef ? 'Copied Ref!' : dbtMacroRef }}</span> </button> </div> <div class="flex flex-wrap items-center gap-1.5"> <!-- Materialization Badge --> <Badge wrap variant="outline" class="gap-1 font-mono text-xs font-normal"> <Layers class="text-info size-3" /> Table · Incremental </Badge> <!-- dbt Package Badge --> <Badge wrap variant="secondary" class="font-mono text-xs font-normal"> analytics_dw v1.8 </Badge> <!-- Build Status Badge --> <Badge wrap variant="outline" class="border-success/30 bg-success/10 text-success gap-1.5 font-mono text-xs font-medium" > <span class="bg-success size-1.5 animate-pulse rounded-full" /> {{ buildStatusText }} </Badge> </div> </div> <!-- Right: Primary & Secondary Actions --> <div class="flex flex-wrap items-center gap-2"> <Button variant="outline" size="sm" class="h-8 gap-1.5 text-xs font-medium" :disabled="isTesting" @click="handleTestModel" > <Loader2 v-if="isTesting" class="size-3.5 animate-spin" /> <CheckCircle2 v-else class="text-success size-3.5" /> {{ isTesting ? 'Running 7 Tests...' : 'Test Model (dbt test)' }} </Button> <Button variant="default" size="sm" class="bg-primary text-primary-foreground hover:bg-primary/90 h-8 gap-1.5 text-xs font-semibold shadow-xs" :disabled="isBuilding" @click="handleBuildModel" > <Loader2 v-if="isBuilding" class="size-3.5 animate-spin" /> <Play v-else class="size-3.5 fill-current" /> {{ isBuilding ? 'Building (dbt run)...' : 'Build Model (dbt run)' }} </Button> </div> </div> <!-- Secondary Metadata Strip --> <div class="border-border/60 text-muted-foreground mt-3 flex flex-wrap items-center gap-x-4 gap-y-1.5 border-t pt-2.5 font-mono text-xs" > <div class="flex items-center gap-1.5"> <Database class="text-info size-3" /> <span>Warehouse:</span> <span class="text-foreground font-medium">Snowflake PROD_WH (XS)</span> </div> <div class="flex items-center gap-1.5"> <HardDrive class="text-warning size-3" /> <span>Target Schema:</span> <span class="text-foreground font-medium">ANALYTICS_PROD.MARTS</span> </div> <div class="flex items-center gap-1.5"> <Clock class="text-muted-foreground size-3" /> <span>Last Built:</span> <span class="text-foreground">{{ lastBuildTime }}</span> </div> <div class="flex items-center gap-1.5"> <ShieldCheck class="text-success size-3" /> <span>Contract Tests:</span> <span class="text-success font-medium">7/7 Passing</span> </div> <div class="flex items-center gap-1.5"> <Table2 class="text-chart-1 size-3" /> <span>Row Count:</span> <span class="text-foreground">2,840,190 rows</span> </div> </div> </header> <!-- 2-COLUMN MODEL STUDIO LAYOUT --> <div class="divide-border grid flex-1 grid-cols-1 divide-y lg:grid-cols-12 lg:divide-x lg:divide-y-0"> <!-- LEFT PANEL: METADATA & DAG LINEAGE (lg:col-span-5) --> <aside class="bg-muted/15 flex flex-col space-y-4 p-4 sm:p-5 lg:col-span-5"> <!-- Interactive Lineage DAG Card --> <Card class="border-border bg-card overflow-hidden border p-3.5 shadow-none"> <div class="flex flex-wrap items-center justify-between pb-2.5"> <div class="flex items-center gap-1.5 text-xs font-semibold"> <GitBranch class="text-primary size-3.5" /> <span>DAG Lineage Dependency Graph</span> </div> <Badge wrap variant="secondary" class="font-mono text-xs font-normal"> -1 Upstream · +1 Downstream </Badge> </div> <!-- Visual DAG Node Canvas --> <div class="border-border/70 bg-muted/30 relative rounded-lg border p-3"> <div class="grid grid-cols-3 items-center gap-2 text-xs"> <!-- Upstream Column (3 Nodes) --> <div class="space-y-1.5"> <span class="text-muted-foreground block text-center font-mono text-xs font-medium">Upstream (3)</span> <button v-for="node in upstreamNodes" :key="node.id" type="button" :class=" cn( 'focus-visible:ring-ring flex w-full cursor-pointer flex-col rounded-md border p-1.5 text-left transition-[background-color,box-shadow] focus-visible:ring-2 focus-visible:outline-none', selectedNodeId === node.id ? 'border-primary bg-primary/10 text-primary shadow-xs' : 'border-border bg-background hover:bg-muted/80 text-foreground', ) " :aria-pressed="selectedNodeId === node.id" @click="selectedNodeId = node.id" > <div class="flex flex-wrap items-center justify-between"> <span class="truncate font-mono text-xs font-medium">{{ node.name }}</span> </div> <div class="text-muted-foreground flex flex-wrap items-center justify-between pt-0.5 font-mono text-xs" > <span class="uppercase">{{ node.type }}</span> <span class="bg-success size-1.5 rounded-full" /> </div> </button> </div> <!-- Center Current Node --> <div class="flex flex-col items-center justify-center space-y-1 px-1"> <span class="text-primary font-mono text-xs font-semibold">Current Model</span> <button type="button" :class=" cn( 'border-primary bg-primary/10 ring-primary/20 focus-visible:ring-ring flex w-full cursor-pointer flex-col items-center justify-center rounded-lg border-2 p-2.5 text-center shadow-xs ring-2 focus-visible:ring-2 focus-visible:outline-none', selectedNodeId === 'fct_orders' && 'ring-primary/40', ) " :aria-pressed="selectedNodeId === 'fct_orders'" @click="selectedNodeId = 'fct_orders'" > <Workflow class="text-primary mb-1 size-4" /> <span class="text-foreground font-mono text-xs font-bold">fct_orders</span> <Badge wrap variant="outline" class="border-primary/40 mt-1 font-mono text-xs"> incremental </Badge> </button> </div> <!-- Downstream Column (3 Nodes) --> <div class="space-y-1.5"> <span class="text-muted-foreground block text-center font-mono text-xs font-medium" >Downstream (3)</span > <button v-for="node in downstreamNodes" :key="node.id" type="button" :class=" cn( 'focus-visible:ring-ring flex w-full cursor-pointer flex-col rounded-md border p-1.5 text-left transition-[background-color,box-shadow] focus-visible:ring-2 focus-visible:outline-none', selectedNodeId === node.id ? 'border-primary bg-primary/10 text-primary shadow-xs' : 'border-border bg-background hover:bg-muted/80 text-foreground', ) " :aria-pressed="selectedNodeId === node.id" @click="selectedNodeId = node.id" > <div class="flex flex-wrap items-center justify-between"> <span class="truncate font-mono text-xs font-medium">{{ node.name }}</span> </div> <div class="text-muted-foreground flex flex-wrap items-center justify-between pt-0.5 font-mono text-xs" > <span class="uppercase">{{ node.type }}</span> <span class="bg-success size-1.5 rounded-full" /> </div> </button> </div> </div> </div> </Card> <!-- Model Documentation & Metadata Card --> <Card class="border-border bg-card space-y-3 border p-4 shadow-none"> <div class="border-border flex flex-wrap items-center justify-between border-b pb-2"> <div class="flex items-center gap-1.5 text-xs font-semibold"> <Info class="text-primary size-3.5" /> <span>Model Documentation & Metadata</span> </div> <Badge wrap variant="outline" class="font-mono text-xs"> Contract Enforced </Badge> </div> <p class="text-muted-foreground text-xs leading-relaxed"> Core transactional orders fact table at individual order grain. Captures gross revenue metrics, sales tax breakdowns, promotional discount allocations, payment gateway fees, and settlement lifecycle stages. </p> <div class="grid grid-cols-1 gap-2 sm:grid-cols-2"> <div class="border-border/60 bg-muted/20 space-y-0.5 rounded-md border p-2 text-xs"> <span class="text-muted-foreground text-xs">Model Owner</span> <div class="flex items-center gap-1.5 font-medium"> <User class="text-primary size-3" /> <span>Analytics Engineering</span> </div> </div> <div class="border-border/60 bg-muted/20 space-y-0.5 rounded-md border p-2 text-xs"> <span class="text-muted-foreground text-xs">Freshness SLA</span> <div class="text-success flex items-center gap-1.5 font-medium"> <Zap class="text-warning size-3" /> <span>< 2 hours (Compliant)</span> </div> </div> </div> <!-- Tags --> <div class="space-y-1.5 pt-1"> <span class="text-muted-foreground flex items-center gap-1 text-xs"> <Tag class="size-3" /> Model Tags </span> <div class="flex flex-wrap items-center gap-1.5"> <Badge wrap variant="secondary" class="font-mono text-xs font-normal">#finance</Badge> <Badge wrap variant="secondary" class="font-mono text-xs font-normal">#core</Badge> <Badge wrap variant="secondary" class="font-mono text-xs font-normal">#daily_sla</Badge> <Badge wrap variant="secondary" class="font-mono text-xs font-normal">#tier-1-kpi</Badge> </div> </div> <!-- Cluster Keys & Strategy --> <div class="border-border/60 bg-muted/30 space-y-1.5 rounded-lg border p-2.5 font-mono text-xs"> <div class="flex justify-between"> <span class="text-muted-foreground">Incremental Strategy:</span> <span class="text-foreground font-semibold">Merge (unique_key: order_id)</span> </div> <div class="flex justify-between"> <span class="text-muted-foreground">Cluster Keys:</span> <span class="text-foreground font-semibold">order_date, customer_id</span> </div> </div> </Card> <!-- Upstream Sources & References List --> <Card class="border-border bg-card space-y-2.5 border p-4 shadow-none"> <div class="flex flex-wrap items-center justify-between"> <div class="flex items-center gap-1.5 text-xs font-semibold"> <Link2 class="text-info size-3.5" /> <span>Upstream Sources & References ({{ upstreamNodes.length }})</span> </div> <Badge wrap variant="secondary" class="font-mono text-xs font-normal"> {{ upstreamNodes.length }} models </Badge> </div> <div class="space-y-2"> <div v-for="node in upstreamNodes" :key="node.id" class="border-border/70 bg-muted/20 hover:bg-muted/40 rounded-lg border p-2.5 text-xs transition-colors" > <div class="flex flex-wrap items-center justify-between"> <span class="text-foreground font-mono font-semibold">{{ node.name }}</span> <Badge wrap variant="outline" class="font-mono text-xs uppercase"> {{ node.type }} </Badge> </div> <p class="text-muted-foreground mt-1 text-xs"> {{ node.description }} </p> <div class="text-muted-foreground mt-2 flex flex-wrap items-center justify-between font-mono text-xs"> <span>{{ node.rowCount }}</span> <span class="text-success font-medium">{{ node.freshness }}</span> </div> </div> </div> </Card> <!-- Downstream Marts & BI Exporters List --> <Card class="border-border bg-card space-y-2.5 border p-4 shadow-none"> <div class="flex flex-wrap items-center justify-between"> <div class="flex items-center gap-1.5 text-xs font-semibold"> <ArrowUpRight class="text-warning size-3.5" /> <span>Downstream Marts & BI Exposures ({{ downstreamNodes.length }})</span> </div> <Badge wrap variant="secondary" class="font-mono text-xs font-normal"> {{ downstreamNodes.length }} targets </Badge> </div> <div class="space-y-2"> <div v-for="node in downstreamNodes" :key="node.id" class="border-border/70 bg-muted/20 hover:bg-muted/40 rounded-lg border p-2.5 text-xs transition-colors" > <div class="flex flex-wrap items-center justify-between"> <span class="text-foreground font-mono font-semibold">{{ node.name }}</span> <Badge wrap variant="secondary" class="font-mono text-xs uppercase"> {{ node.type }} </Badge> </div> <p class="text-muted-foreground mt-1 text-xs"> {{ node.description }} </p> <div class="text-muted-foreground mt-2 flex flex-wrap items-center justify-between font-mono text-xs"> <span class="truncate pr-2">Consumers: {{ node.consumers }}</span> <span class="text-foreground shrink-0 font-medium">{{ node.sla }}</span> </div> </div> </div> </Card> </aside> <!-- RIGHT PANEL: TABS STUDIO (lg:col-span-7) --> <main class="bg-card flex flex-col overflow-hidden lg:col-span-7"> <Tabs v-model="activeTab" default-value="model-sql" class="flex flex-1 flex-col"> <!-- Right Tab Header --> <div class="border-border bg-muted/30 flex flex-wrap items-center justify-between gap-2 border-b px-4 py-2"> <TabsList class="grid h-8 grid-cols-3"> <TabsTrigger value="model-sql" class="gap-1.5 text-xs"> <Code2 class="text-primary size-3.5" /> <span>Model SQL</span> </TabsTrigger> <TabsTrigger value="compiled-sql" class="gap-1.5 text-xs"> <FileCode class="text-info size-3.5" /> <span>Compiled SQL</span> </TabsTrigger> <TabsTrigger value="contract" class="gap-1.5 text-xs"> <ShieldCheck class="text-success size-3.5" /> <span>Model Contract & Tests</span> </TabsTrigger> </TabsList> <!-- Actions per active tab --> <div class="flex items-center gap-2"> <template v-if="activeTab === 'model-sql'"> <Button variant="ghost" size="sm" class="h-7 gap-1 text-xs" @click="copySourceSql"> <Check v-if="copiedSql" class="text-success size-3" /> <Copy v-else class="size-3" /> <span>{{ copiedSql ? 'Copied' : 'Copy SQL' }}</span> </Button> </template> <template v-else-if="activeTab === 'compiled-sql'"> <Button variant="ghost" size="sm" class="h-7 gap-1 text-xs" @click="copyCompiledSql"> <Check v-if="copiedCompiled" class="text-success size-3" /> <Copy v-else class="size-3" /> <span>{{ copiedCompiled ? 'Copied' : 'Copy Compiled' }}</span> </Button> </template> <template v-else-if="activeTab === 'contract'"> <Badge wrap variant="outline" class="text-success font-mono text-xs"> {{ passingTestsCount }} Tests Passing </Badge> </template> </div> </div> <!-- TAB 1: MODEL SQL --> <TabsContent value="model-sql" class="mt-0 flex flex-1 flex-col overflow-hidden"> <!-- Code Bar Meta --> <div class="border-border bg-muted/15 text-muted-foreground flex flex-wrap items-center justify-between border-b px-4 py-1.5 font-mono text-xs" > <div class="flex items-center gap-2"> <span class="text-foreground font-medium">fct_orders.sql</span> <span>·</span> <span>Jinja + Snowflake Dialect</span> </div> <div class="flex items-center gap-3"> <span>{{ modelSqlLines.length }} lines · {{ modelSqlSource.length }} chars</span> </div> </div> <!-- Code Gutter & Viewer --> <div class="relative flex flex-1 overflow-auto bg-neutral-950 text-neutral-100 dark:bg-neutral-950"> <!-- Line Numbers Gutter --> <div class="w-11 shrink-0 overflow-hidden border-r border-neutral-800 bg-neutral-900/60 py-3 pr-2 text-right font-mono text-xs leading-relaxed text-neutral-500 select-none" > <div v-for="n in modelSqlLines.length" :key="n">{{ n }}</div> </div> <!-- Highlighted Code Body --> <div class="flex-1 overflow-auto p-3 font-mono text-xs leading-relaxed"> <div v-for="(line, idx) in modelSqlLines" :key="idx" class="font-mono whitespace-pre" v-html="highlightJinjaSqlLine(line)" /> </div> </div> </TabsContent> <!-- TAB 2: COMPILED SQL --> <TabsContent value="compiled-sql" class="mt-0 flex flex-1 flex-col overflow-hidden"> <!-- Code Bar Meta --> <div class="border-border bg-muted/15 text-muted-foreground flex flex-wrap items-center justify-between border-b px-4 py-1.5 font-mono text-xs" > <div class="flex items-center gap-2"> <span class="text-foreground font-medium" >target/compiled/analytics_dw/models/marts/fct_orders.sql</span > </div> <div class="flex items-center gap-2"> <Badge wrap variant="outline" class="font-mono text-xs"> Est. Cost: 0.14 Credits · 1.4 GB Scan </Badge> </div> </div> <!-- Code Gutter & Viewer --> <div class="relative flex flex-1 overflow-auto bg-neutral-950 text-neutral-100 dark:bg-neutral-950"> <!-- Line Numbers Gutter --> <div class="w-11 shrink-0 overflow-hidden border-r border-neutral-800 bg-neutral-900/60 py-3 pr-2 text-right font-mono text-xs leading-relaxed text-neutral-500 select-none" > <div v-for="n in compiledSqlLines.length" :key="n">{{ n }}</div> </div> <!-- Highlighted Code Body --> <div class="flex-1 overflow-auto p-3 font-mono text-xs leading-relaxed"> <div v-for="(line, idx) in compiledSqlLines" :key="idx" class="font-mono whitespace-pre" v-html="highlightCompiledSqlLine(line)" /> </div> </div> </TabsContent> <!-- TAB 3: MODEL CONTRACT & TESTS --> <TabsContent value="contract" class="mt-0 flex flex-1 flex-col space-y-4 overflow-hidden p-4 sm:p-5"> <!-- Contract Control Bar --> <div class="flex flex-col gap-3 sm:flex-row sm:items-center sm:justify-between"> <div class="relative w-full sm:w-72"> <Search class="text-muted-foreground absolute top-1/2 left-2.5 size-3.5 -translate-y-1/2" /> <Input v-model="columnSearch" placeholder="Filter columns or tests..." class="h-8 pl-8 font-mono text-xs" /> </div> <div class="flex flex-wrap items-center gap-2"> <Badge wrap variant="outline" class="text-success gap-1 font-mono text-xs"> <ShieldCheck class="size-3" /> contract.enforced: true </Badge> <Badge wrap variant="secondary" class="font-mono text-xs"> {{ filteredColumns.length }} of {{ columns.length }} columns </Badge> </div> </div> <!-- Specifications Table --> <Card class="border-border flex-1 overflow-hidden border shadow-none"> <div class="overflow-x-auto"> <Table> <TableHeader> <TableRow class="bg-muted/40 hover:bg-muted/40"> <TableHead class="text-xs font-semibold">Column Name</TableHead> <TableHead class="text-xs font-semibold">Data Type</TableHead> <TableHead class="text-xs font-semibold">Nullability</TableHead> <TableHead class="text-xs font-semibold">Active Tests & Constraints</TableHead> <TableHead class="text-xs font-semibold">Latency</TableHead> <TableHead class="text-xs font-semibold">Description</TableHead> </TableRow> </TableHeader> <TableBody> <TableRow v-for="col in filteredColumns" :key="col.name" class="text-xs"> <TableCell class="font-mono font-medium"> <div class="flex items-center gap-1.5"> <Key v-if="col.isPrimaryKey" class="text-warning size-3.5 shrink-0" /> <Link2 v-else-if="col.isForeignKey" class="text-info size-3.5 shrink-0" /> <span :class="cn(col.isPrimaryKey && 'text-warning font-semibold')"> {{ col.name }} </span> </div> </TableCell> <TableCell> <Badge wrap variant="secondary" class="font-mono text-xs font-normal"> {{ col.dataType }} </Badge> </TableCell> <TableCell> <Badge wrap v-if="!col.nullable" variant="outline" class="text-muted-foreground font-mono text-xs" > NOT NULL </Badge> <span v-else class="text-muted-foreground font-mono text-xs">NULLABLE</span> </TableCell> <TableCell> <div class="flex flex-wrap items-center gap-1"> <Badge wrap v-if="col.isPrimaryKey" class="border-warning/30 bg-warning/15 text-warning font-mono text-xs" > PK </Badge> <Badge wrap v-if="col.isClusterKey" variant="secondary" class="border-chart-1/30 bg-chart-1/15 text-chart-1 font-mono text-xs" > CLUSTER </Badge> <Badge wrap v-for="test in col.tests" :key="test.name" variant="secondary" class="gap-1 font-mono text-xs" > <span class="bg-success size-1.5 rounded-full" /> {{ test.name }}{{ test.detail ? ` (${test.detail})` : '' }} </Badge> </div> </TableCell> <TableCell class="text-muted-foreground font-mono text-xs"> {{ col.testDuration }} </TableCell> <TableCell class="text-muted-foreground max-w-[220px] truncate text-xs"> {{ col.description }} </TableCell> </TableRow> </TableBody> </Table> </div> </Card> <!-- Bottom Summary Banner --> <div class="border-border bg-muted/20 flex flex-wrap items-center justify-between gap-3 rounded-lg border p-3 text-xs" > <div class="flex items-center gap-2"> <ShieldCheck class="text-success size-4" /> <span class="text-foreground font-medium">Model Contract Coverage: 100% Enforced</span> </div> <div class="text-muted-foreground flex items-center gap-4 font-mono text-xs"> <span>18 Columns</span> <span>·</span> <span>21 Assertions</span> <span>·</span> <span class="text-success font-semibold">0 Failures</span> </div> </div> </TabsContent> </Tabs> </main> </div> </div> </template>
Raw manifest:https://uipkge.dev/r/vue/dbt-model-graph.json