data.ml
LookML Saas ecosystem

Tree Dim

Tree Dim model for saas ecosystem.

source-preserved

Blocks

tree_dim.view.lkml · 64 lines
inferred 
view: tree_dim {
  sql_table_name: public.tree_dim ;;

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

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

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

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

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

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

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

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

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

  dimension: show_in_marketplace {
    type: yesno
    sql: ${TABLE}.show_in_marketplace ;;
  }

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

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

  measure: count {
    type: count
    drill_fields: [id, leader_name]
  }
}
tree_dim.view.lookml · 40 lines
source-preserved 
- view: tree_dim
  sql_table_name: public.tree_dim
  fields:
  - dimension: id
    type: int
    primary_key: true
    sql: ${TABLE}.id
  - dimension: leader_id
    type: int
    sql: ${TABLE}.leader_id
  - dimension: leader_name
    sql: ${TABLE}.leader_name
  - dimension: created_date_id
    type: int
    sql: ${TABLE}.created_date_id
  - dimension: created_time_id
    type: int
    sql: ${TABLE}.created_time_id
  - dimension: description
    sql: ${TABLE}.description
  - dimension: first_published_date_id
    type: int
    sql: ${TABLE}.first_published_date_id
  - dimension: first_published_time_id
    type: int
    sql: ${TABLE}.first_published_time_id
  - dimension: publish_status
    sql: ${TABLE}.publish_status
  - dimension: show_in_marketplace
    type: yesno
    sql: ${TABLE}.show_in_marketplace
  - dimension: subtitle
    sql: ${TABLE}.subtitle
  - dimension: title
    sql: ${TABLE}.title
  - measure: count
    type: count
    drill_fields:
    - id
    - leader_name

Contents

  • tree_dim.view.lkml
  • tree_dim.view.lookml