This Apress imprint is published by the registered company APress Media, LLC, part of Springer Nature.
The registered company address is: 1 New York Plaza, New York, NY 10004, U.S.A.
To Esther, Verity, and Diane
Thanks are not enough to the Apress team for the opportunity to deliver this book—specifically, to Jonathan Gennick. I hope my 0.01% contribution remains worth your investment. This book is all the richer for your patient guidance, help, and assistance. Mike Gangler, you have enriched this work more than you know while teaching me American grammar and spelling. As George Bernard Shaw said: “Two people separated by a common language.” Jill Balzano, thank you for your project management. Who knew writing a book would be so easy? And those unknown to me—editors, reviewers, and production staff, please take a bow. You are the unsung heroes who make things happen.
To my friends at Snowflake who patiently showed me the “art of the possible,” who first encouraged, advised, and guided, then became friends, mentors, and partners. Jonathan Nicholson, Andy McCann, Will Riley, Cillian Bane, and James Hunt—quite a journey we have been on, and in no small part, this book is possible only because of your steadfast support. I owe you all a beer or three!
To my colleagues at London Stock Exchange Group who had the vision and foresight to investigate Snowflake, Mike Newton, this is for you. Also, step forward my inspiring colleagues—Nitin Rane, Srinivas Venkata, Matt Willis, Dhiraj Saxena, Gowthami Bandla, Arabella Peake, and Sahir Ahmed. You all played a bigger part in this book than you know, and I will be forever grateful to you all.
To my daughters, Esther and Verity, who knew Dad would write something like this! And finally, to Diane, you were there every day throughout the six months this book took to write. You have the patience of a saint and are more lovely than I can say.
Andrew has almost 30 years of hands-on relational database design, development, and implementation experience, starting with Oracle in 1993. Before joining the London Stock Exchange Group, Andrew operated as an independent IT consultant. His experience has been gained through predominantly working at major European financial institutions. Andrew is considered a thought leader within his domain with a tight focus on delivery. Successfully bridging the gap between Snowflake’s 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. He is considered a subject matter expert, recently becoming CorePro certified, contributing to online forums, and speaking at Snowflake events on behalf of the London Stock Exchange Group. In recognition of his contribution to implementing Snowflake at the London Stock Exchange Group, Andrew recently received the Snowflake Data Hero of the Year award. This category recognizes a technology trailblazer who has pioneered the data cloud in their organization.
Andrew has two daughters, 19 and 21, both elite figure skaters. He has a passion for Jaguar cars, having both designed and implemented modifications, and has published articles for Jaguar Enthusiast Magazine and The Jaguar Drivers’ Club. Andrew enjoys 3D printing and has a mechanical engineering workshop with a lathe, milling machine, and TIG welder, to name a few tools, and he enjoys developing his workshop skills.
18.216.117.191