# <!-- FILL: Partner Name --> Data Overview

## Databases and Schemas

<!-- FILL: One subsection per database/schema. List every queryable object (tables, views, external tables, etc.).
Group by category (metadata, facts, reference/lookup, mapping, etc.) -->

### <!-- FILL: DATABASE.SCHEMA --> (<!-- FILL: short label, e.g., "Vendor Datashare", "Internal Tables" -->)

<!-- FILL: Brief description of this database/schema -->

**<!-- FILL: Category name, e.g., "Metadata tables" -->:**
- `<!-- FILL: OBJECT_NAME -->` — <!-- FILL: one-line description -->

**<!-- FILL: Category name, e.g., "Fact / metric tables" -->:**
- `<!-- FILL: OBJECT_NAME -->` — <!-- FILL: one-line description -->

**<!-- FILL: Category name, e.g., "Reference / lookup tables" -->:**
- `<!-- FILL: OBJECT_NAME -->` — <!-- FILL: one-line description -->

<!-- Repeat subsection for each additional database/schema -->

## Entity Types

<!-- FILL: Describe the core entity types this partner uses and their hierarchy (if any).
Include the primary ID column for each entity. -->

| Entity | ID Column | External ID | Common Name |
|--------|-----------|-------------|-------------|
| <!-- FILL --> | <!-- FILL --> | <!-- FILL or N/A --> | <!-- FILL --> |

## Fact Table Variants

<!-- SKIP this section if this partner has only one type of fact table.
EXTRACT to a separate reference file if this section exceeds ~50 lines
(add a routing row in SKILL.md pointing to the extracted file). -->

<!-- FILL: If this partner has multiple fact table types at different granularities
(e.g., detail vs summary, daily vs weekly, national vs regional), document them here. -->

| Type | Naming Pattern | Granularity | Key Differences |
|------|---------------|-------------|-----------------|
| <!-- FILL --> | <!-- FILL --> | <!-- FILL --> | <!-- FILL --> |

<!-- FILL: For each type, briefly note:
- Which tables belong to it
- Key characteristics (what columns are unique to this type)
- When to use it
-->

### Choosing the Right Table

<!-- FILL: Quick decision tree for analysts. Example:
1. Need granular/regional data? → Detail table
2. Need provider breakdown? → Provider table
3. None of the above? → Summary table (default)
-->

## Internal / Pre-Aggregated Models

<!-- SKIP this section if your team has not built pre-aggregated models for this partner.
EXTRACT to a separate reference file if this section exceeds ~50 lines
(add a routing row in SKILL.md pointing to the extracted file). -->

**Database/Schema**: `<!-- FILL: DATABASE.SCHEMA -->`

| Model | Grain | Entities | Notes |
|-------|-------|----------|-------|
| `<!-- FILL -->` | <!-- FILL: e.g., monthly, period-end --> | <!-- FILL --> | <!-- FILL --> |

<!-- FILL: Note any column differences from the raw source tables (e.g., REPORT_DATE removed,
REFRESHED_AT added, MONTH_START_DATE added). -->

### When to Use Models vs Raw Tables

| Need | Use |
|------|-----|
| <!-- FILL: common use case --> | <!-- FILL: model name --> |
| <!-- FILL: need that requires raw tables --> | Raw tables |

### Checking Freshness

```sql
SELECT MAX(REFRESHED_AT) FROM <!-- FILL: DATABASE.SCHEMA.MODEL -->;
```

## Data Refresh

<!-- FILL: When is data updated? Nightly? Weekly? What timezone? Any downtime?
Include refresh schedules for both raw data and internal models (if applicable). -->