view: int_dbt_prod_lmcp_new_releases_in_label_processing { sql_table_name:"INTELLIGENCE"."DBT_PROD_LABEL_MANAGER_CONTROL_PANEL"."LM_CONTROL_PANEL_NEW_RELEASES_IN_LABEL_PROCESSING";; dimension: Label_manager{ label:"Label Manager" type: string sql:${TABLE}.Label_manager;; } dimension: Quarterback_label_manager{ label:"Quarterback Label Manager" type: string sql:${TABLE}.Quarterback_label_manager;; } dimension: Label_id{ label:"Label ID" type: number sql:${TABLE}.Label_id;; } dimension: Label_name{ label:"Label Name" type: string sql:${TABLE}.Label_name;; } dimension: Owner{ label:"Owner" type: string sql:${TABLE}.Owner;; } dimension: Subaccount_id{ label:"Subaccount ID" type: number sql:${TABLE}.Subaccount_id;; } dimension_group: Sale_start_date{ label:"Sale Start" type: time sql:${TABLE}.Sale_start_date;; timeframes: [year, quarter, month, week, date, day_of_year, day_of_week, week_of_year, month_name, month_num, fiscal_month_num, fiscal_quarter, fiscal_quarter_of_year, fiscal_year] } dimension_group: Preorder_date{ label:"Preorder" type: time sql:${TABLE}.Preorder_date;; timeframes: [year, quarter, month, week, date, day_of_year, day_of_week, week_of_year, month_name, month_num, fiscal_month_num, fiscal_quarter, fiscal_quarter_of_year, fiscal_year] } dimension: Vw_active_vendor_contract_snowflake_vendor_id{ label:"Vendor Contract ID" type: number sql:${TABLE}.Vw_active_vendor_contract_snowflake_vendor_id;; } dimension: Imprint{ label:"Imprint" type: string sql:${TABLE}.Imprint;; } dimension: Artist_info_name{ label:"Artist Name" type: string sql:${TABLE}.Artist_info_name;; } dimension: Release_name{ label:"Release Name" type: string sql:${TABLE}.Release_name;; } dimension: Upc{ label:"UPC" type: number sql:${TABLE}.Upc;; } dimension: Genre{ label:"Genre" type: string sql:${TABLE}.Genre;; } dimension: Subgenre{ label:"Subgenre" type: string sql:${TABLE}.Subgenre;; } dimension: Distribution_format_context_type{ label:"Context Type" type: string sql:${TABLE}.Distribution_format_context_type;; } dimension: Releases_format{ label:"Releases Format" type: string sql:${TABLE}.Releases_format;; } dimension: Delivered_status{ label:"Delivered Status" type: string sql:${TABLE}.Delivered_status;; } }