The Tredence team took a piece meal approach to deconstruct the problem:

  • The team evaluated multiple Cloud Data warehouses on features such as cost, scalability, workload management
  • The technology choice narrowed down to Snowflake after a month-long POT where AAS was replaced by Snowflake and performance was benchmarked by varying workloads and testing

The findings were presented to the client technology council and was deliberated at length prior to the final decision


  • Snowflake was onboarded as the central CDW. Features of Snowflake like complete separation of compute from storage and auto-scalability based on varying workloads were instrumental in cost reduction
  • Additional advanced features such as multi-clustered data-warehouses enabled horizontal scalability and improved performance


  • Overall reduction in operational cost by ~35% for the same workload
  • A slight improvement in performance due to compute horsepower and compression techniques available on snowflake
  • Tredence developed its own proprietary snowflake compute selection accelerator during the process