data.ml
LKML Saas ecosystem

To Do List Dim

To Do List Dim model for saas ecosystem.

inferred

Blocks

to_do_list_dim.view.lkml · 38 lines
inferred 
view: to_do_list_dim {
  sql_table_name: public.to_do_list_dim ;;

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

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

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

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

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

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

  measure: count {
    type: count
    drill_fields: [id, name]
  }
}
to_do_list_dim.view.lookml · 26 lines
source-preserved 
- view: to_do_list_dim
  sql_table_name: public.to_do_list_dim
  fields:
  - dimension: id
    type: int
    primary_key: true
    sql: ${TABLE}.id
  - dimension: created_date_id
    type: int
    sql: ${TABLE}.created_date_id
  - dimension: created_time_id
    type: int
    sql: ${TABLE}.created_time_id
  - dimension: name
    sql: ${TABLE}.name
  - dimension: updated_date_id
    type: int
    sql: ${TABLE}.updated_date_id
  - dimension: updated_time_id
    type: int
    sql: ${TABLE}.updated_time_id
  - measure: count
    type: count
    drill_fields:
    - id
    - name

Contents

  • to_do_list_dim.view.lkml
  • to_do_list_dim.view.lookml