fdm_uli.view.lkml

view: fdm_uli {
  derived_table: {
    sql: select partition_date, service_id, account_id from `irvine-sbx.fdm.uli`
      ;;
  }

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

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

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

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

  set: detail {
    fields: [partition_date, service_id, account_id]
  }
}