data.ml
LKML Fintech lending

Quote Subscription

Quote Subscription model for fintech lending.

inferred

Blocks

quote_subscription.view.lkml · 73 lines
inferred 
view: quote_subscription {
  sql_table_name: Latest.QuoteSubscription ;;

  dimension: by_email {
    type: yesno
    sql: ${TABLE}.byEmail ;;
  }

  dimension: by_sms {
    type: yesno
    sql: ${TABLE}.bySms ;;
  }

  dimension: is_subscribed {
    type: yesno
    sql: ${TABLE}.isSubscribed ;;
  }

  dimension: reference_quote_details_uuid {
    type: string
    sql: ${TABLE}.referenceQuoteDetailsUuid ;;
  }

  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 ;;
  }

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

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

  measure: count {
    type: count
  }
}
quote_subscription.view.lookml · 73 lines
source-preserved 
- view: quote_subscription
  sql_table_name: Latest.QuoteSubscription
  fields:
  - dimension: by_email
    type: yesno
    sql: ${TABLE}.byEmail
  - dimension: by_sms
    type: yesno
    sql: ${TABLE}.bySms
  - dimension: is_subscribed
    type: yesno
    sql: ${TABLE}.isSubscribed
  - dimension: reference_quote_details_uuid
    type: string
    sql: ${TABLE}.referenceQuoteDetailsUuid
  - 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
  - dimension_group: date_subscribed
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.dateSubscribed
  - dimension_group: date_subscribed_local
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.dateSubscribedLocal
  - measure: count
    type: count

Contents

  • quote_subscription.view.lkml
  • quote_subscription.view.lookml