data.ml
LKML Clothing app

Interaction Tool

Interaction Tool model for clothing app.

inferred

Blocks

interaction_tool.view.lkml · 56 lines
inferred 
view: interaction_tool {
  sql_table_name: central_data.interaction_tool ;;

  dimension: id {
    description: "primary key for interaction_tool table"
    type: int
    primary_key: yes
    sql: ${TABLE}.id ;;
  }

  dimension: account_id {
    description: "<% parameter partner_name %> account ID"
    type: int
    sql: ${TABLE}.account_id ;;
  }

  dimension: profile_id {
    description: "<% parameter partner_name %> user profile ID"
    type: int
    sql: ${TABLE}.profile_id ;;
  }

  dimension: step_index {
    description: "Step in walk thru"
    type: int
    sql: ${TABLE}.step_index ;;
  }

  dimension: type {
    description: "type of event e.g. NewStepShown, UserStoppedWalkthru"
    sql: ${TABLE}.type ;;
  }

  dimension: walkthrough_id {
    description: "Walk thru ID"
    type: int
    sql: ${TABLE}.walkthrough_id ;;
  }

  dimension: walkthrough_name {
    description: "Walk thru Name"
    sql: ${TABLE}.walkthrough_name ;;
  }

  dimension_group: created {
    description: "date time walk thru event created"
    type: time
    timeframes: [time, date, week, month]
    sql: ${TABLE}.created_at ;;
  }

  measure: count {
    type: count
    drill_fields: [detail*]
  }
}
interaction_tool.view.lookml · 42 lines
source-preserved 
- view: interaction_tool
  sql_table_name: central_data.interaction_tool
  fields:
  - dimension: id
    type: int
    primary_key: true
    description: primary key for interaction_tool table
    sql: ${TABLE}.id
  - dimension: account_id
    type: int
    description: '<% parameter partner_name %> account ID'
    sql: ${TABLE}.account_id
  - dimension: profile_id
    type: int
    description: '<% parameter partner_name %> user profile ID'
    sql: ${TABLE}.profile_id
  - dimension: step_index
    type: int
    description: Step in walk thru
    sql: ${TABLE}.step_index
  - dimension: type
    description: type of event e.g. NewStepShown, UserStoppedWalkthru
    sql: ${TABLE}.type
  - dimension: walkthrough_id
    type: int
    description: Walk thru ID
    sql: ${TABLE}.walkthrough_id
  - dimension: walkthrough_name
    description: Walk thru Name
    sql: ${TABLE}.walkthrough_name
  - dimension_group: created
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.created_at
  - measure: count
    type: count
    drill_fields:
    - detail*

Contents

  • interaction_tool.view.lkml
  • interaction_tool.view.lookml