data.ml
LookML Saas experience management

Organizations

Organizations model for saas experience management.

source-preserved

Blocks

organizations.view.lkml · 57 lines
inferred 
view: organizations {
  sql_table_name: external_system._organizations ;;

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

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

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

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

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

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

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

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

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

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

  measure: count {
    type: count
    drill_fields: [detail*]
  }
}
organizations.view.lookml · 44 lines
source-preserved 
- view: organizations
  sql_table_name: external_system._organizations
  fields:
  - dimension: id
    type: int
    primary_key: true
    sql: ${TABLE}.id
  - dimension: details
    sql: ${TABLE}.details
  - dimension: external_id
    sql: ${TABLE}.external_id
  - dimension: group_id
    type: int
    sql: ${TABLE}.group_id
  - dimension: name
    sql: ${TABLE}.name
  - dimension: notes
    sql: ${TABLE}.notes
  - dimension: shared_comments
    type: yesno
    sql: ${TABLE}.shared_comments
  - dimension: shared_tickets
    type: yesno
    sql: ${TABLE}.shared_tickets
  - dimension_group: created
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.created_at
  - dimension_group: updated
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.updated_at
  - measure: count
    type: count
    drill_fields:
    - detail*

Contents

  • organizations.view.lkml
  • organizations.view.lookml