data.ml
LKML Telecom services

Sfdc Accts

Sfdc Accts model for telecom services.

inferred

Blocks

sfdc_accts.view.lkml · 49 lines
inferred 
view: sfdc_accts {
  sql_table_name: sales_mkt.sfdc_accts ;;

  dimension: accountid {
    primary_key: yes
    sql: ${TABLE}.accountid ;;
  }

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

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

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

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

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

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

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

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

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

  measure: count {
    type: count
    drill_fields: [detail*]
  }
}
sfdc_accts.view.lookml · 28 lines
source-preserved 
- view: sfdc_accts
  sql_table_name: sales_mkt.sfdc_accts
  fields:
  - dimension: accountid
    primary_key: true
    sql: ${TABLE}.accountid
  - dimension: accountname
    sql: ${TABLE}.accountname
  - dimension: accounttype
    sql: ${TABLE}.accounttype
  - dimension: accountowner
    sql: ${TABLE}.accountowner
  - dimension: account_createddate
    sql: ${TABLE}.account_createddate
  - dimension: segment
    sql: ${TABLE}.segment
  - dimension: company_id
    sql: ${TABLE}.company_id
  - dimension: industry
    sql: ${TABLE}.industry
  - dimension: employees
    sql: ${TABLE}.employees
  - dimension: billingstate
    sql: ${TABLE}.billingstate
  - measure: count
    type: count
    drill_fields:
    - detail*

Contents

  • sfdc_accts.view.lkml
  • sfdc_accts.view.lookml