# View: dt_apple_id_mapping_sony_and_orchard

**View Name:** dt_apple_id_mapping_sony_and_orchard
**Table Source:** `intelligence.dbt_prod.base_apple_id_mapping`
**File Path:** `dt_apple_id_mapping_sony_and_orchard.view.lkml`

## Overview

- **File Size:** 1077 bytes
- **Lines of Code:** 52
- **Dimensions:** 5
- **Measures:** 0
- **Dimension Groups:** 0
- **Filters:** 0

## Comments & Notes

- derived_table: {
- sql: SELECT
- TRY_TO_NUMBER(orchard_release_id) AS upc,

## Dimensions

| Name | Type |
|------|------|
| `apple_id` | string |
| `upc` | number |
| `isrc` | string |
| `album_or_track` | string |
| `distributor` | string |

## Derived Table

```sql
#    sql: SELECT
#            apple_id,
#            TRY_TO_NUMBER(orchard_release_id) AS upc,
#            orchard_track_id AS isrc,
#            album_or_track,
#            'Orchard' as distributor
#        FROM facts.prod.apple_id_mapping
#        UNION ALL
#        SELECT
#            apple_id,
#            TRY_TO_NUMBER(upc) AS upc,
#            isrc,
#            album_or_track,
#            'Sony' as distributor
#        FROM facts.prod.sony_apple_id_mapping;;
#
```