• APPROACH

    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

    KEY BENEFITS

    • 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

    RESULTS

    • 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

     

    快猫 亿万狼友的选择