# Data Lineage & Dependencies

Generated on: 2026-01-08 16:09:47

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

## Overview

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

## Model Dependencies

### Models and Their Views

#### altafonte_singlestore_model
- **Includes:** 3 views
- **Views:**
  - `fact_prod_altafonte_singlestore_informes`
  - `fact_prod_altafonte_singlestore_informes_users`
  - `fact_prod_altafonte_singlestore_resources`

#### reporting_altafonte
- **Includes:** 2 views
- **Views:**
  - `fact_prod_altafonte_singlestore_informes`
  - `fact_prod_altafonte_singlestore_resources`

## View Dependencies

### Views by Data Source

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

**PROD.ALTAFONTE_SINGLESTORE_INFORMES**
- Used by 1 views: `fact_prod_altafonte_singlestore_informes`


**PROD.ALTAFONTE_SINGLESTORE_INFORMES_USERS**
- Used by 1 views: `fact_prod_altafonte_singlestore_informes_users`


**PROD.ALTAFONTE_SINGLESTORE_RESOURCES**
- Used by 1 views: `fact_prod_altafonte_singlestore_resources`


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

Total: 0 views

| View | Lines of Code | Source Tables |
|------|---------------|---------------|


## Explore Relationships

### Explores and Their Dependencies

#### Model: altafonte_singlestore_model

**fact_prod_altafonte_singlestore_informes** (Single Store Informes)
- Base View: `fact_prod_altafonte_singlestore_informes`
- View Type: Direct Table
- Data Source: FACTS.PROD.ALTAFONTE_SINGLESTORE_INFORMES

**fact_prod_altafonte_singlestore_informes_users** (Single Store Informes Users)
- Base View: `fact_prod_altafonte_singlestore_informes_users`
- View Type: Direct Table
- Data Source: FACTS.PROD.ALTAFONTE_SINGLESTORE_INFORMES_USERS

**fact_prod_altafonte_singlestore_resources** (Single Store Resources)
- Base View: `fact_prod_altafonte_singlestore_resources`
- View Type: Direct Table
- Data Source: FACTS.PROD.ALTAFONTE_SINGLESTORE_RESOURCES

#### Model: reporting_altafonte

**fact_prod_altafonte_singlestore_informes** (Reporting Altafonte)
- Base View: `fact_prod_altafonte_singlestore_informes`
- View Type: Direct Table
- Data Source: FACTS.PROD.ALTAFONTE_SINGLESTORE_INFORMES

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