Partner Passes

view: partner_passes {
  sql_table_name: ${TABLE}.partner_passes ;;

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

  dimension: fail_reason {
    sql: ${TABLE}.fail_reason ;;
  }

  dimension: failed {
    type: number
    sql: ${TABLE}.failed ;;
  }

  dimension: partner_listing_id {
    type: int
    sql: ${TABLE}.partner_listing_id ;;
  }

  dimension: partner_order_num {
    sql: ${TABLE}.partner_order_num ;;
  }

  dimension: payout {
    type: number
    sql: ${TABLE}.payout ;;
  }

  dimension: reservation_id {
    type: int
    sql: ${TABLE}.reservation_id ;;
  }

  dimension: uploaded {
    type: number
    sql: ${TABLE}.uploaded ;;
  }

  dimension_group: created {
    type: time
    timeframes: [time, date, week, month]
    sql: ${TABLE}.created_at ;;
  }

  dimension_group: updated {
    type: time
    timeframes: [time, date, week, month]
    sql: ${TABLE}.updated_at ;;
  }

  measure: count {
    type: count
    drill_fields: [id, partner_listings.partner_listing_id]
  }

  measure: total_payout {
    type: sum
    sql: ${payout} ;;
  }
}

- view: partner_passes
  sql_table_name: ${TABLE}.partner_passes
  fields:
  - dimension: id
    type: int
    primary_key: true
    sql: ${TABLE}.id
  - dimension: fail_reason
    sql: ${TABLE}.fail_reason
  - dimension: failed
    type: number
    sql: ${TABLE}.failed
  - dimension: partner_listing_id
    type: int
    sql: ${TABLE}.partner_listing_id
  - dimension: partner_order_num
    sql: ${TABLE}.partner_order_num
  - dimension: payout
    type: number
    sql: ${TABLE}.payout
  - dimension: reservation_id
    type: int
    sql: ${TABLE}.reservation_id
  - dimension: uploaded
    type: number
    sql: ${TABLE}.uploaded
  - dimension_group: created
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.created_at
  - dimension_group: updated
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.updated_at
  - measure: count
    type: count
    drill_fields:
    - id
    - partner_listings.partner_listing_id
  - measure: total_payout
    type: sum
    sql: ${payout}