data.ml
LKML Communications platform

Actions

Actions model for communications platform.

inferred

Blocks

actions.view.lkml · 61 lines
inferred 
view: actions {
  sql_table_name: source_db.Action ;;

  dimension: action_type {
    sql: ${TABLE}.actionType ;;
  }

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

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

  dimension: object_id {
    sql: ${TABLE}.objectId ;;
  }

  dimension: reporting_agent {
    sql: ${TABLE}.reportingAgent ;;
  }

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

  dimension: value_num {
    type: int
    sql: ${TABLE}.valueNum ;;
  }

  dimension: value_str {
    sql: ${TABLE}.valueStr ;;
  }

  dimension: value_type {
    sql: ${TABLE}.valueType ;;
  }

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

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

  measure: count_unique_lead {
    type: count_distinct
    sql: ${lead} ;;
  }

  measure: count {
    type: count
  }
}
actions.view.lookml · 43 lines
source-preserved 
- view: actions
  sql_table_name: source_db.Action
  fields:
  - dimension: action_type
    sql: ${TABLE}.actionType
  - dimension: goal
    sql: ${TABLE}.goal
  - dimension: lead
    sql: ${TABLE}.lead
  - dimension: object_id
    sql: ${TABLE}.objectId
  - dimension: reporting_agent
    sql: ${TABLE}.reportingAgent
  - dimension: type
    sql: ${TABLE}.type
  - dimension: value_num
    type: int
    sql: ${TABLE}.valueNum
  - dimension: value_str
    sql: ${TABLE}.valueStr
  - dimension: value_type
    sql: ${TABLE}.valueType
  - dimension_group: created
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.createdAt
  - dimension_group: updated
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.updatedAt
  - measure: count_unique_lead
    type: count_distinct
    sql: ${lead}
  - measure: count
    type: count

Contents

  • actions.view.lkml
  • actions.view.lookml