# Data Lineage & Dependencies

Generated on: 2026-01-09 10:06:19

This document shows the relationships and dependencies between models, views, and data sources.

## Overview

- **Total Models:** 1
- **Total Views:** 17
- **Derived Views:** 5
- **Direct Table Views:** 12

## Model Dependencies

### Models and Their Views

#### Label_Review
- **Includes:** 1 views
- **Views:**
  - `*`

## View Dependencies

### Views by Data Source

#### Direct Database Tables
Views that directly reference database tables:

**DBT_PROD_LABEL_REVIEWS.LABEL_REVIEW_ACCOUNTING_NON_RELEASE_LEVEL**
- Used by 1 views: `INTELLIGENCE_DBT_PROD_LABEL_REVIEWS_LABEL_REVIEW_ACCOUNTING_NON_RELEASE_LEVEL`


**DBT_PROD_LABEL_REVIEWS.LABEL_REVIEW_ACCOUNTING_RELEASE_LEVEL**
- Used by 1 views: `INTELLIGENCE_DBT_PROD_LABEL_REVIEWS_LABEL_REVIEW_ACCOUNTING_RELEASE_LEVEL`


**DBT_PROD_LABEL_REVIEWS.LABEL_REVIEW_ANALYTICS_ALL_STORES**
- Used by 1 views: `label_review_analytics_all_stores`


**DBT_PROD_LABEL_REVIEWS.LABEL_REVIEW_ANALYTICS_AMAZON**
- Used by 1 views: `INTELLIGENCE_DBT_PROD_LABEL_REVIEWS_LABEL_REVIEW_ANALYTICS_AMAZON`


**DBT_PROD_LABEL_REVIEWS.LABEL_REVIEW_ANALYTICS_APPLE**
- Used by 1 views: `INTELLIGENCE_DBT_PROD_LABEL_REVIEWS_LABEL_REVIEW_ANALYTICS_APPLE`


**DBT_PROD_LABEL_REVIEWS.LABEL_REVIEW_ANALYTICS_FIRST_MONTH_STREAMS**
- Used by 1 views: `INTELLIGENCE_DBT_PROD_LABEL_REVIEWS_LABEL_REVIEW_ANALYTICS_FIRST_MONTH_STREAMS`


**DBT_PROD_LABEL_REVIEWS.LABEL_REVIEW_ANALYTICS_PANDORA**
- Used by 1 views: `INTELLIGENCE_DBT_PROD_LABEL_REVIEWS_LABEL_REVIEW_ANALYTICS_PANDORA`


**DBT_PROD_LABEL_REVIEWS.LABEL_REVIEW_ANALYTICS_SPOTIFY**
- Used by 1 views: `INTELLIGENCE_DBT_PROD_LABEL_REVIEWS_LABEL_REVIEW_ANALYTICS_SPOTIFY`


**DBT_PROD_LABEL_REVIEWS.LABEL_REVIEW_EDITORIAL_PLAYLIST_PLACEMENTS**
- Used by 1 views: `INTELLIGENCE_DBT_PROD_LABEL_REVIEWS_LABEL_REVIEW_EDITORIAL_PLAYLIST_PLACEMENTS`


**DBT_PROD_LABEL_REVIEWS.LABEL_REVIEW_MARKET_SHARE**
- Used by 1 views: `INTELLIGENCE_DBT_PROD_LABEL_REVIEWS_LABEL_REVIEW_MARKET_SHARE`


**DBT_PROD_LABEL_REVIEWS.LABEL_REVIEW_PHYSICAL**
- Used by 1 views: `label_review_physical`


**prod.dim_label**
- Used by 1 views: `facts.prod.dim_label`


#### Derived Tables
Views with custom SQL (complex transformations):

Total: 5 views

| View | Lines of Code | Source Tables |
|------|---------------|---------------|
| `dt_label_review_accounting_release_level_country_release_ran` | 50 |  Dbt_Prod_Label_Reviews.Label_Review_Accounting... |
| `dt_label_review_accounting_release_level_country_artist_rank` | 44 |  Dbt_Prod_Label_Reviews.Label_Review_Accounting... |
| `dt_label_review_accounting_non_release_level_country_store_rank` | 43 |  Dbt_Prod_Label_Reviews.Label_Review_Accounting... |
| `dt_label_review_accounting_release_level_country_rank` | 37 |  Dbt_Prod_Label_Reviews.Label_Review_Accounting... |
| `dt_label_review_accounting_non_release_level_country_rank` | 36 |  Dbt_Prod_Label_Reviews.Label_Review_Accounting... |


