data.ml
LKML Edtech

Student

Student model for edtech.

inferred

Blocks

student.view.lkml · 139 lines
inferred 
view: student {
  sql_table_name: public.Student ;;

  dimension: id {
    primary_key: yes
    sql: ${TABLE}.Id ;;
  }

  dimension: birth_city {
    sql: ${TABLE}.BirthCity ;;
  }

  dimension: birth_country_descriptor_id {
    type: int
    sql: ${TABLE}.BirthCountryDescriptorId ;;
  }

  dimension: birth_international_province {
    sql: ${TABLE}.BirthInternationalProvince ;;
  }

  dimension: birth_state_abbreviation_type_id {
    type: int
    sql: ${TABLE}.BirthStateAbbreviationTypeId ;;
  }

  dimension: citizenship_status_type_id {
    type: int
    sql: ${TABLE}.CitizenshipStatusTypeId ;;
  }

  dimension: displacement_status {
    sql: ${TABLE}.DisplacementStatus ;;
  }

  dimension: economic_disadvantaged {
    sql: ${TABLE}.EconomicDisadvantaged ;;
  }

  dimension: first_name {
    sql: ${TABLE}.FirstName ;;
  }

  dimension: generation_code_suffix {
    sql: ${TABLE}.GenerationCodeSuffix ;;
  }

  dimension: hispanic_latino_ethnicity {
    sql: ${TABLE}.HispanicLatinoEthnicity ;;
  }

  dimension: last_surname {
    sql: ${TABLE}.LastSurname ;;
  }

  dimension: limited_english_proficiency_descriptor_id {
    type: int
    sql: ${TABLE}.LimitedEnglishProficiencyDescriptorId ;;
  }

  dimension: login_id {
    sql: ${TABLE}.LoginId ;;
  }

  dimension: maiden_name {
    sql: ${TABLE}.MaidenName ;;
  }

  dimension: middle_name {
    sql: ${TABLE}.MiddleName ;;
  }

  dimension: multiple_birth_status {
    sql: ${TABLE}.MultipleBirthStatus ;;
  }

  dimension: old_ethnicity_type_id {
    type: int
    sql: ${TABLE}.OldEthnicityTypeId ;;
  }

  dimension: personal_title_prefix {
    sql: ${TABLE}.PersonalTitlePrefix ;;
  }

  dimension: profile_thumbnail {
    sql: ${TABLE}.ProfileThumbnail ;;
  }

  dimension: school_food_services_eligibility_descriptor_id {
    type: int
    sql: ${TABLE}.<redacted> ;;
  }

  dimension: sex_type_id {
    type: int
    sql: ${TABLE}.SexTypeId ;;
  }

  dimension: student_unique_id {
    sql: ${TABLE}.StudentUniqueId ;;
  }

  dimension: student_usi {
    type: int
    sql: ${TABLE}.StudentUSI ;;
  }

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

  dimension_group: create {
    type: time
    timeframes: [time, date, week, month]
    sql: ${TABLE}.CreateDate ;;
  }

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

  dimension_group: last_modified {
    type: time
    timeframes: [time, date, week, month]
    sql: ${TABLE}.LastModifiedDate ;;
  }

  measure: count {
    type: count
    drill_fields: [detail*]
  }
}
student.view.lookml · 96 lines
source-preserved 
- view: student
  sql_table_name: public.Student
  fields:
  - dimension: id
    primary_key: true
    sql: ${TABLE}.Id
  - dimension: birth_city
    sql: ${TABLE}.BirthCity
  - dimension: birth_country_descriptor_id
    type: int
    sql: ${TABLE}.BirthCountryDescriptorId
  - dimension: birth_international_province
    sql: ${TABLE}.BirthInternationalProvince
  - dimension: birth_state_abbreviation_type_id
    type: int
    sql: ${TABLE}.BirthStateAbbreviationTypeId
  - dimension: citizenship_status_type_id
    type: int
    sql: ${TABLE}.CitizenshipStatusTypeId
  - dimension: displacement_status
    sql: ${TABLE}.DisplacementStatus
  - dimension: economic_disadvantaged
    sql: ${TABLE}.EconomicDisadvantaged
  - dimension: first_name
    sql: ${TABLE}.FirstName
  - dimension: generation_code_suffix
    sql: ${TABLE}.GenerationCodeSuffix
  - dimension: hispanic_latino_ethnicity
    sql: ${TABLE}.HispanicLatinoEthnicity
  - dimension: last_surname
    sql: ${TABLE}.LastSurname
  - dimension: limited_english_proficiency_descriptor_id
    type: int
    sql: ${TABLE}.LimitedEnglishProficiencyDescriptorId
  - dimension: login_id
    sql: ${TABLE}.LoginId
  - dimension: maiden_name
    sql: ${TABLE}.MaidenName
  - dimension: middle_name
    sql: ${TABLE}.MiddleName
  - dimension: multiple_birth_status
    sql: ${TABLE}.MultipleBirthStatus
  - dimension: old_ethnicity_type_id
    type: int
    sql: ${TABLE}.OldEthnicityTypeId
  - dimension: personal_title_prefix
    sql: ${TABLE}.PersonalTitlePrefix
  - dimension: profile_thumbnail
    sql: ${TABLE}.ProfileThumbnail
  - dimension: school_food_services_eligibility_descriptor_id
    type: int
    sql: ${TABLE}.<redacted>
  - dimension: sex_type_id
    type: int
    sql: ${TABLE}.SexTypeId
  - dimension: student_unique_id
    sql: ${TABLE}.StudentUniqueId
  - dimension: student_usi
    type: int
    sql: ${TABLE}.StudentUSI
  - dimension_group: birth
    type: time
    timeframes:
    - date
    - week
    - month
    convert_tz: false
    sql: ${TABLE}.BirthDate
  - dimension_group: create
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.CreateDate
  - dimension_group: date_entered_us
    type: time
    timeframes:
    - date
    - week
    - month
    convert_tz: false
    sql: ${TABLE}.DateEnteredUS
  - dimension_group: last_modified
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.LastModifiedDate
  - measure: count
    type: count
    drill_fields:
    - detail*

Contents

  • student.view.lkml
  • student.view.lookml