view: orchard_pricing_tier {
  sql_table_name:orchard_app_reporting_v2.prod_ows_pricing_pricing.orchard_pricing_tier
      ;;


  measure: count {
    type: count
    drill_fields: [detail*]
  }

  dimension: orchard_pricing_tier_id {
    type: number
    sql: ${TABLE}.ORCHARD_PRICING_TIER_ID ;;
  }

  dimension: pricing_family_id {
    type: number
    sql: ${TABLE}.PRICING_FAMILY_ID ;;
  }

  dimension: album_name {
    label: "Album Pricing"
    description: "Orchard DEFAULT Pricing Tier; Mid, Front, etc."
    type: string
    sql: ${TABLE}.NAME ;;
  }

  dimension: track_name {
    label: "Track Pricing"
    description: "Orchard DEFAULT Pricing Tier; Mid, Front, etc."
    type: string
    sql: ${TABLE}.NAME ;;
  }

  dimension: is_default {
    type: number
    sql: ${TABLE}.IS_DEFAULT ;;
  }

  dimension: sort_order {
    type: number
    sql: ${TABLE}.SORT_ORDER ;;
  }

  dimension: created_date {
    type: string
    sql: ${TABLE}.CREATED_DATE ;;
  }

  dimension: created_by {
    type: string
    sql: ${TABLE}.CREATED_BY ;;
  }

  dimension: updated_date {
    type: string
    sql: ${TABLE}.UPDATED_DATE ;;
  }

  dimension: updated_by {
    type: string
    sql: ${TABLE}.UPDATED_BY ;;
  }

  set: detail {
    fields: [
      orchard_pricing_tier_id,
      pricing_family_id,
      is_default,
      sort_order,
      created_date,
      created_by,
      updated_date,
      updated_by
    ]
  }
}