view: dt_release_delivered_to_facebook {
  sql_table_name: INTELLIGENCE.DBT_PROD.DT_RELEASE_DELIVERED_TO_FACEBOOK ;;
    # derived_table: {
    #   sql: SELECT distinct upc as upc
    #           FROM orchard_app_reporting_v2.art_relations_prod_art_relations.delivery_history
    #           where customer_master_master_id = 1173
    #           ;;
    # }

    #   - filter: filter_customer_master_master_id
    #     type: number

    dimension: upc {
      hidden: yes
      label: "upc"
      type: string
      sql: ${TABLE}.upc ;;
    }

    dimension: deliverable {
      label: "Delivered to Facebook?"
      hidden: yes
      type: string
      sql: case when ${TABLE}.upc is null then 'No' else 'Yes' end ;;
    }
  }