view: dim_currency {
  sql_table_name: facts.prod.DIM_CURRENCY ;;

  dimension: conversion_rate {
    hidden: yes
    sql: ${TABLE}.CONVERSION_RATE ;;
  }

  dimension: currency_code {
    hidden:  yes
    sql: ${TABLE}.CURRENCY_CODE ;;
  }

  dimension: original_currency_code {
    sql: ${TABLE}.CURRENCY_CODE ;;
  }

  dimension: payout_currency_code {
    sql: ${TABLE}.CURRENCY_CODE ;;
  }

  dimension: currency_name {
    hidden: yes
    sql: ${TABLE}.CURRENCY_NAME ;;
  }

  dimension: currencyid {
    hidden:  yes
    primary_key: yes
    sql: ${TABLE}.CURRENCYID ;;
  }

  dimension: original_currency_id {
    sql: ${TABLE}.CURRENCYID ;;
  }

  dimension: payout_currency_id {
    sql: ${TABLE}.CURRENCYID ;;
  }

  dimension: date_updated {
    hidden: yes
    sql: ${TABLE}.DATE_UPDATED ;;
  }

  measure: number_of_currencies {
    type: count_distinct
    sql: ${TABLE}.CURRENCYID ;;
  }
}