## Explore Relationships

### Explores and Their Dependencies

#### Model: Label_Review

**LABEL_REVIEW_ACCOUNTING_NON_RELEASE_LEVEL** (Label)
- Base View: `LABEL_REVIEW_ACCOUNTING_NON_RELEASE_LEVEL`
- View Type: Direct Table
- Data Source: Unknown

**LABEL_REVIEW_ACCOUNTING_RELEASE_LEVEL** (Rank)
- Base View: `LABEL_REVIEW_ACCOUNTING_RELEASE_LEVEL`
- View Type: Direct Table
- Data Source: Unknown

**LABEL_REVIEW_ANALYTICS_AMAZON** (Label Review Analytics Amazon)
- Base View: `LABEL_REVIEW_ANALYTICS_AMAZON`
- View Type: Direct Table
- Data Source: Unknown

**LABEL_REVIEW_ANALYTICS_APPLE** (Label Review Analytics Apple)
- Base View: `LABEL_REVIEW_ANALYTICS_APPLE`
- View Type: Direct Table
- Data Source: Unknown

**LABEL_REVIEW_ANALYTICS_FIRST_MONTH_STREAMS** (Label Review Analytics First Month Streams)
- Base View: `LABEL_REVIEW_ANALYTICS_FIRST_MONTH_STREAMS`
- View Type: Direct Table
- Data Source: Unknown

**INTELLIGENCE_DBT_PROD_LABEL_REVIEWS_LABEL_REVIEW_ANALYTICS_PANDORA** (Label Review Analytics Pandora)
- Base View: `INTELLIGENCE_DBT_PROD_LABEL_REVIEWS_LABEL_REVIEW_ANALYTICS_PANDORA`
- View Type: Direct Table
- Data Source: INTELLIGENCE.DBT_PROD_LABEL_REVIEWS.LABEL_REVIEW_ANALYTICS_PANDORA

**intelligence_dbt_prod_label_reviews_label_review_analytics_spotify** (Label Review Analytics Spotify)
- Base View: `intelligence_dbt_prod_label_reviews_label_review_analytics_spotify`
- View Type: Direct Table
- Data Source: Unknown

**intelligence_dbt_prod_label_reviews_label_review_editorial_playlist_placements** (Label Review Editorial Playlist Placements)
- Base View: `intelligence_dbt_prod_label_reviews_label_review_editorial_playlist_placements`
- View Type: Direct Table
- Data Source: Unknown

**intelligence_dbt_prod_label_reviews_label_review_market_share** (Label Review Market Share)
- Base View: `intelligence_dbt_prod_label_reviews_label_review_market_share`
- View Type: Direct Table
- Data Source: Unknown

**label_review_analytics_all_stores** (Label Review Analytics All Stores)
- Base View: `label_review_analytics_all_stores`
- View Type: Direct Table
- Data Source: INTELLIGENCE.DBT_PROD_LABEL_REVIEWS.LABEL_REVIEW_ANALYTICS_ALL_STORES

**label_review_physical** (Label Review Physical)
- Base View: `label_review_physical`
- View Type: Direct Table
- Data Source: INTELLIGENCE.DBT_PROD_LABEL_REVIEWS.LABEL_REVIEW_PHYSICAL

## Impact Analysis Guide

### Making Changes Safely

1. **Before changing a database table:**
   - Check "Views by Data Source" section above
   - Identify all views that use the table
   - Review explores that depend on those views

2. **Before modifying a view:**
   - Check which models include the view
   - Review explores that use the view as base
   - Consider downstream reporting impact

3. **Before changing a model:**
   - Review all explores in the model
   - Check business usage of those explores
   - Coordinate with report consumers

### Complexity Indicators

- **High Line Count Views**: Complex business logic, may need optimization
- **Many Source Tables**: Complex joins, potential performance impact
- **Multiple Dependencies**: Changes have wide impact, need careful testing