data.ml
LookML Venture accelerator

Opens

Opens model for venture accelerator.

source-preserved

Blocks

opens.view.lkml · 48 lines
inferred 
view: opens {
  sql_table_name: public.opens ;;

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

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

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

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

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

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

  dimension: emd5_first_two {
    sql: left(emd5, 2) ;;
  }

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

  measure: count {
    type: count
    drill_fields: [token, data_source, timestamp_ts_date, sends.email_template]
  }

  measure: count_data_sources {
    type: count_distinct
    sql: ${data_source} ;;
  }
}
opens.view.lookml · 37 lines
source-preserved 
- view: opens
  sql_table_name: public.opens
  fields:
  - dimension: data_source
    sql: ${TABLE}.data_source
  - dimension: emd5
    sql: ${TABLE}.emd5
  - dimension: meta
    sql: ${TABLE}.meta
  - dimension: timestamp_int
    type: time
    sql: ${TABLE}.timestamp_int
  - dimension: token
    sql: ${TABLE}.token
  - dimension: user_agent
    sql: ${TABLE}.user_agent
  - dimension: emd5_first_two
    sql: left(emd5, 2)
  - dimension_group: timestamp_ts
    type: time
    timeframes:
    - time
    - hour
    - date
    - week
    - month
    sql: ${TABLE}.timestamp_ts
  - measure: count
    type: count
    drill_fields:
    - token
    - data_source
    - timestamp_ts_date
    - sends.email_template
  - measure: count_data_sources
    type: count_distinct
    sql: ${data_source}

Contents

  • opens.view.lkml
  • opens.view.lookml