data.ml
LKML Saas cloud infrastructure

User Added Account

User Added Account model for saas cloud infrastructure.

inferred

Blocks

user_added_account.view.lkml · 52 lines
inferred 
view: user_added_account {
  sql_table_name: dcos.user_added_account ;;

  dimension: context_library_name {
    sql: ${TABLE}.context_library_name ;;
  }

  dimension: context_library_version {
    sql: ${TABLE}.context_library_version ;;
  }

  dimension: event {
    sql: ${TABLE}.event ;;
  }

  dimension: event_id {
    sql: ${TABLE}.event_id ;;
  }

  dimension: event_text {
    sql: ${TABLE}.event_text ;;
  }

  dimension: original_timestamp {
    sql: ${TABLE}.original_timestamp ;;
  }

  dimension: provider {
    sql: ${TABLE}.provider ;;
  }

  dimension: user_id {
    sql: ${TABLE}.user_id ;;
  }

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

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

  measure: count {
    type: count
    drill_fields: [context_library_name]
  }
}
user_added_account.view.lookml · 39 lines
source-preserved 
- view: user_added_account
  sql_table_name: dcos.user_added_account
  fields:
  - dimension: context_library_name
    sql: ${TABLE}.context_library_name
  - dimension: context_library_version
    sql: ${TABLE}.context_library_version
  - dimension: event
    sql: ${TABLE}.event
  - dimension: event_id
    sql: ${TABLE}.event_id
  - dimension: event_text
    sql: ${TABLE}.event_text
  - dimension: original_timestamp
    sql: ${TABLE}.original_timestamp
  - dimension: provider
    sql: ${TABLE}.provider
  - dimension: user_id
    sql: ${TABLE}.user_id
  - dimension_group: received
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.received_at
  - dimension_group: sent
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.sent_at
  - measure: count
    type: count
    drill_fields:
    - context_library_name

Contents

  • user_added_account.view.lkml
  • user_added_account.view.lookml