data.ml
LKML Subscription reading

Ad Impressions

Ad Impressions model for subscription reading.

inferred

Blocks

ad_impressions.view.lkml · 56 lines
inferred 
view: ad_impressions {
  sql_table_name: warehouse.ad_impressions ;;

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

  dimension: created_yesno {
    type: yesno
    sql: COALESCE(${TABLE}.created_at, '') != '' ;;
  }

  dimension: created_week {
    type: date
    sql: to_date(date_sub(${TABLE}.created_at, (dayofweek(${TABLE}.created_at)+5)%7)) ;;
  }

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

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

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

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

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

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

  dimension_group: created {
    type: time
    timeframes: [time, date, month, year]
    sql: ${TABLE}.created_at ;;
  }

  measure: count {
    type: count
  }
}
ad_impressions.view.lookml · 41 lines
source-preserved 
- view: ad_impressions
  sql_table_name: warehouse.ad_impressions
  fields:
  - dimension: dt
    sql: ${TABLE}.dt
  - dimension: created_yesno
    type: yesno
    sql: COALESCE(${TABLE}.created_at, '') != ''
  - dimension: created_week
    type: date
    sql: to_date(date_sub(${TABLE}.created_at, (dayofweek(${TABLE}.created_at)+5)%7))
  - dimension: event_type
    sql: ${TABLE}.event_type
  - dimension: object_id
    type: int
    sql: ${TABLE}.object_id
  - dimension: user_id
    type: int
    sql: ${TABLE}.user_id
  - dimension: user_ip
    type: number
    sql: ${TABLE}.user_ip
  - dimension: user_uuid
    sql: ${TABLE}.user_uuid
  - dimension_group: dt
    type: time
    timeframes:
    - date
    - month
    - year
    sql: ${TABLE}.dt
  - dimension_group: created
    type: time
    timeframes:
    - time
    - date
    - month
    - year
    sql: ${TABLE}.created_at
  - measure: count
    type: count

Contents

  • ad_impressions.view.lkml
  • ad_impressions.view.lookml