# Auto-generated via Rick's RScript on Mon Mar 14 12:54 PM Eastern
view: production_dim_catalog {
  sql_table_name: facts.prod.dim_catalog ;;
  ## ~~~~~~~~~~~~~~~~~~~~~~~ [vvv   START Manually Added   vvv] ~~~~~~~~~~~~~~~~~~~~~~~ ##
  ##
  ##
  ##                           Put Any Manual Changes Here
  ##
  ##
  ## ~~~~~~~~~~~~~~~~~~~~~~~ [^^^    END  Manually Added   ^^^] ~~~~~~~~~~~~~~~~~~~~~~~ ##

  ## ~~~~~~~~~~~~~~~~~~~~~~~ [vvv   |Start (blank) View Label|   vvv] ~~~~~~~~~~~~~~~~~~~~~~~ ##
  measure: number_of_rows {
    label: "Number of Rows"
    description: "row count for group based on table production.dim_catalog"
    type: count
  }

  ## ~~~~~~~~~~~~~~~~~~~~~~~ [^^^    |End (blank) View Label|    ^^^] ~~~~~~~~~~~~~~~~~~~~~~~ ##

  ## ~~~~~~~~~~~~~~~~~~~~~~~ [vvv   |Start Date View Label|   vvv] ~~~~~~~~~~~~~~~~~~~~~~~ ##
  dimension_group: date_created {
    label: "Created"
    description: ""
    #alias: [created]
    timeframes: [
      year,
      month,
      month_num,
      date,
      day_of_week,
      week,
      time,
      hour
    ]
    sql: ${TABLE}.date_created ;;
    type: time
  }

  dimension_group: last_updated {
    label: "Last Upd"
    description: ""
    #alias: [last_updated]
    timeframes: [
      year,
      month,
      month_num,
      date,
      day_of_week,
      week,
      time,
      hour
    ]
    sql: ${TABLE}.last_updated ;;
    type: time
  }

  ## ~~~~~~~~~~~~~~~~~~~~~~~ [^^^    |End Date View Label|    ^^^] ~~~~~~~~~~~~~~~~~~~~~~~ ##

  ## ~~~~~~~~~~~~~~~~~~~~~~~ [vvv   |Start Label View Label|   vvv] ~~~~~~~~~~~~~~~~~~~~~~~ ##
  dimension: label_id {
    view_label: "Label"
    label: "ID"
    description: ""
    suggestable: yes
    suggest_explore: bi_label_view
    suggest_dimension: bi_label_view.label_id
    sql: ${TABLE}.labelid ;;
    type: number
    value_format: "####"
  }

  measure: count_distinct_labels {
    view_label: "Label"
    label: "Number of Labels"
    description: "Unique Label counts (by group; within your filters)"
    hidden: no
    suggestable: no
    sql: ${TABLE}.labelid ;;
    type: count_distinct
    value_format: "#,###"
  }

  ## ~~~~~~~~~~~~~~~~~~~~~~~ [^^^    |End Label View Label|    ^^^] ~~~~~~~~~~~~~~~~~~~~~~~ ##

  ## ~~~~~~~~~~~~~~~~~~~~~~~ [vvv   |Start Catalog View Label|   vvv] ~~~~~~~~~~~~~~~~~~~~~~~ ##
  measure: count_distinct_old_catalogs {
    view_label: "Catalog"
    label: "Number of Old Catalogs"
    description: "Unique Old Catalog counts (by group; within your filters)"
    hidden: no
    suggestable: no
    sql: ${TABLE}.old_catalog_id ;;
    type: count_distinct
    value_format: "#,###"
  }

  dimension: old_catalog_id {
    view_label: "Catalog"
    label: "Old Catalog ID"
    description: ""
    sql: ${TABLE}.old_catalog_id ;;
    type: string
  }

  dimension: catalog_id {
    view_label: "Catalog"
    label: "ID"
    description: ""
    hidden: no
    sql: ${TABLE}.catalogid ;;
    type: number
    value_format: "####"
    primary_key: yes
  }

  dimension: catalog_name {
    view_label: "Catalog"
    label: "Name"
    description: "Catalog Name"
    case_sensitive: no
    sql: ${TABLE}.catalogname ;;
    type: string
  }

  dimension: catalog_number {
    view_label: "Catalog"
    label: "Number"
    description: "Catalog Number"
    case_sensitive: no
    sql: ${TABLE}.catalognumber ;;
    type: string
  }

  measure: count_distinct_catalogs {
    view_label: "Catalog"
    label: "Number of Catalogs"
    hidden: no
    suggestable: no
    sql: ${TABLE}.catalogid ;;
    type: count_distinct
    value_format: "#,###"
  }

  ## ~~~~~~~~~~~~~~~~~~~~~~~ [^^^    |End Catalog View Label|    ^^^] ~~~~~~~~~~~~~~~~~~~~~~~ ##

  ## ~~~~~~~~~~~~~~~~~~~~~~~ [vvv   |Start Subaccount View Label|   vvv] ~~~~~~~~~~~~~~~~~~~~~~~ ##
  dimension: subaccount_id {
    view_label: "Subaccount"
    label: "ID"
    description: ""
    sql: ${TABLE}.subaccountid ;;
    type: number
    value_format: "####"
  }

  measure: count_distinct_subaccounts {
    view_label: "Subaccount"
    label: "Number of Subaccounts"
    description: "Unique Subaccount counts (by group; within your filters)"
    hidden: no
    suggestable: no
    sql: ${TABLE}.subaccountid ;;
    type: count_distinct
    value_format: "#,###"
  }

  ## ~~~~~~~~~~~~~~~~~~~~~~~ [^^^    |End Subaccount View Label|    ^^^] ~~~~~~~~~~~~~~~~~~~~~~~ ##

  ## ~~~~~~~~~~~~~~~~~~~~~~~ [vvv   |Start zETL catalog View Label|   vvv] ~~~~~~~~~~~~~~~~~~~~~~~ ##
  measure: max_date_created {
    view_label: "zETL catalog"
    label: "Max Created"
    description: ""
    #alias: [max_created]
    hidden: yes
    suggestable: no
    sql: MAX(${TABLE}.date_created) ;;
    type: string
  }

  measure: max_last_updated {
    view_label: "zETL catalog"
    label: "Max Last Upd"
    description: ""
    #alias: [max_last_updated]
    hidden: yes
    suggestable: no
    sql: MAX(${TABLE}.last_updated) ;;
    type: string
  }

  measure: min_date_created {
    view_label: "zETL catalog"
    label: "Min Created"
    description: ""
    #alias: [min_created]
    hidden: yes
    suggestable: no
    sql: MIN(${TABLE}.date_created) ;;
    type: string
  }

  measure: min_last_updated {
    view_label: "zETL catalog"
    label: "Min Last Upd"
    description: ""
    #alias: [min_last_updated]
    hidden: yes
    suggestable: no
    sql: MIN(${TABLE}.last_updated) ;;
    type: string
  }

  ## ~~~~~~~~~~~~~~~~~~~~~~~ [^^^    |End zETL catalog View Label|    ^^^] ~~~~~~~~~~~~~~~~~~~~~~~ ##


  set: production_dim_catalog.all_fields {
    fields: [
      production_dim_catalog.date_created,
      production_dim_catalog.last_updated,
      production_dim_catalog.label_id,
      production_dim_catalog.count_distinct_labels,
      production_dim_catalog.old_catalog_id,
      production_dim_catalog.count_distinct_old_catalogs,
      production_dim_catalog.catalog_id,
      production_dim_catalog.catalog_name,
      production_dim_catalog.catalog_number,
      production_dim_catalog.count_distinct_catalogs,
      production_dim_catalog.subaccount_id,
      production_dim_catalog.count_distinct_subaccounts,
      production_dim_catalog.max_date_created,
      production_dim_catalog.max_last_updated,
      production_dim_catalog.min_date_created,
      production_dim_catalog.min_last_updated
    ]
  }

  set: production_dim_catalog.main_fields {
    fields: [
      #     - production_dim_catalog.old_catalog_id
      production_dim_catalog.catalog_name, production_dim_catalog.catalog_number]
  }
}