data.ml
LookML Communications platform

Campaign

Campaign model for communications platform.

source-preserved

Blocks

campaign.view.lkml · 45 lines
inferred 
view: campaign {
  sql_table_name: source_db.Campaign ;;

  dimension: emoji {
    type: string
    sql: ${TABLE}.emoji ;;
  }

  dimension: friendly_name {
    type: string
    sql: ${TABLE}.friendlyName ;;
  }

  dimension: group {
    type: string
    sql: ${TABLE}.group ;;
  }

  dimension: object_id {
    type: string
    sql: ${TABLE}.objectId ;;
  }

  dimension: type {
    type: string
    sql: ${TABLE}.type ;;
  }

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

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

  measure: count {
    type: count
    drill_fields: [friendly_name]
  }
}
campaign.view.lookml · 38 lines
source-preserved 
- view: campaign
  sql_table_name: source_db.Campaign
  fields:
  - dimension: emoji
    type: string
    sql: ${TABLE}.emoji
  - dimension: friendly_name
    type: string
    sql: ${TABLE}.friendlyName
  - dimension: group
    type: string
    sql: ${TABLE}.group
  - dimension: object_id
    type: string
    sql: ${TABLE}.objectId
  - dimension: type
    type: string
    sql: ${TABLE}.type
  - dimension_group: created
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.createdAt
  - dimension_group: updated
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.updatedAt
  - measure: count
    type: count
    drill_fields:
    - friendly_name

Contents

  • campaign.view.lkml
  • campaign.view.lookml