data.ml
LookML Ecommerce

Exchange Rates

Exchange Rates model for ecommerce.

source-preserved

Blocks

exchange_rates.view.lkml · 43 lines
inferred 
view: exchange_rates {
  sql_table_name: storefront.exchange_rates ;;

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

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

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

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

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

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

  measure: count {
    type: count
    drill_fields: [id]
  }
}
exchange_rates.view.lookml · 41 lines
source-preserved 
- view: exchange_rates
  sql_table_name: storefront.exchange_rates
  fields:
  - dimension: id
    type: int
    primary_key: true
    sql: ${TABLE}.id
  - dimension: currency
    type: string
    sql: ${TABLE}.currency
  - dimension: usd_value
    type: number
    sql: ${TABLE}.usd_value
  - dimension_group: created
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.created_at
  - dimension_group: date
    type: time
    timeframes:
    - date
    - week
    - month
    convert_tz: false
    sql: ${TABLE}.date
  - dimension_group: updated
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.updated_at
  - measure: count
    type: count
    drill_fields:
    - id

Contents

  • exchange_rates.view.lkml
  • exchange_rates.view.lookml