Tuning the Snowflake Data Cloud

Andrew Carruthers is the Director for Snowflake Distribution at the London Stock Exchange Group (LSEG). Andrew’s new role is to deliver several Snowflake accounts supporting Refinitiv “final mile” data product content delivery via Snowflake Marketplace, Private Listings and Data Shares. Previously responsible for the Snowflake Corporate Data Cloud, Andrew was responsible for both ingestion data lake and consumption analytics hub, the Corporate Data Cloud services a growing customer base of over 7,000 end users. He also leads both the Centre for Enablement developing tooling, best practice and training, also the Snowflake Landing Zone provisioning Snowflake Accounts conforming to both internal standards and best practice. Andrew has almost 30 years hands-on Relational Database design, development and implementation experience starting out with Oracle in 1993. Until joining LSEG, Andrew operated as an independent IT consultant, his experience has been gained through predominantly working at major European financial institutions. Andrew is considered a visionary and thought leader within his domain with tight focus on delivery. Successfully bridging the gap between Snowflake technological capability and business usage of technology, Andrew often develops proof of concepts to showcase benefits leading to successful business outcomes. Since 2020 Andrew has immersed himself in Snowflake and is considered a Subject Matter Expert, he is CorePro certified, contributes to online forums and speaking at Snowflake events on behalf of LSEG. In recognition of his contribution to implementing Snowflake at LSEG, Andrew received the Snowflake Data Driver award, this category recognizes a technology trailblazer who has pioneered the Data Cloud into their organization. Andrew has two daughters, 20 and 22, both elite figure skaters. He has a passion for Jaguar cars having both designed and implemented modifications, and has published articles for both the Jaguar Enthusiast Magazine and Jaguar Drivers Club. Andrew enjoys 3D printing and has a mechanical engineering workshop with lathe, milling machine, TIG welder to name but a few tools, and enjoys developing his workshop skills.

1. Tuning the Snowflake Data Cloud.- 2. The Query Optimizer.- 3. The Query Profiler.- 4. Micro-Partitions.- 5. Cluster Keys.- 6. Warehouses.- 7. Search Optimization Service.- 8. Parallelization.- 9. Client Expectations.- 10. Optimizing Performance.- Appendix.