data.ml
LKML Service marketplace

Zendesk Tickets Custom Fields

Zendesk Tickets Custom Fields model for service marketplace.

inferred

Blocks

zendesk_tickets_custom_fields.view.lkml · 43 lines
inferred 
view: zendesk_tickets_custom_fields {
  sql_table_name: adminProd_zendesk_tickets_custom_fields ;;

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

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

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

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

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

  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
  }
}
zendesk_tickets_custom_fields.view.lookml · 35 lines
source-preserved 
- view: zendesk_tickets_custom_fields
  sql_table_name: adminProd_zendesk_tickets_custom_fields
  fields:
  - dimension: id
    type: int
    primary_key: true
    sql: ${TABLE}.id
  - dimension: account
    sql: ${TABLE}.account
  - dimension: field_id
    type: int
    sql: ${TABLE}.field_id
  - dimension: field_value
    sql: ${TABLE}.field_value
  - dimension: zendesk_ticket_id
    type: int
    sql: ${TABLE}.zendesk_ticket_id
  - 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

Contents

  • zendesk_tickets_custom_fields.view.lkml
  • zendesk_tickets_custom_fields.view.lookml