This ESG Lab Review documents the recent analysis of Cloudera Navigator Optimizer with a goal of validating its ability to enable organizations to identify and offload SQL workloads from legacy data marts and costly enterprise data warehouses (EDWs) to a modern analytic database built on Hadoop, while optimizing existing workloads already on Hadoop.