# View: publishing_metadata

**View Name:** publishing_metadata
**Table Source:** `intelligence.dbt_prod.publishing_metadata`
**File Path:** `views/publishing_metadata.view.lkml`

## Overview

- **File Size:** 38572 bytes
- **Lines of Code:** 1801
- **Dimensions:** 347
- **Measures:** 0
- **Dimension Groups:** 1
- **Filters:** 0

## Dimensions

| Name | Type |
|------|------|
| `label_id` | string |
| `label_name` | string |
| `territory_restrictions` | string |
| `imprint` | string |
| `artist_name` | string |
| `primary_artists` | string |
| `upc` | number |
| `release_name` | string |
| `tuid` | string |
| `isrc` | string |
| `track_minutes` | string |
| `track_seconds` | string |
| `title` | string |
| `alternate_titles` | string |
| `contains_sample` | string |
| `contains_elements_of_public_domain` | string |
| `pub_song_id` | number |
| `created_at` | date |
| `submitted_At` | date |
| `work_id` | string |
| `iswc` | string |
| `composer_1_name` | string |
| `composer_1_sample` | string |
| `composer_1_public_domain` | string |
| `composer_1_id` | number |
| `composer_1_pro` | string |
| `composer_1_ipi` | number |
| `composer_1_capacity` | string |
| `publisher_1_name` | string |
| `publisher_1_pub_id` | string |
| `publisher_1_pro` | string |
| `publisher_1_ipi` | string |
| `composer_1_split` | string |
| `composer_controlled_1` | string |
| `composer_2_name` | string |
| `composer_2_sample` | string |
| `composer_2_public_domain` | string |
| `composer_2_id` | number |
| `composer_2_pro` | string |
| `composer_2_ipi` | number |
| `composer_2_capacity` | string |
| `publisher_2_name` | string |
| `publisher_2_pub_id` | string |
| `publisher_2_pro` | string |
| `publisher_2_ipi` | string |
| `composer_2_split` | string |
| `composer_controlled_2` | string |
| `composer_3_name` | string |
| `composer_3_sample` | string |
| `composer_3_public_domain` | string |
| `composer_3_id` | number |
| `composer_3_pro` | string |
| `composer_3_ipi` | number |
| `composer_3_capacity` | string |
| `publisher_3_name` | string |
| `publisher_3_pub_id` | string |
| `publisher_3_pro` | string |
| `publisher_3_ipi` | string |
| `composer_3_split` | string |
| `composer_controlled_3` | string |
| `composer_4_name` | string |
| `composer_4_sample` | string |
| `composer_4_public_domain` | string |
| `composer_4_id` | number |
| `composer_4_pro` | string |
| `composer_4_ipi` | number |
| `composer_4_capacity` | string |
| `publisher_4_name` | string |
| `publisher_4_pub_id` | string |
| `publisher_4_pro` | string |
| `publisher_4_ipi` | string |
| `composer_4_split` | string |
| `composer_controlled_4` | string |
| `composer_5_name` | string |
| `composer_5_sample` | string |
| `composer_5_public_domain` | string |
| `composer_5_id` | number |
| `composer_5_pro` | string |
| `composer_5_ipi` | number |
| `composer_5_capacity` | string |
| `publisher_5_name` | string |
| `publisher_5_pub_id` | string |
| `publisher_5_pro` | string |
| `publisher_5_ipi` | string |
| `composer_5_split` | string |
| `composer_controlled_5` | string |
| `composer_6_name` | string |
| `composer_6_sample` | string |
| `composer_6_public_domain` | string |
| `composer_6_id` | number |
| `composer_6_pro` | string |
| `composer_6_ipi` | number |
| `composer_6_capacity` | string |
| `publisher_6_name` | string |
| `publisher_6_pub_id` | string |
| `publisher_6_pro` | string |
| `publisher_6_ipi` | string |
| `composer_6_split` | string |
| `composer_controlled_6` | string |
| `composer_7_name` | string |
| `composer_7_sample` | string |
| `composer_7_public_domain` | string |
| `composer_7_id` | number |
| `composer_7_pro` | string |
| `composer_7_ipi` | number |
| `composer_7_capacity` | string |
| `publisher_7_name` | string |
| `publisher_7_pub_id` | string |
| `publisher_7_pro` | string |
| `publisher_7_ipi` | string |
| `composer_7_split` | string |
| `composer_controlled_7` | string |
| `composer_8_name` | string |
| `composer_8_sample` | string |
| `composer_8_public_domain` | string |
| `composer_8_id` | number |
| `composer_8_pro` | string |
| `composer_8_ipi` | number |
| `composer_8_capacity` | string |
| `publisher_8_name` | string |
| `publisher_8_pub_id` | string |
| `publisher_8_pro` | string |
| `publisher_8_ipi` | string |
| `composer_8_split` | string |
| `composer_controlled_8` | string |
| `composer_9_name` | string |
| `composer_9_sample` | string |
| `composer_9_public_domain` | string |
| `composer_9_id` | number |
| `composer_9_pro` | string |
| `composer_9_ipi` | number |
| `composer_9_capacity` | string |
| `publisher_9_name` | string |
| `publisher_9_pub_id` | string |
| `publisher_9_pro` | string |
| `publisher_9_ipi` | string |
| `composer_9_split` | string |
| `composer_controlled_9` | string |
| `composer_10_name` | string |
| `composer_10_sample` | string |
| `composer_10_public_domain` | string |
| `composer_10_id` | number |
| `composer_10_pro` | string |
| `composer_10_ipi` | number |
| `composer_10_capacity` | string |
| `publisher_10_name` | string |
| `publisher_10_pub_id` | string |
| `publisher_10_pro` | string |
| `publisher_10_ipi` | string |
| `composer_10_split` | string |
| `composer_controlled_10` | string |
| `composer_11_name` | string |
| `composer_11_sample` | string |
| `composer_11_public_domain` | string |
| `composer_11_id` | number |
| `composer_11_pro` | string |
| `composer_11_ipi` | number |
| `composer_11_capacity` | string |
| `publisher_11_name` | string |
| `publisher_11_pub_id` | string |
| `publisher_11_pro` | string |
| `publisher_11_ipi` | string |
| `composer_11_split` | string |
| `composer_controlled_11` | string |
| `composer_12_name` | string |
| `composer_12_sample` | string |
| `composer_12_public_domain` | string |
| `composer_12_id` | number |
| `composer_12_pro` | string |
| `composer_12_ipi` | number |
| `composer_12_capacity` | string |
| `publisher_12_name` | string |
| `publisher_12_pub_id` | string |
| `publisher_12_pro` | string |
| `publisher_12_ipi` | string |
| `composer_12_split` | string |
| `composer_controlled_12` | string |
| `composer_13_name` | string |
| `composer_13_sample` | string |
| `composer_13_public_domain` | string |
| `composer_13_id` | number |
| `composer_13_pro` | string |
| `composer_13_ipi` | number |
| `composer_13_capacity` | string |
| `publisher_13_name` | string |
| `publisher_13_pub_id` | string |
| `publisher_13_pro` | string |
| `publisher_13_ipi` | string |
| `composer_13_split` | string |
| `composer_controlled_13` | string |
| `composer_14_name` | string |
| `composer_14_sample` | string |
| `composer_14_public_domain` | string |
| `composer_14_id` | number |
| `composer_14_pro` | string |
| `composer_14_ipi` | number |
| `composer_14_capacity` | string |
| `publisher_14_name` | string |
| `publisher_14_pub_id` | string |
| `publisher_14_pro` | string |
| `publisher_14_ipi` | string |
| `composer_14_split` | string |
| `composer_controlled_14` | string |
| `composer_15_name` | string |
| `composer_15_sample` | string |
| `composer_15_public_domain` | string |
| `composer_15_id` | number |
| `composer_15_pro` | string |
| `composer_15_ipi` | number |
| `composer_15_capacity` | string |
| `publisher_15_name` | string |
| `publisher_15_pub_id` | string |
| `publisher_15_pro` | string |
| `publisher_15_ipi` | string |
| `composer_15_split` | string |
| `composer_controlled_15` | string |
| `composer_16_name` | string |
| `composer_16_sample` | string |
| `composer_16_public_domain` | string |
| `composer_16_id` | number |
| `composer_16_pro` | string |
| `composer_16_ipi` | number |
| `composer_16_capacity` | string |
| `publisher_16_name` | string |
| `publisher_16_pub_id` | string |
| `publisher_16_pro` | string |
| `publisher_16_ipi` | string |
| `composer_16_split` | string |
| `composer_controlled_16` | string |
| `composer_17_name` | string |
| `composer_17_sample` | string |
| `composer_17_public_domain` | string |
| `composer_17_id` | number |
| `composer_17_pro` | string |
| `composer_17_ipi` | number |
| `composer_17_capacity` | string |
| `publisher_17_name` | string |
| `publisher_17_pub_id` | string |
| `publisher_17_pro` | string |
| `publisher_17_ipi` | string |
| `composer_17_split` | string |
| `composer_controlled_17` | string |
| `composer_18_name` | string |
| `composer_18_sample` | string |
| `composer_18_public_domain` | string |
| `composer_18_id` | number |
| `composer_18_pro` | string |
| `composer_18_ipi` | number |
| `composer_18_capacity` | string |
| `publisher_18_name` | string |
| `publisher_18_pub_id` | string |
| `publisher_18_pro` | string |
| `publisher_18_ipi` | string |
| `composer_18_split` | string |
| `composer_controlled_18` | string |
| `composer_19_name` | string |
| `composer_19_sample` | string |
| `composer_19_public_domain` | string |
| `composer_19_id` | number |
| `composer_19_pro` | string |
| `composer_19_ipi` | number |
| `composer_19_capacity` | string |
| `publisher_19_name` | string |
| `publisher_19_pub_id` | string |
| `publisher_19_pro` | string |
| `publisher_19_ipi` | string |
| `composer_19_split` | string |
| `composer_controlled_19` | string |
| `composer_20_name` | string |
| `composer_20_sample` | string |
| `composer_20_public_domain` | string |
| `composer_20_id` | number |
| `composer_20_pro` | string |
| `composer_20_ipi` | number |
| `composer_20_capacity` | string |
| `publisher_20_name` | string |
| `publisher_20_pub_id` | string |
| `publisher_20_pro` | string |
| `publisher_20_ipi` | string |
| `composer_20_split` | string |
| `composer_controlled_20` | string |
| `composer_21_name` | string |
| `composer_21_sample` | string |
| `composer_21_public_domain` | string |
| `composer_21_id` | number |
| `composer_21_pro` | string |
| `composer_21_ipi` | number |
| `composer_21_capacity` | string |
| `publisher_21_name` | string |
| `publisher_21_pub_id` | string |
| `publisher_21_pro` | string |
| `publisher_21_ipi` | string |
| `composer_21_split` | string |
| `composer_controlled_21` | string |
| `composer_22_name` | string |
| `composer_22_sample` | string |
| `composer_22_public_domain` | string |
| `composer_22_id` | number |
| `composer_22_pro` | string |
| `composer_22_ipi` | number |
| `composer_22_capacity` | string |
| `publisher_22_name` | string |
| `publisher_22_pub_id` | string |
| `publisher_22_pro` | string |
| `publisher_22_ipi` | string |
| `composer_22_split` | string |
| `composer_controlled_22` | string |
| `composer_23_name` | string |
| `composer_23_sample` | string |
| `composer_23_public_domain` | string |
| `composer_23_id` | number |
| `composer_23_pro` | string |
| `composer_23_ipi` | number |
| `composer_23_capacity` | string |
| `publisher_23_name` | string |
| `publisher_23_pub_id` | string |
| `publisher_23_pro` | string |
| `publisher_23_ipi` | string |
| `composer_23_split` | string |
| `composer_controlled_23` | string |
| `composer_24_name` | string |
| `composer_24_sample` | string |
| `composer_24_public_domain` | string |
| `composer_24_id` | number |
| `composer_24_pro` | string |
| `composer_24_ipi` | number |
| `composer_24_capacity` | string |
| `publisher_24_name` | string |
| `publisher_24_pub_id` | string |
| `publisher_24_pro` | string |
| `publisher_24_ipi` | string |
| `composer_24_split` | string |
| `composer_controlled_24` | string |
| `composer_25_name` | string |
| `composer_25_sample` | string |
| `composer_25_public_domain` | string |
| `composer_25_id` | number |
| `composer_25_pro` | string |
| `composer_25_ipi` | number |
| `composer_25_capacity` | string |
| `publisher_25_name` | string |
| `publisher_25_pub_id` | string |
| `publisher_25_pro` | string |
| `publisher_25_ipi` | string |
| `composer_25_split` | string |
| `composer_controlled_25` | string |
| `delivered` | string |

## Dimension Groups

| Name | Type |
|------|------|
| `delivery_date` | time |

