data.ml
LookML Venture accelerator

Clicks

Clicks model for venture accelerator.

source-preserved

Blocks

clicks.view.lkml · 42 lines
inferred 
view: clicks {
  sql_table_name: public.clicks ;;

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

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

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

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

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

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

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

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

  measure: count {
    type: count
  }
}
clicks.view.lookml · 28 lines
source-preserved 
- view: clicks
  sql_table_name: public.clicks
  fields:
  - dimension: data_source
    sql: ${TABLE}.data_source
  - dimension: emd5
    sql: ${TABLE}.emd5
  - dimension: meta
    sql: ${TABLE}.meta
  - dimension: timestamp_int
    type: int
    sql: ${TABLE}.timestamp_int
  - dimension: token
    sql: ${TABLE}.token
  - dimension: url
    sql: ${TABLE}.url
  - dimension: user_agent
    sql: ${TABLE}.user_agent
  - dimension_group: timestamp_ts
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.timestamp_ts
  - measure: count
    type: count

Contents

  • clicks.view.lkml
  • clicks.view.lookml