# Data Lineage & Dependencies

Generated on: 2026-01-09 10:21:05

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

## Overview

- **Total Models:** 1
- **Total Views:** 3
- **Derived Views:** 3
- **Direct Table Views:** 0

## Model Dependencies

### Models and Their Views

#### integration_team
- **Includes:** 2 views
- **Views:**
  - `phonofile_validation_view.view`
  - `phonofile_bulk_upload_looker_view.view`

## View Dependencies

### Views by Data Source

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

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

Total: 3 views

| View | Lines of Code | Source Tables |
|------|---------------|---------------|
| `phonofile_bulk_upload_looker_view` | 632 |  Dev.Phonofile_Bulk_Upload |
| `phonofile_bulk_upload_looker_view_old` | 555 |  Dev.Phonofile_Bulk_Upload |
| `phonofile_validation_view` | 198 |  Dev.Validation_View |


## Explore Relationships

### Explores and Their Dependencies

#### Model: integration_team

**phonofile_validation** (Phonofile Validation Summary)
- Base View: `phonofile_validation`
- View Type: Direct Table
- Data Source: Unknown

**phonofile_bulk_upload** (Phonofile Bulk Upload Summary)
- Base View: `phonofile_bulk_upload`
- View Type: Direct Table
- Data Source: Unknown

## 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