data.ml
LKML Subscription reading

App Installations

App Installations model for subscription reading.

inferred

Blocks

app_installations.view.lkml · 48 lines
inferred 
view: app_installations {
  sql_table_name: warehouse.app_installs ;;

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

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

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

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

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

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

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

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

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

  measure: count {
    type: count
  }
}
app_installations.view.lookml · 32 lines
source-preserved 
- view: app_installations
  sql_table_name: warehouse.app_installs
  fields:
  - dimension: install_yesno
    type: yesno
    sql: COALESCE(${TABLE}.install_date, '') != ''
  - dimension: install_week
    type: date
    sql: to_date(date_sub(${TABLE}.install_date, (dayofweek(${TABLE}.install_date)+5)%7))
  - dimension: device_full_name
    sql: ${TABLE}.device_full_name
  - dimension: device_id
    sql: ${TABLE}.device_id
  - dimension: device_short_name
    sql: ${TABLE}.device_short_name
  - dimension: install_app_version
    sql: ${TABLE}.install_app_version
  - dimension: install_ts
    sql: ${TABLE}.install_ts
  - dimension: word_user_id
    type: int
    sql: ${TABLE}.word_user_id
  - dimension_group: install
    type: time
    timeframes:
    - time
    - date
    - month
    - year
    sql: ${TABLE}.install_date
  - measure: count
    type: count

Contents

  • app_installations.view.lkml
  • app_installations.view.lookml