view: dim_catalog {
  sql_table_name: facts.prod.dim_catalog ;;


  measure: number_of_rows {
    label: "Number of Rows"
    description: "row count for group based on table production.dim_catalog"
    type: count
  }

  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
  }

  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_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: "#,###"
  }

  dimension: subaccount_id {
    view_label: "Subaccount"
    label: "ID"
    description: ""
    sql: ${TABLE}.subaccountid ;;
    type: number
    value_format: "####"
  }


}