Setting the file. One moment.
Skill 17 · Data Context Extractor
Subchapter 17.3
references/skill-template.mdMarkdown4 KBView on GitHub
Use this template when generating a new data analysis skill. Replace all [PLACEHOLDER] values.
---
name: [company]-data-analyst
description: "[COMPANY] data analysis skill. Provides context for querying [WAREHOUSE_TYPE] including entity definitions, metric calculations, and common query patterns. Use when analyzing [COMPANY] data for: (1) [PRIMARY_USE_CASE_1], (2) [PRIMARY_USE_CASE_2], (3) [PRIMARY_USE_CASE_3], or any data questions requiring [COMPANY]-specific context."
---
# [COMPANY] Data Analysis
## SQL Dialect: [WAREHOUSE_TYPE]
[INSERT APPROPRIATE DIALECT SECTION FROM sql-dialects.md]
---
## Entity Disambiguation
When users mention these terms, clarify which entity they mean:
[EXAMPLE FORMAT - customize based on discovery:]
**"User" can mean:**
- **Account**: An individual login/profile ([PRIMARY_TABLE]: [ID_FIELD])
- **Organization**: A billing entity that can have multiple accounts ([ORG_TABLE]: [ORG_ID])
- **[OTHER_TYPE]**: [DEFINITION] ([TABLE]: [ID])
**Relationships:**
- [ENTITY_1] → [ENTITY_2]: [RELATIONSHIP_TYPE] (join on [JOIN_KEY])
---
## Business Terminology
| Term | Definition | Notes |
|------|------------|-------|
| [TERM_1] | [DEFINITION] | [CONTEXT/GOTCHA] |
| [TERM_2] | [DEFINITION] | [CONTEXT/GOTCHA] |
| [ACRONYM] | [FULL_NAME] - [EXPLANATION] | |
---
## Standard Filters
Always apply these filters unless explicitly told otherwise:
```sql
-- Exclude test/internal data
WHERE [TEST_FLAG_COLUMN] = FALSE
AND [INTERNAL_FLAG_COLUMN] = FALSE
-- Exclude invalid/fraud
AND [STATUS_COLUMN] != '[EXCLUDED_STATUS]'
-- [OTHER STANDARD EXCLUSIONS]When to override:
[EXACT_CALCULATION][TABLE_NAME].[COLUMN_NAME][REPEAT FORMAT]
| Table | Update Frequency | Typical Lag |
|---|---|---|
| [TABLE_1] | [FREQUENCY] | [LAG] |
| [TABLE_2] | [FREQUENCY] | [LAG] |
To check data freshness:
SELECT MAX([DATE_COLUMN]) as latest_data FROM [TABLE]Use these reference files for detailed table documentation:
| Domain | Reference File | Use For |
|---|---|---|
| [DOMAIN_1] | references/[domain1].md | [BRIEF_DESCRIPTION] |
| [DOMAIN_2] | references/[domain2].md | [BRIEF_DESCRIPTION] |
| Entities | references/entities.md | Entity definitions and relationships |
| Metrics | references/metrics.md | KPI calculations and formulas |
[SAMPLE_QUERY][SAMPLE_QUERY][TABLE]: [WORKAROUND][PARTITION_COLUMN] first to reduce data scannedLIMIT during exploration[AGGREGATED_TABLE] over [RAW_TABLE] when possible
---
## Customization Notes
When generating a skill:
1. **Fill all placeholders** - Don't leave any `[PLACEHOLDER]` text
2. **Remove unused sections** - If they don't have dashboards, remove that section
3. **Add specificity** - Generic advice is less useful than specific column names and values
4. **Include real examples** - Sample queries should use actual table/column names
5. **Keep it scannable** - Use tables and code blocks liberally