# View: dt_orchgo_artist_level_label_invites

**View Name:** dt_orchgo_artist_level_label_invites
**Table Source:** `Derived from: Art_Relations_Prod_Art_Relations.Country, Orchard_App_Reporting_V2, Orchard_App_Reporting_V2.Art_Relations_Prod_Art_Relations, Prod.Label_Participant, Prod.Profile_Has_Access_To_Label_Participant + 3 more`
**File Path:** `dt_orchgo_artist_level_label_invites.view.lkml`

## Overview

- **File Size:** 2077 bytes
- **Lines of Code:** 84
- **Dimensions:** 6
- **Measures:** 1
- **Dimension Groups:** 0
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `label_name` | string |
| `label_id` | number |
| `label_country` | string |
| `profile_name` | string |
| `participant_name` | string |
| `profile_created_date` | date |

## Measures

| Name | Type |
|------|------|
| `count` | sum |

## Derived Table

```sql
sql:
        select
          v.company as label_name,
          v.vendor_id as label_id,
          c.name as label_country,
          p.profile_name as profile_name,
          lp.name as participant_name,
          p.created_at as profile_created_date,
          count(*) as count

        from facts.prod.profile p
        inner join facts.prod.profile_has_access_to_label_participant phlp on p.uuid = phlp.profile_uuid
        inner join facts.prod.label_participant lp on phlp.label_participant_uuid = lp.uuid
        inner join royalty_accounting_reporting.prod.vw_dim_abacus_ar_vendor v on v.vendor_id = lp.vendor_id
        inner join orchard_app_reporting_v2.art_relations_prod_art_relations.country c on c.id = v.country
        where

        to_date(p.created_at) >= {% parameter filter_lower_date %
```