data.ml
LookML Media publishing

Click

Click model for media publishing.

source-preserved

Blocks

click.view.lkml · 115 lines
inferred 
view: click {
  sql_table_name: sanitized_db.si_cs_click_recent ;;

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

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

  dimension: click_sequence {
  }

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

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

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

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

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

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

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

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

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

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

  dimension: parent_visit_id {
    type: int
    hidden: yes
    sql: ${TABLE}.parent_visit ;;
  }

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

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

  dimension: request_url_id {
    type: int
    hidden: yes
    sql: ${TABLE}.request_url ;;
  }

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

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

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

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

  measure: count {
    type: count
  }
}
click.view.lookml · 75 lines
source-preserved 
- view: click
  sql_table_name: sanitized_db.si_cs_click_recent
  fields:
  - dimension: click_id
    type: int
    primary_key: true
    hidden: true
    sql: ${TABLE}.click_id
  - dimension: click_duration
    type: number
    sql: ${TABLE}.click_duration
  - dimension: click_sequence
  - dimension: click_number
    type: number
    sql: ${TABLE}.click_number
  - dimension: internal_search
    type: number
    sql: ${TABLE}.internal_search
  - dimension: is_constructed
    type: yesno
    sql: ${TABLE}.is_constructed
  - dimension: is_first
    type: yesno
    sql: ${TABLE}.is_first
  - dimension: is_last
    type: yesno
    sql: ${TABLE}.is_last
  - dimension: line_number
    type: number
    sql: ${TABLE}.line_number
  - dimension: link_traversal_index
    type: number
    sql: ${TABLE}.link_traversal_index
  - dimension: number_of_requests
    type: number
    sql: ${TABLE}.number_of_requests
  - dimension: page_bytes_sent
    type: number
    sql: ${TABLE}.page_bytes_sent
  - dimension: page_visit_index
    type: number
    sql: ${TABLE}.page_visit_index
  - dimension: parent_visit_id
    type: int
    hidden: true
    sql: ${TABLE}.parent_visit
  - dimension: processing_time
    type: number
    sql: ${TABLE}.processing_time
  - dimension: referral_url
    type: number
    sql: ${TABLE}.referral_url
  - dimension: request_url_id
    type: int
    hidden: true
    sql: ${TABLE}.request_url
  - dimension: source_batch
    type: number
    sql: ${TABLE}.source_batch
  - dimension: status_code
    type: number
    sql: ${TABLE}.status_code
  - dimension: total_bytes_sent
    type: number
    sql: ${TABLE}.total_bytes_sent
  - dimension_group: timestamp
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.timestamp
  - measure: count
    type: count

Contents

  • click.view.lkml
  • click.view.lookml