view: snowflake_warehouse_metering_xf {
  sql_table_name: "INTELLIGENCE"."DBT_PROD"."SNOWFLAKE_WAREHOUSE_METERING_XF" ;;

  dimension: credit_rate {
    type: number
    sql: ${TABLE}."CREDIT_RATE" ;;
  }
  dimension: dollars_spent {
    hidden: yes
    type: number
    sql: ${TABLE}."DOLLARS_SPENT" ;;
  }
  dimension_group: end {
    type: time
    timeframes: [raw, time, date, week, month, quarter, year]
    sql: ${TABLE}."END_TIME" ;;
  }
  dimension_group: start {
    type: time
    timeframes: [raw, time, date, hour, week, month, quarter, year, month_num, month_name, quarter_of_year]
    sql: ${TABLE}."START_TIME" ;;
  }
  dimension_group: usage_day {
    type: time
    timeframes: [raw, time, date, hour, week, month, quarter, year]
    convert_tz: no
    datatype: date
    sql: ${TABLE}."USAGE_DAY" ;;
  }
  dimension: usage_length {
    type: number
    sql: ${TABLE}."USAGE_LENGTH" ;;
  }
  dimension_group: usage_month {
    type: time
    timeframes: [raw, date, week, month, quarter, year]
    convert_tz: no
    datatype: date
    sql: ${TABLE}."USAGE_MONTH" ;;
  }
  dimension: warehouse_id {
    type: number
    hidden: yes
    sql: ${TABLE}."WAREHOUSE_ID" ;;
  }
  dimension: warehouse_name {
    type: string
    sql: ${TABLE}."WAREHOUSE_NAME" ;;
  }

  dimension: warehouse_type {
    type: string
    sql:  case
    when ${warehouse_name} IN (
                             'LOOKER_WH_2',
                             'LOOKER_WH',
                             'LOOKER_WH_SONY',
                             'LOOKER_WH_ABACUS',
                             'LOOKER_WH_EXPLORE',
                             'LOOKER_WH_X_SMALL',
                             'KNR_LOOKER_WH',
                             'AWAL_LOOKER_WH',
                             'LOOKER_WH_PUBLISHING',
                             'LOOKER_WH_ACCOUNTING_AGGREGATES',
                             'LOOKER_WH_INTEGRATION',
                             'LOOKER_WH_PDE',
                             'LOOKER_WH_ORCHARD_BIZ_REV',
                             'LOOKER_WH_YOUTUBE',
                             'LOOKER_WH_SONY_PODCASTING',
                             'LOOKER_WH_STRATEGY') then 'Looker'
     when ${warehouse_name} in ('ANALYTICS_AD_HOC',
                             'PROD_ANALYTICS_ORCHARD_LARGE',
                             'PROD_ANALYTICS_ORCHARD_BACKFILL',
                             'PROD_ANALYTICS_ORCHARD_XL',
                             'ANALYTICS_DBT_FORECASTING',
                             'PROD_ANALYTICS_ORCHARD_MEDIUM',
                             'PROD_STRATEGY_ORCHARD_MEDIUM',
                             'PROD_STRATEGY_ORCHARD_LARGE',
                             'PROD_RIGHTS_MGMT_ORCHARD_MEDIUM',
                             'PROD_RIGHTS_MGMT_ORCHARD_LARGE',
                             'PROD_KNR_ORCHARD_LARGE',
                             'PROD_KNR_ORCHARD_MEDIUM') then 'dbt'
     when ${warehouse_name} in ('DEV_ANALYTICS_ORCHARD',
                                'DEV_ANALYTICS_ORCHARD_LARGE') then 'Development'
     when ${warehouse_name} in ('LOOKER_HIGH_PERFORMANCE') then 'Client Instance'
     when ${warehouse_name} in ('PROD_ANALYTICS_ORCHARD_EXTERNAL') then 'External Data Sends'
     else 'Other'
    END
    ;;
  }

  dimension: credits_used  {
    type: number
    sql: ${TABLE}."CREDITS_USED" ;;
  }

  measure: dollar_spend {
    description: "Amount spent ($)"
    type: sum
    value_format: "$0.00"
    sql: ${TABLE}."DOLLARS_SPENT" ;;
  }

  measure: credit_spend {
    description: "Amount Spent in Snowflake Credits"
    type: sum
    value_format: "0.#"
    sql: ${TABLE}."CREDITS_USED" ;;
  }
}