data.ml
LKML Social platform

Victory Funds

Victory Funds model for social platform.

inferred

Blocks

victory_funds.view.lkml · 63 lines
inferred 
view: victory_funds {
  sql_table_name: public.victory_funds ;;

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

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

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

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

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

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

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

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

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

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

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

  measure: count {
    type: count
  }
}
victory_funds.view.lookml · 51 lines
source-preserved 
- view: victory_funds
  sql_table_name: public.victory_funds
  fields:
  - dimension: id
    type: int
    primary_key: true
    sql: ${TABLE}.id
  - dimension: fulfillment_active
    type: number
    sql: ${TABLE}.fulfillment_active
  - dimension: hwm_data
    sql: ${TABLE}.hwm_data
  - dimension: hwm_field
    sql: ${TABLE}.hwm_field
  - dimension: petition_id
    type: int
    sql: ${TABLE}.petition_id
  - dimension: sponsorship_active
    type: number
    sql: ${TABLE}.sponsorship_active
  - dimension: state
    sql: ${TABLE}.state
  - dimension: total_cents
    type: int
    sql: ${TABLE}.total_cents
  - dimension_group: created
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.created_at
  - dimension_group: extracted_at_utc
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.extracted_at_utc
  - dimension_group: updated
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.updated_at
  - measure: count
    type: count

Contents

  • victory_funds.view.lkml
  • victory_funds.view.lookml