data.ml
LKML Education university

Court Sentencecondition

Court Sentencecondition model for education university.

inferred

Blocks

court_sentencecondition.view.lkml · 46 lines
inferred 
view: court_sentencecondition {
  sql_table_name: poc_db.PUBLIC.COURT_SENTENCECONDITION ;;

  dimension: caseid {
    sql: ${TABLE}.CASEID ;;
  }

  dimension: casenumber {
    sql: ${TABLE}.CASENUMBER ;;
  }

  dimension: conditioncode {
    sql: ${TABLE}.CONDITIONCODE ;;
  }

  dimension: conditioncodeid {
    sql: ${TABLE}.CONDITIONCODEID ;;
  }

  dimension: conditioncomment {
    sql: ${TABLE}.CONDITIONCOMMENT ;;
  }

  dimension: conditiondesc {
    sql: ${TABLE}.CONDITIONDESC ;;
  }

  dimension: sentencecomponenttype {
    sql: ${TABLE}.SENTENCECOMPONENTTYPE ;;
  }

  dimension: sentenceid {
    sql: ${TABLE}.SENTENCEID ;;
  }

  dimension_group: conditionstartdate {
    type: time
    timeframes: [date, week, month]
    convert_tz: no
    sql: ${TABLE}.CONDITIONSTARTDATE ;;
  }

  measure: count {
    type: count
  }
}
court_sentencecondition.view.lookml · 29 lines
source-preserved 
- view: court_sentencecondition
  sql_table_name: poc_db.PUBLIC.COURT_SENTENCECONDITION
  fields:
  - dimension: caseid
    sql: ${TABLE}.CASEID
  - dimension: casenumber
    sql: ${TABLE}.CASENUMBER
  - dimension: conditioncode
    sql: ${TABLE}.CONDITIONCODE
  - dimension: conditioncodeid
    sql: ${TABLE}.CONDITIONCODEID
  - dimension: conditioncomment
    sql: ${TABLE}.CONDITIONCOMMENT
  - dimension: conditiondesc
    sql: ${TABLE}.CONDITIONDESC
  - dimension: sentencecomponenttype
    sql: ${TABLE}.SENTENCECOMPONENTTYPE
  - dimension: sentenceid
    sql: ${TABLE}.SENTENCEID
  - dimension_group: conditionstartdate
    type: time
    timeframes:
    - date
    - week
    - month
    convert_tz: false
    sql: ${TABLE}.CONDITIONSTARTDATE
  - measure: count
    type: count

Contents

  • court_sentencecondition.view.lkml
  • court_sentencecondition.view.lookml