# View: Vendor_Emails

**View Name:** Vendor_Emails
**Table Source:** `Derived from: Prod.Company_Brand, Prod.Company_Brand_Has_Label_Vendor, Prod.Has_Profile, Prod.Profile_Has_Access_To_Vendor, Prod.Vw_Dim_Abacus_Ar_Vendor + 2 more`
**File Path:** `views/Vendor_Emails.view.lkml`

## Overview

- **File Size:** 1234 bytes
- **Lines of Code:** 57
- **Dimensions:** 6
- **Measures:** 0
- **Dimension Groups:** 0
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `email` | string |
| `first_name` | string |
| `last_name` | string |
| `vendor_id` | string |
| `status` | string |
| `name` | string |

## Derived Table

```sql
sql:
    select
i.email,
i.first_name,
i.last_name,
v.vendor_id,
v.status,
c.name
from facts.prod.identity i
join facts.prod.has_profile p on p.identity_id = i.id
join facts.prod.profile_has_access_to_vendor vp on vp.profile_uuid = p.profile_uuid
join facts.prod.company_brand_has_label_vendor cp on cp.vendor_id::String = vp.vendor_id::String
join royalty_accounting_reporting.prod.vw_dim_abacus_ar_vendor v on v.vendor_id = vp.vendor_id
join facts.prod.company_brand c on c.uuid = cp.company_brand_uuid
where c.name = 'knr'
and v.status = 'signed'
and i.active = 'Y'
and i.email not like '%theorchard.com%'
and i.email not like '%kollectivenr.com%'
and i.email not like '%awal.com%'
and i.email not like '%sonymusic-pde%'
    ;;
```