Snowflake Inc.

Andrew Xue

Jiaqi Yan

Nicola Dan Onose

Boyung Lee

Xuelai Cui

Prashant Gaharwar

Vineet Garg

Kevin Ye Jie Li

The subject technology receives a query, the query including a statement for performing the query. The subject technology performs a first lookup operation on a multi-phase cache based on the query. The subject technology performs, in response to a first cache miss of the multi-phase cache, parsing of the statement from the query. The subject technology performs, based on the parsing, a compilation process on the query to generate a compiled query plan, the compilation process determining an optimization and a generalization for the query. The subject technology determines that the compiled query plan is cacheable. The subject technology registers, in response to the compiled query plan being cacheable, a dummy entry in the multi-phase cache.

Multi-phase query plan caching

Growing community of inventors

San Mateo, CA, United States of America

Andrew Xue