# View: dt_release_schedule_dashboard

**View Name:** dt_release_schedule_dashboard
**Table Source:** `INTELLIGENCE.DBT_PROD.RELEASE_SCHEDULE_DASHBOARD`
**File Path:** `dt_release_schedule_dashboard.view.lkml`

## Overview

- **File Size:** 14158 bytes
- **Lines of Code:** 493
- **Dimensions:** 40
- **Measures:** 0
- **Dimension Groups:** 0
- **Filters:** 0

## Comments & Notes

- derived_table: {
- r.release_id,
- r.release_date,

## Dimensions

| Name | Type |
|------|------|
| `release_id` | number |
| `release_date` | date |
| `is_active_release` | yesno |
| `sale_start_date` | date |
| `preorder_date` | date |
| `last_updated` | date |
| `upc` | string |
| `product_code` | string |
| `version` | string |
| `artist_id` | number |
| `artist_name` | string |
| `artist_country` | string |
| `release_name` | string |
| `imprint` | string |
| `genre` | string |
| `subgenre` | string |
| `label_id` | number |
| `label_name` | string |
| `label_country` | string |
| `label_manager` | string |
| `quarterback_label_manager` | number |
| `context_type` | string |
| `release_format` | string |
| `media_format` | string |
| `display_configuration` | string |
| `mktg_blurb` | string |
| `global_mktg_highlights` | string |
| `sync_highlights` | string |
| `local_mktg_highlights` | string |
| `store_specific_highlights` | string |
| `internal_note` | string |
| `project_description` | string |
| `promo_link` | string |
| `priority` | string |
| `priority_ab` | string |
| `priority_a` | string |
| `priority_b` | string |
| `release_status` | string |
| `contains_lyrics` | yesno |
| `delivered_with_spatial_audio_to_apple` | yesno |

## Derived Table

```sql
#    sql:
#SELECT
#    r.release_id,
#    r.release_date,
#    r.sale_start_date,
#    r.preorder_date,
#    r.upc,
#    r.product_code,
#    r.last_updated,
#    r.delivered_version AS version,
#    ai.artist_id,
#    ai.name AS artist_name,
#    ac.name AS artist_country,
#    r.release_name,
#    r.label AS imprint,
#    g.genre,
#    sg.subgenre,
#    v.vendor_id AS label_id,
#    lc.name AS label_country,
#    IFF(v.company IS NULL OR v.company = '', v.name, v.company) AS label_name,
#    oa.f_name||' '||oa.l_name AS label_manager,
#    df.context_type,
#    v.quarterback_label_manager,
#    COALESCE(r.format, '') AS release_format,
#    COALESCE(df.media_format, '') AS media_format,
#    COALESCE(pp.display_configuration, '') AS display_configuration,
#    COALESCE(mkt1.mktg_blurb, '') AS mktg_blurb,
#    COALESCE(sh.sync_highlights, '') AS sync_highlights,
#    COALESCE(mkt2.global_mktg_highlights, '') AS global_mktg_highlights,
#    COALESCE(md.local_mktg_highlights, '') AS local_mktg_highlights,
#    COALESCE(dsh.store_specific_highlights, '') AS store_specific_highlights,
#    COALESCE(dmp.internal_note, '') AS internal_note,
#    COALESCE(p.description, '') AS project_description,
#    COALESCE(pr.promo_link, '') AS promo_link,
#    mp.priority,
#    mp.priority_ab,
#    mp.priority_a,
#    mp.priority_b,
#    r.release_status,
#    r.deletions,
#    r.not_for_distribution
#FROM orchard_app_reporting_v2.art_relations_prod_art_relations.releases r
#    INNER JOIN orchard_app_reporting_v2.art_relations_prod_art_relations.project p ON r.project_id = p.project_id
#    INNER JOIN orchard_app_reporting_v2.art_relations_prod_art_relations.artist_info ai ON r.artist_id = ai.artist_id
#        LEFT JOIN orchard_app_reporting_v2.art_relations_prod_art_relations.country ac ON ai.orchard_country = ac.id
#    INNER JOIN royalty_accounting_reporting.prod.vw_dim_abacus_ar_vendor v ON ai.vendor_id = v.vendor_id
#        LEFT JOIN orchard_app_reporting_v2.art_relations_prod_art_relations.country lc ON v.country = lc.id
#    INNER JOIN orchard_app_reporting_v2.art_relations_prod_art_relations.orchadmin_users oa ON v.assigned_to = oa.id
#    LEFT JOIN orchard_app_reporting_v2.art_relations_prod_art_relations.genre g ON r.genre_id = g.genre_id
#    LEFT JOIN (
#        SELECT rs.release_id, s.name AS subgenre
#        FROM orchard_app_reporting_v2.art_relations_prod_art_relations.release_subgenre rs
#        INNER JOIN orchard_app_reporting_v2.art_relations_prod_art_relations.subgenre s ON rs.subgenre_id = s.orchard_id
#    ) sg ON r.release_id = sg.release_id
#    LEFT JOIN (
#        SELECT d.distribution_format_id, d.context_type, dfm.name AS media_format
#        FROM orchard_app_reporting_v2.art_relations_prod_art_relations.distribution_format d
#        INNER JOIN orchard_app_reporting_v2.art_relations_prod_art_relations.distribution_format_media dfm ON d.distribution_format_media_id = dfm.distribution_format_media_id
#    ) df ON r.distribution_format_id = df.distribution_format_id
#    LEFT JOIN orchard_app_reporting_v2.art_relations_prod_art_relations.product_physical pp ON r.release_id = pp.release_id
#    LEFT JOIN (
#        SELECT
#            info_for_id AS release_id,
#            REGEXP_REPLACE(description,'(<[^>]+?>|&nbsp;)') AS mktg_blurb
#        FROM orchard_app_reporting_v2.art_relations_prod_art_relations.mkt_program_info
#        WHERE info_for = 'release' AND mkt_program_id = 15
#    ) mkt1 ON r.release_id = mkt1.release_id
#    LEFT JOIN (
#        SELECT
#            info_for_id AS project_id,
#            REGEXP_REPLACE(description,'(<[^>]+?>|&nbsp;)') AS global_mktg_highlights
#        FROM orchard_app_reporting_v2.art_relations_prod_art_relations.mkt_program_info
#        WHERE info_for = 'project' AND mkt_program_id = 20
#    ) mkt2 ON r.project_id = mkt2.project_id
#        LEFT JOIN (
#        SELECT
#            info_for_id AS project_id,
#            REGEXP_REPLACE(description,'(<[^>]+?>|&nbsp;)') AS sync_highlights
#        FROM orchard_app_reporting_v2.art_relations_prod_art_relations.mkt_program_info
#        WHERE info_for = 'project' AND mkt_program_id = 22
#    ) sh ON r.project_id = sh.project_id
#     LEFT JOIN (
#         SELECT product_id, ('https://promo.theorchard.com/'||code) AS promo_link
#         FROM orchard_app_reporting_v2.prod_promo_player_promo_player.promo_player
#         WHERE active = 1
#     ) pr ON r.release_id = pr.product_id
#    LEFT JOIN (
#        SELECT
#            release_id,
#            priority,
#            LISTAGG(priority_ab, '||') WITHIN GROUP (ORDER BY priority_ab ASC) AS priority_ab,
#            LISTAGG(priority_a, '||') WITHIN GROUP (ORDER BY priority_a ASC) AS priority_a,
#            LISTAGG(priority_b, '||') WITHIN GROUP (ORDER BY priority_b ASC) AS priority_b
#        FROM (
#            SELECT
#                mp.release_id,
#                mp.priority as priority,
#                dmpc.country_name AS priority_ab,
#                IFF(mp.priority = 'a', dmpc.country_name, NULL) AS priority_a,
#                IFF(mp.priority = 'b', dmpc.country_name, NULL) AS priority_b
#            FROM orchard_app_reporting_v2.art_relations_prod_art_relations.mkt_priority mp
#                INNER JOIN (
#                    SELECT DISTINCT country_id, country_name
#                    FROM orchard_app_reporting_v2.prod_sales_goals_sales_goals.digital_marketing_projections_by_country
#                    WHERE country_name != 'United States'
#                ) dmpc ON mp.country_id = dmpc.country_id
#        )
#        GROUP BY 1,2
#    ) mp ON r.release_id = mp.release_id
#    LEFT JOIN (
#        SELECT
#            project_id,
#            LISTAGG(country_name||': '||value, '||') WITHIN GROUP (ORDER BY country_name ASC) AS local_mktg_highlights
#        FROM orchard_app_reporting_v2.prod_sales_goals_sales_goals.marketing_driver
#        GROUP BY 1
#    ) md ON r.project_id = md.project_id
#    LEFT JOIN (
#        SELECT
#            dsh.project_id,
#            LISTAGG(ds.store||': '||dsh.value, '||') WITHIN GROUP (ORDER BY ds.store ASC) AS store_specific_highlights
#            FROM orchard_app_reporting_v2.prod_sales_goals_sales_goals.digital_store_highlights dsh
#                INNER JOIN orchard_app_reporting_v2.prod_sales_goals_sales_goals.digital_stores ds ON dsh.store_id = ds.id
#        GROUP BY 1
#    ) dsh ON r.project_id = dsh.project_id
#    LEFT JOIN orchard_app_reporting_v2.prod_sales_goals_sales_goals.digital_marketing_projections dmp ON r.release_id = dmp.product_id
#WHERE r.product_type_id = 1
#    AND r.deletions = 'N'
#    AND r.not_for_distribution IN ('N','SwitchboardDummy') ;;
#
```