Zeigt Zeilenanzahl aller Tabellen
Displays row counts for all Data Vault tables across staging, raw vault, business vault, and mart layers. Use it to monitor table sizes and track data growth across your data warehouse layers.
/plugin marketplace add fellnerd/claude-marketplace/plugin install datavault@dimetrics-marketplaceZeige die Zeilenanzahl aller Data Vault Tabellen.
Tool: get_row_counts
Args: { "schema": "{{SCHEMA}}" }
Tool: get_row_counts
Args: { "schema": "all" }
═══════════════════════════════════════
Zeilenanzahl: Data Vault
═══════════════════════════════════════
📊 STAGING [stg]
──────────────────────────────────────
ext_company 1,500
ext_country 195
ext_product 5,800
─────────────────────────────────
Summe Staging: 7,495
📊 RAW VAULT [vault]
──────────────────────────────────────
hub_company 1,234
hub_country 195
hub_product 5,678
─────────────────────────────────
sat_company 2,456
sat_company_status 3,789
sat_country 195
─────────────────────────────────
link_company_country 1,234
link_company_product 8,901
─────────────────────────────────
Summe Raw Vault: 23,682
📊 BUSINESS VAULT [vault]
──────────────────────────────────────
pit_company 45,678
─────────────────────────────────
Summe Business Vault: 45,678
📊 MARTS [mart]
──────────────────────────────────────
company_current_v 1,234
─────────────────────────────────
Summe Marts: 1,234
═══════════════════════════════════════
GESAMT: 78,089
═══════════════════════════════════════
⏱️ Stand: 2024-01-15 14:30:00
| Layer | Tabellen | Zeilen | Wachstum/Tag |
|---|---|---|---|
| Staging | 3 | 7,495 | +150 |
| Raw Vault | 8 | 23,682 | +500 |
| Business Vault | 1 | 45,678 | +1,200 |
/db-counts
/db-counts vault
/db-counts stg