view: art_relations_prod_release_film_genre {
  sql_table_name: orchard_app_reporting_v2.art_relations_prod_art_relations.release_film_genre ;;
  #   - measure: count
  #     type: count
  #     drill_fields: detail*

  dimension: release_film_genre_id {
    hidden: yes
    view_label: "Film Genre"
    type: number
    sql: ${TABLE}.RELEASE_FILM_GENRE_ID ;;
  }

  dimension: release_id {
    hidden: yes
    view_label: "Film Genre"
    type: number
    sql: ${TABLE}.RELEASE_ID ;;
  }

  dimension: film_genre_id {
    hidden: yes
    view_label: "Film Genre"
    type: number
    sql: ${TABLE}.FILM_GENRE_ID ;;
  }

  dimension: is_primary {
    hidden: yes
    view_label: "Film Genre"
    type: string
    sql: ${TABLE}.IS_PRIMARY ;;
  }

  set: detail {
    fields: [release_film_genre_id, release_id, film_genre_id, is_primary]
  }
}