data.ml
LKML Fintech lending

Application

Application model for fintech lending.

inferred

Blocks

application.view.lkml · 51 lines
inferred 
view: application {
  sql_table_name: Latest.Application ;;

  dimension: application_state {
    type: string
    sql: ${TABLE}.applicationState ;;
  }

  dimension: quote_details_uuid {
    type: string
    sql: ${TABLE}.quoteDetailsUuid ;;
  }

  dimension: user_uuid {
    type: string
    sql: ${TABLE}.userUuid ;;
  }

  dimension: uuid {
    type: string
    sql: ${TABLE}.uuid ;;
  }

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

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

  dimension_group: date_created_local {
    type: time
    timeframes: [time, date, week, month, hour]
    sql: ${TABLE}.dateCreatedLocal ;;
  }

  dimension_group: date_last_modified_local {
    type: time
    timeframes: [time, date, week, month, hour]
    sql: ${TABLE}.dateLastModifiedLocal ;;
  }

  measure: count {
    type: count
  }
}
application.view.lookml · 51 lines
source-preserved 
- view: application
  sql_table_name: Latest.Application
  fields:
  - dimension: application_state
    type: string
    sql: ${TABLE}.applicationState
  - dimension: quote_details_uuid
    type: string
    sql: ${TABLE}.quoteDetailsUuid
  - dimension: user_uuid
    type: string
    sql: ${TABLE}.userUuid
  - dimension: uuid
    type: string
    sql: ${TABLE}.uuid
  - dimension_group: date_created
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.dateCreated
  - dimension_group: date_last_modified
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.dateLastModified
  - dimension_group: date_created_local
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    - hour
    sql: ${TABLE}.dateCreatedLocal
  - dimension_group: date_last_modified_local
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    - hour
    sql: ${TABLE}.dateLastModifiedLocal
  - measure: count
    type: count

Contents

  • application.view.lkml
  • application.view.lookml