# View: dt_streaming_fraud_detection

**View Name:** dt_streaming_fraud_detection
**Table Source:** `Derived from: Art_Relations_Prod_Art_Relations.Artist_Info, Art_Relations_Prod_Art_Relations.Releases, Orchard_App_Reporting_V2, Orchard_App_Reporting_V2.Art_Relations_Prod_Art_Relations`
**File Path:** `dt_streaming_fraud_detection.view.lkml`

## Overview

- **File Size:** 6381 bytes
- **Lines of Code:** 246
- **Dimensions:** 23
- **Measures:** 0
- **Dimension Groups:** 0
- **Filters:** 1

## Dimensions

| Name | Type |
|------|------|
| `upc` | number |
| `release_name` | string |
| `artist_name` | string |
| `imprint` | string |
| `release_is_deleted` | yesno |
| `label_id` | number |
| `label_name` | string |
| `label_is_active` | yesno |
| `label_manager` | string |
| `owner` | string |
| `days_of_activity` | number |
| `spotify_average` | number |
| `spotify_max` | number |
| `other_average` | number |
| `other_max` | number |
| `free_avg` | number |
| `free_max` | number |
| `paid_avg` | number |
| `paid_max` | number |
| `spotify_z` | number |
| `other_z` | number |
| `free_z` | number |
| `paid_z` | number |

## Filters

- `upc_filter`

## Derived Table

```sql
sql:
WITH label_filter AS (
    SELECT DISTINCT ai.vendor_id
    FROM orchard_app_reporting_v2.art_relations_prod_art_relations.releases r
        INNER JOIN orchard_app_reporting_v2.art_relations_prod_art_relations.artist_info ai ON r.artist_id = ai.artist_id
    WHERE {% condition upc_filter %
```