data.ml
LookML Saas ecosystem

Feature Usage Fact

Feature Usage Fact model for saas ecosystem.

source-preserved

Blocks

feature_usage_fact.view.lkml · 55 lines
inferred 
view: feature_usage_fact {
  sql_table_name: public.feature_usage_fact ;;

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

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

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

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

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

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

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

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

  dimension_group: feature_usage {
    type: time
    timeframes: [date, week, month, month_num, day_of_week, day_of_week_index, week_of_year, day_of_month, time, hour_of_day, hour, time_of_day]
    sql: (SUBSTRING(${date_id}, 1, 4) || '-' || SUBSTRING(${date_id}, 5, 2) || '-' || SUBSTRING(${date_id}, 7, 2)|| ' ' || ${time_dim.minute_description} || ':00')::timestamp ;;
  }

  measure: count {
    type: count
    drill_fields: [id]
  }
}
feature_usage_fact.view.lookml · 48 lines
source-preserved 
- view: feature_usage_fact
  sql_table_name: public.feature_usage_fact
  fields:
  - dimension: id
    type: int
    primary_key: true
    sql: ${TABLE}.id
  - dimension: champion_connection_type_id
    type: int
    sql: ${TABLE}.champion_connection_type_id
  - dimension: leader_id
    type: int
    sql: ${TABLE}.leader_id
  - dimension: cohort_id
    type: int
    sql: ${TABLE}.cohort_id
  - dimension: date_id
    type: int
    sql: ${TABLE}.date_id
  - dimension: feature_id
    type: int
    sql: ${TABLE}.feature_id
  - dimension: time_id
    type: int
    sql: ${TABLE}.time_id
  - dimension: user_id
    type: int
    sql: ${TABLE}.user_id
  - dimension_group: feature_usage
    type: time
    timeframes:
    - date
    - week
    - month
    - month_num
    - day_of_week
    - day_of_week_index
    - week_of_year
    - day_of_month
    - time
    - hour_of_day
    - hour
    - time_of_day
    sql: (SUBSTRING(${date_id}, 1, 4) || '-' || SUBSTRING(${date_id}, 5, 2) || '-' || SUBSTRING(${date_id}, 7, 2)|| ' ' || ${time_dim.minute_description} || ':00')::timestamp
  - measure: count
    type: count
    drill_fields:
    - id

Contents

  • feature_usage_fact.view.lkml
  • feature_usage_fact.view.lookml