Payment Accounts

view: payment_accounts {
  sql_table_name: postgres_public.payment_accounts ;;

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

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

  dimension: annual {
    type: yesno
    sql: ${TABLE}.annual ;;
  }

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

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

  dimension: declined {
    type: yesno
    sql: ${TABLE}.declined ;;
  }

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

- view: payment_accounts
  sql_table_name: postgres_public.payment_accounts
  fields:
  - dimension: id
    type: int
    primary_key: true
    sql: ${TABLE}.id
  - dimension: active_card
    sql: ${TABLE}.active_card
  - dimension: annual
    type: yesno
    sql: ${TABLE}.annual
  - dimension: bill_to
    sql: ${TABLE}.bill_to
  - dimension: coupon
    sql: ${TABLE}.coupon
  - dimension: declined
    type: yesno
    sql: ${TABLE}.declined
  - dimension: invoice_emails
    sql: ${TABLE}.invoice_emails
  - dimension: partner_id
    type: int
    sql: ${TABLE}.partner_id
  - dimension: plan
    sql: ${TABLE}.plan
  - dimension: price
    type: int
    sql: ${TABLE}.price
  - dimension: prior_plan
    sql: ${TABLE}.prior_plan
  - dimension: quantity
    type: int
    sql: ${TABLE}.quantity
  - dimension: remote_id
    sql: ${TABLE}.remote_id
  - dimension: status
    type: int
    sql: ${TABLE}.status
  - dimension: type
    sql: ${TABLE}.type
  - dimension: upcoming_invoice
    sql: ${TABLE}.upcoming_invoice
  - dimension: user_id
    type: int
    sql: ${TABLE}.user_id
  - dimension_group: canceled
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.canceled_at
  - dimension_group: coupon_updated
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.coupon_updated_at
  - dimension_group: created
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.created_at
  - dimension_group: downgraded
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.downgraded_at
  - dimension_group: first_charged
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.first_charged_at
  - dimension_group: last_adjusted
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.last_adjusted_at
  - dimension_group: last_charged
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.last_charged_at
  - dimension_group: past_due
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.past_due_at
  - dimension_group: status_updated
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.status_updated_at
  - dimension_group: subscription_ended
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.subscription_ended_at
  - dimension_group: updated
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.updated_at
  - dimension_group: upgraded
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.upgraded_at
  - measure: count
    type: count
    drill_fields:
    - detail*