sql_runner_query.view.lkml

view: sql_runner_query {
  # tuesday 
  derived_table: {
    sql: select service_id , usage_date from `irvine-sbx.fdm.uli`
      ;;
  }

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

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

  dimension: usage_date {
    type: date
    datatype: date
    sql: ${TABLE}.usage_date ;;
  }

  set: detail {
    fields: [service_id, usage_date]
  }
}