data.ml
LKML Education university

Court Parole

Court Parole model for education university.

inferred

Blocks

court_parole.view.lkml · 51 lines
inferred 
view: court_parole {
  sql_table_name: poc_db.PUBLIC.COURT_PAROLE ;;

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

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

  dimension: parolecomment {
    sql: ${TABLE}.PAROLECOMMENT ;;
  }

  dimension: paroleindeterminate {
    sql: ${TABLE}.PAROLEINDETERMINATE ;;
  }

  dimension: parolesuperagency {
    sql: ${TABLE}.PAROLESUPERAGENCY ;;
  }

  dimension: parolesuperagencyid {
    sql: ${TABLE}.PAROLESUPERAGENCYID ;;
  }

  dimension: paroletermdays {
    sql: ${TABLE}.PAROLETERMDAYS ;;
  }

  dimension: paroletermmonths {
    sql: ${TABLE}.PAROLETERMMONTHS ;;
  }

  dimension: paroletermyears {
    sql: ${TABLE}.PAROLETERMYEARS ;;
  }

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

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

  measure: count {
    type: count
  }
}
court_parole.view.lookml · 27 lines
source-preserved 
- view: court_parole
  sql_table_name: poc_db.PUBLIC.COURT_PAROLE
  fields:
  - dimension: caseid
    sql: ${TABLE}.CASEID
  - dimension: casenumber
    sql: ${TABLE}.CASENUMBER
  - dimension: parolecomment
    sql: ${TABLE}.PAROLECOMMENT
  - dimension: paroleindeterminate
    sql: ${TABLE}.PAROLEINDETERMINATE
  - dimension: parolesuperagency
    sql: ${TABLE}.PAROLESUPERAGENCY
  - dimension: parolesuperagencyid
    sql: ${TABLE}.PAROLESUPERAGENCYID
  - dimension: paroletermdays
    sql: ${TABLE}.PAROLETERMDAYS
  - dimension: paroletermmonths
    sql: ${TABLE}.PAROLETERMMONTHS
  - dimension: paroletermyears
    sql: ${TABLE}.PAROLETERMYEARS
  - dimension: sentencecomponenttype
    sql: ${TABLE}.SENTENCECOMPONENTTYPE
  - dimension: sentenceid
    sql: ${TABLE}.SENTENCEID
  - measure: count
    type: count

Contents

  • court_parole.view.lkml
  • court_parole.view.lookml