On the compilation side, common table expressions (CTEs) are now faster with up to 30% reduced compilation. This update is currently being rolled out across regions. Business applications that rely on searching through large text documents for a word or a phrase will run faster without changing application code. For example, one of our government customers was able to simplify their migration from Teradata to Snowflake without the need to change their application stack or rewrite queries.Īlso, we improved out-of-the-box substring searches, now running up to twice as fast. Snowflake will now automatically detect and eliminate unnecessary joins from your query rather than relying on the application layer. On the execution side, we are happy to announce that Join Eliminations will be in public preview soon.These will save substantial query execution time. No user intervention or choosing a particular configuration is required for this latest performance enhancement. We’ve optimized Snowflake to take advantage of new hardware improvements offered by AWS, and we are seeing 10% faster compute on average in the regions already rolled out. Transparent engine updatesįor those of you running on AWS, you will get faster performance for all of your workloads. At Summit, we announced a number of new engine capabilities we are going to summarize in this blog post.

Nearly every improvement we make applies across the board rather than to a single use case or workload. You also get more platform innovation more frequently.

You won’t need to figure out different pricing implications when deploying data engineering, analytics, or data science workloads. There’s no need to manage multiple engines, services, complex system architectures, or data flows.

Ultimately, the result is the elimination of complexity. The single engine approach translates into a single experience-from one consistent pricing model to an integrated approach combining performance, security, governance, and the foundation to seamlessly enable cross-region or cross-cloud scenarios. From day 1, we have been focusing on consistently evolving and improving this engine to allow existing workloads to run more efficiently and enable new workloads to run on Snowflake. Snowflake’s Data Cloud is powered by a single engine.

Whats another word for running