data.ml
LookML Travel app

Company Os Cases

Company Os Cases model for travel app.

source-preserved

Blocks

company_os_cases.view.lkml · 66 lines
inferred 
view: company_os_cases {
  sql_table_name: os_cases ;;

  dimension: id {
    primary_key: yes
    sql: ${TABLE}.id ;;
  }

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

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

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

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

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

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

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

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

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

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

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

  measure: count {
    type: count
  }
}
company_os_cases.view.lookml · 60 lines
source-preserved 
- view: company_os_cases
  sql_table_name: os_cases
  fields:
  - dimension: id
    primary_key: true
    sql: ${TABLE}.id
  - dimension: begin
    sql: ${TABLE}.begin
  - dimension: description
    sql: ${TABLE}.description
  - dimension: reward_image_url_en
    sql: ${TABLE}.reward_image_url_en
  - dimension: reward_image_url_es
    sql: ${TABLE}.reward_image_url_es
  - dimension: reward_image_url_fr
    sql: ${TABLE}.reward_image_url_fr
  - dimension: tip_info
    sql: ${TABLE}.tip_info
  - dimension_group: created
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.created_at
  - dimension_group: end
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.end_at
  - dimension_group: start
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.start_at
  - dimension_group: time
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.time
  - dimension_group: updated
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.updated_at
  - measure: count
    type: count

Contents

  • company_os_cases.view.lkml
  • company_os_cases.view.lookml