data.ml
LookML Education university

Court Suspendcredit

Court Suspendcredit model for education university.

source-preserved

Blocks

court_suspendcredit.view.lkml · 59 lines
inferred 
view: court_suspendcredit {
  sql_table_name: poc_db.PUBLIC.COURT_SUSPENDCREDIT ;;

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

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

  dimension: creditdays {
    sql: ${TABLE}.CREDITDAYS ;;
  }

  dimension: credithours {
    sql: ${TABLE}.CREDITHOURS ;;
  }

  dimension: creditmonths {
    sql: ${TABLE}.CREDITMONTHS ;;
  }

  dimension: credityears {
    sql: ${TABLE}.CREDITYEARS ;;
  }

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

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

  dimension: suspendall {
    sql: ${TABLE}.SUSPENDALL ;;
  }

  dimension: suspendapplycharges {
    sql: ${TABLE}.SUSPENDAPPLYCHARGES ;;
  }

  dimension: suspenddays {
    sql: ${TABLE}.SUSPENDDAYS ;;
  }

  dimension: suspendmonths {
    sql: ${TABLE}.SUSPENDMONTHS ;;
  }

  dimension: suspendyears {
    sql: ${TABLE}.SUSPENDYEARS ;;
  }

  measure: count {
    type: count
  }
}
court_suspendcredit.view.lookml · 31 lines
source-preserved 
- view: court_suspendcredit
  sql_table_name: poc_db.PUBLIC.COURT_SUSPENDCREDIT
  fields:
  - dimension: caseid
    sql: ${TABLE}.CASEID
  - dimension: casenumber
    sql: ${TABLE}.CASENUMBER
  - dimension: creditdays
    sql: ${TABLE}.CREDITDAYS
  - dimension: credithours
    sql: ${TABLE}.CREDITHOURS
  - dimension: creditmonths
    sql: ${TABLE}.CREDITMONTHS
  - dimension: credityears
    sql: ${TABLE}.CREDITYEARS
  - dimension: sentencecomponenttype
    sql: ${TABLE}.SENTENCECOMPONENTTYPE
  - dimension: sentenceid
    sql: ${TABLE}.SENTENCEID
  - dimension: suspendall
    sql: ${TABLE}.SUSPENDALL
  - dimension: suspendapplycharges
    sql: ${TABLE}.SUSPENDAPPLYCHARGES
  - dimension: suspenddays
    sql: ${TABLE}.SUSPENDDAYS
  - dimension: suspendmonths
    sql: ${TABLE}.SUSPENDMONTHS
  - dimension: suspendyears
    sql: ${TABLE}.SUSPENDYEARS
  - measure: count
    type: count

Contents

  • court_suspendcredit.view.lkml
  • court_suspendcredit.view.lookml