data.ml
LKML Social platform

Dia Campaigns

Dia Campaigns model for social platform.

inferred

Blocks

dia_campaigns.view.lkml · 68 lines
inferred 
view: dia_campaigns {
  sql_table_name: public.dia_campaigns ;;

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

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

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

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

  dimension: dirty {
    type: number
    sql: ${TABLE}.dirty ;;
  }

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

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

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

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

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

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

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

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

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

  measure: count {
    type: count
  }
}
dia_campaigns.view.lookml · 42 lines
source-preserved 
- view: dia_campaigns
  sql_table_name: public.dia_campaigns
  fields:
  - dimension: id
    type: int
    primary_key: true
    sql: ${TABLE}.id
  - dimension: campaign_title
    sql: ${TABLE}.campaign_title
  - dimension: description
    sql: ${TABLE}.description
  - dimension: dia_key
    sql: ${TABLE}.dia_key
  - dimension: dirty
    type: number
    sql: ${TABLE}.dirty
  - dimension: exclude_legislator_ids
    sql: ${TABLE}.exclude_legislator_ids
  - dimension: hwm_data
    sql: ${TABLE}.hwm_data
  - dimension: hwm_field
    sql: ${TABLE}.hwm_field
  - dimension: legislator_ids
    sql: ${TABLE}.legislator_ids
  - dimension: letter_salutation
    sql: ${TABLE}.letter_salutation
  - dimension: recipient_keys
    sql: ${TABLE}.recipient_keys
  - dimension: suggested_content
    sql: ${TABLE}.suggested_content
  - dimension: suggested_subject
    sql: ${TABLE}.suggested_subject
  - dimension_group: extracted_at_utc
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.extracted_at_utc
  - measure: count
    type: count

Contents

  • dia_campaigns.view.lkml
  • dia_campaigns.view.lookml