data.ml
LookML Media publishing

Sanitized Visitor General

Sanitized Visitor General model for media publishing.

source-preserved

Blocks

sanitized_visitor_general.view.lkml · 46 lines
inferred 
view: sanitized_visitor_general {
  sql_table_name: sanitized_db.sanitized_visitor_general ;;

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

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

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

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

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

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

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

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

  measure: count {
    type: count
  }
}
sanitized_visitor_general.view.lookml · 28 lines
source-preserved 
- view: sanitized_visitor_general
  sql_table_name: sanitized_db.sanitized_visitor_general
  fields:
  - dimension: accept_cookie_consent
    type: yesno
    sql: ${TABLE}.accept_cookie_consent
  - dimension: erights_id
    sql: ${TABLE}.erights_id
  - dimension: saw_cookie_consent
    type: yesno
    sql: ${TABLE}.saw_cookie_consent
  - dimension: sub_type
    type: number
    sql: ${TABLE}.sub_type
  - dimension: used_guest_pass
    type: yesno
    sql: ${TABLE}.used_guest_pass
  - dimension: user_guid
    sql: ${TABLE}.user_guid
  - dimension: user_urn
    type: number
    sql: ${TABLE}.user_urn
  - dimension: visitor_id
    type: int
    primary_key: true
    sql: ${TABLE}.visitor_id
  - measure: count
    type: count

Contents

  • sanitized_visitor_general.view.lkml
  • sanitized_visitor_general.view.lookml