data.ml
LookML Health marketing

Session Test Group

Session Test Group model for health marketing.

source-preserved

Blocks

session_test_group.view.lkml · 37 lines
inferred 
view: session_test_group {
  sql_table_name: data_warehouse.DWIMP_SESSION_TEST_GROUP ;;

  dimension: session_id {
    type: int
    primary_key: yes
    sql: ${TABLE}.SESSION_ID ;;
  }

  dimension: test_group_id {
    type: int
    sql: ${TABLE}.TEST_GROUP_ID ;;
  }

  dimension: test_group_name {
    sql: ${TABLE}.TEST_GROUP_NAME ;;
  }

  dimension: test_group_percent {
    type: int
    sql: ${TABLE}.TEST_GROUP_PERCENT ;;
  }

  dimension: test_id {
    type: int
    sql: ${TABLE}.TEST_ID ;;
  }

  dimension: test_name {
    sql: ${TABLE}.TEST_NAME ;;
  }

  measure: count {
    type: count
    drill_fields: [session_id]
  }
}
session_test_group.view.lookml · 24 lines
source-preserved 
- view: session_test_group
  sql_table_name: data_warehouse.DWIMP_SESSION_TEST_GROUP
  fields:
  - dimension: session_id
    type: int
    primary_key: true
    sql: ${TABLE}.SESSION_ID
  - dimension: test_group_id
    type: int
    sql: ${TABLE}.TEST_GROUP_ID
  - dimension: test_group_name
    sql: ${TABLE}.TEST_GROUP_NAME
  - dimension: test_group_percent
    type: int
    sql: ${TABLE}.TEST_GROUP_PERCENT
  - dimension: test_id
    type: int
    sql: ${TABLE}.TEST_ID
  - dimension: test_name
    sql: ${TABLE}.TEST_NAME
  - measure: count
    type: count
    drill_fields:
    - session_id

Contents

  • session_test_group.view.lkml
  • session_test_group.view.lookml