data.ml
LKML Communications platform

Goal Steps

Goal Steps model for communications platform.

inferred

Blocks

goal_steps.view.lkml · 61 lines
inferred 
view: goal_steps {
  sql_table_name: source_db.GoalStep ;;

  dimension: agent_reminder_message {
    sql: ${TABLE}.agentReminderMessage ;;
  }

  dimension: eligibility_window_relative_end {
    type: int
    sql: ${TABLE}.eligibilityWindowRelativeEnd ;;
  }

  dimension: eligibility_window_relative_start {
    type: int
    sql: ${TABLE}.eligibilityWindowRelativeStart ;;
  }

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

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

  dimension: targeting_spec {
    sql: ${TABLE}.targetingSpec ;;
  }

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

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

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

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

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

  measure: count {
    type: count
  }
}
goal_steps.view.lookml · 53 lines
source-preserved 
- view: goal_steps
  sql_table_name: source_db.GoalStep
  fields:
  - dimension: agent_reminder_message
    sql: ${TABLE}.agentReminderMessage
  - dimension: eligibility_window_relative_end
    type: int
    sql: ${TABLE}.eligibilityWindowRelativeEnd
  - dimension: eligibility_window_relative_start
    type: int
    sql: ${TABLE}.eligibilityWindowRelativeStart
  - dimension: goal
    sql: ${TABLE}.goal
  - dimension: object_id
    sql: ${TABLE}.objectId
  - dimension: targeting_spec
    sql: ${TABLE}.targetingSpec
  - dimension: type
    sql: ${TABLE}.type
  - dimension_group: created
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.createdAt
  - dimension_group: eligibility_window_absolute_end
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.eligibilityWindowAbsoluteEnd
  - dimension_group: eligibility_window_absolute_start
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.eligibilityWindowAbsoluteStart
  - dimension_group: updated
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.updatedAt
  - measure: count
    type: count

Contents

  • goal_steps.view.lkml
  • goal_steps.view.lookml