view: monthly_snowflake_storage_costs {
  sql_table_name: "INTELLIGENCE"."DBT_PROD"."MONTHLY_SNOWFLAKE_STORAGE_COSTS" ;;

  dimension: is_first_run_of_month {
    description: "Boolean to get first snapshot of the month for comparison purposes"
    type: yesno
    sql: ${TABLE}."IS_FIRST_RUN_OF_MONTH" ;;
  }

  dimension: is_first_run_of_day {
    description: "Boolean to get first snapshot of the day for comparison purposes"
    type: yesno
    sql: ${TABLE}."IS_FIRST_RUN_OF_DAY";;
  }

  dimension_group: model_run {
    description: "Date undelying model was run to take snapshot of storage costs (runs once per day)"
    type: time
    timeframes: [date, month]
    convert_tz: no
    datatype: date
    sql: ${TABLE}."MODEL_RUN_DATE" ;;
  }
  dimension_group: model_run_month {
    hidden: yes
    type: time
    timeframes: [raw, date, week, month, quarter, year]
    convert_tz: no
    datatype: date
    sql: ${TABLE}."MODEL_RUN_MONTH" ;;
  }
  dimension_group: model_run_timestamp {
    hidden: yes
    type: time
    timeframes: [raw, time, date, week, month, quarter, year]
    sql: ${TABLE}."MODEL_RUN_TIMESTAMP" ;;
  }
  dimension: schema_type {
    description: "Schema classification hueristic"
    type: string
    sql: ${TABLE}."SCHEMA_TYPE" ;;
  }
  dimension: table_name {
    description: "Name of Table"
    type: string
    sql: ${TABLE}."TABLE_NAME" ;;
  }
  dimension: table_schema {
    description: "Name of Schema"
    type: string
    sql: ${TABLE}."TABLE_SCHEMA" ;;
  }
  measure: monthly_cost{
    description: "Snapshot of Cost of 1 Months Storage in dollars"
    type: sum
    value_format:"$#.00;($#.00)"
    sql: ${TABLE}."MONTHLY_COST_DOLLARS" ;;
  }
}