# View: dt_blocklist_artist_with_reason

**View Name:** dt_blocklist_artist_with_reason
**Table Source:** `Derived from: Art_Relations_Prod_Art_Relations.Blacklist_Reasons, Art_Relations_Prod_Art_Relations.Blacklist_Words, Orchard_App_Reporting_V2, Orchard_App_Reporting_V2.Art_Relations_Prod_Art_Relations`
**File Path:** `dt_blocklist_artist_with_reason.view.lkml`

## Overview

- **File Size:** 703 bytes
- **Lines of Code:** 32
- **Dimensions:** 3
- **Measures:** 0
- **Dimension Groups:** 0
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `blocklist_artist` | string |
| `blocklist_reason` | string |
| `blocklist_alert` | string |

## Derived Table

```sql
sql:
      select
      word as artist_name,
      reason,
      alert
  from ORCHARD_APP_REPORTING_V2.ART_RELATIONS_PROD_ART_RELATIONS.BLACKLIST_WORDS bw
  left join ORCHARD_APP_REPORTING_V2.ART_RELATIONS_PROD_ART_RELATIONS.BLACKLIST_REASONS br
      on bw.blacklist_reason_id = br.id
    ;;
```