view: fact_prod_altafonte_singlestore_resources { sql_table_name: FACTS.PROD.ALTAFONTE_SINGLESTORE_RESOURCES ;; dimension: EAN { label: "EAN" type: string sql: ${TABLE}.EAN ;; } dimension: ISRC { label: "ISRC" type: string sql: ${TABLE}.ISRC ;; } dimension: ARTIST { label: "ARTIST" type: string sql: ${TABLE}.ARTIST ;; } dimension: ARTIST_DISPLAY { label: "Artist Display" type: string sql: ${TABLE}.ARTIST_DISPLAY ;; } dimension: ESTADO { label: "ESTADO" type: string sql: ${TABLE}.ESTADO ;; } dimension: GENRE { label: "Genre" type: string sql: ${TABLE}.GENRE ;; } dimension: LABEL{ label: "Label" type: string sql: ${TABLE}.LABEL;; } dimension: NICK { label: "Nick" type: string sql: ${TABLE}.NICK ;; } dimension: ORIGEN { label: "Origen" type: string sql: ${TABLE}.ORIGEN ;; } dimension: PAIS_USER { label: "Pais User" type: string sql: ${TABLE}.PAIS_USER ;; } dimension: PLATAFORMA { label: "Plataforma" type: string sql: ${TABLE}.PLATAFORMA ;; } dimension: PRODUCT_ORIGEN { label: "Product Origen" type: string sql: ${TABLE}.PRODUCT_ORIGEN ;; } dimension: PRODUCT_TITLE { label: "Product Title" type: string sql: ${TABLE}.PRODUCT_TITLE ;; } dimension: RELEASE_START_DATE { label: "Release Start Date" type: string sql: ${TABLE}.RELEASE_START_DATE ;; } dimension: RESOURCE_ID { label: "Resource ID" type: string sql: ${TABLE}.RESOURCE_ID ;; } dimension: TAG { label: "TAG" type: string sql: ${TABLE}.TAG ;; } dimension_group: TIME { label: "Time" type: time sql: ${TABLE}.TIME ;; 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: TIME_CREACION { label: "Time Creation" type: time sql: ${TABLE}.TIME_CREACION ;; 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: TIPO { label: "TIPO" type: string sql: ${TABLE}.TIPO ;; } dimension: TRACK_TITLE { label: "Track Title" type: string sql: ${TABLE}.TRACK_TITLE ;; } dimension: USER_ID { label: "User ID" type: string sql: ${TABLE}.USER_ID ;; } }