Sumo
map_product_slug (UDF)
Maps SUMO product slug paths to canonical product names.
Legacy SUMO-specific mapper. Current production SUMO queries (GA4, Zendesk, Kitsune) use mozfun.customer_experience.normalize_product instead. No longer referenced by any production query; CASE-statement duplication is now avoided via mozfun.customer_experience.normalize_product.
Example: SELECT sumo.map_product_slug('/firefox/') -- Returns: 'firefox' SELECT sumo.map_product_slug('/mozilla-vpn/') -- Returns: 'mozilla-vpn'
Parameters
INPUTS
product_slug STRING