view: orch_app_ows_podcast_participant {
  sql_table_name: ORCHARD_APP_REPORTING_V2.PROD_OWS_PODCAST_OWS_PODCAST.PARTICIPANT ;;

  dimension: id {
    type: number
    sql: ${TABLE}.id;;
    primary_key: yes
    hidden: yes
  }

  dimension: podcast_id {
    type: number
    sql: ${TABLE}.podcast_id;;
    hidden: yes
  }

  dimension: participant_id {
    type: number
    sql: ${TABLE}.participant_id;;
    hidden: yes
  }

  dimension: name {
    type: string
    sql: ${TABLE}.name;;
    label: "Show Contributor Name"
  }

  dimension: role {
    type: string
    sql: ${TABLE}.role;;
    label: "Show Contributor Role"
  }

}