data.ml
LKML Call center

Program

Program model for call center.

inferred

Blocks

program.view.lkml · 65 lines
inferred 
view: program {
  sql_table_name: Program ;;

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

  dimension: name {
    sql: ${TABLE}.programName ;;
  }

  dimension: slug {
    sql: ${TABLE}.programSlug ;;
  }

  dimension: script {
    sql: ${TABLE}.programScript ;;
  }

  dimension: prefix {
    sql: ${TABLE}.programPrefix ;;
  }

  dimension: icon {
    sql: ${TABLE}.programIcon ;;
  }

  dimension: background {
    sql: ${TABLE}.programBackground ;;
  }

  dimension: foreground {
    sql: ${TABLE}.programForeground ;;
  }

  dimension: type {
  }

  dimension: updated_time {
    type: date_time
    sql: ${TABLE}.programUpdatedOn ;;
  }

  dimension: suspended {
    type: yesno
    sql: ${TABLE}.programSuspended = 'Y' ;;
  }

  dimension: active {
    type: yesno
    sql: ${TABLE}.programActive = 'Y' ;;
  }

  dimension_group: created_time {
    type: date_time
    sql: ${TABLE}.programCreatedOn ;;
  }

  measure: count {
    type: count_distinct
    sql: ${id} ;;
  }
}
program.view.lookml · 37 lines
source-preserved 
- view: program
  sql_table_name: Program
  fields:
  - dimension: id
    type: int
    primary_key: true
    sql: ${TABLE}.programId
  - dimension: name
    sql: ${TABLE}.programName
  - dimension: slug
    sql: ${TABLE}.programSlug
  - dimension: script
    sql: ${TABLE}.programScript
  - dimension: prefix
    sql: ${TABLE}.programPrefix
  - dimension: icon
    sql: ${TABLE}.programIcon
  - dimension: background
    sql: ${TABLE}.programBackground
  - dimension: foreground
    sql: ${TABLE}.programForeground
  - dimension: type
  - dimension: updated_time
    type: date_time
    sql: ${TABLE}.programUpdatedOn
  - dimension: suspended
    type: yesno
    sql: ${TABLE}.programSuspended = 'Y'
  - dimension: active
    type: yesno
    sql: ${TABLE}.programActive = 'Y'
  - dimension_group: created_time
    type: date_time
    sql: ${TABLE}.programCreatedOn
  - measure: count
    type: count_distinct
    sql: ${id}

Contents

  • program.view.lkml
  • program.view.lookml