New Snowflake Features – August 2022

In August, Snowflake released new capabilities for improved performance and account replication, as well as features that enhance warehousing and programmability of data. Read the details below to learn more about this month’s announced upgrades.

Performance Update

Query compilation time improves by 3.2% on average across all regions

Snowflake recently rolled out a performance enhancement that improved query compilation time by an average of 3.2% across all regions. 

Replication

Account Replication is now in preview

Account Replication is currently in public preview. This feature introduces two new Snowflake objects: replication group and failover group. A replication group allows customers to specify which account objects to replicate (in specific regions or cloud platforms) at customizable scheduled intervals. A failover group enables the replication and failover of the account objects in a group. The objects in a group are replicated with point-in-time consistency from a source account to one or more target accounts. Review our documentation for more information about Snowflake’s replication capabilities.

Support for Redirecting Client Connections—now in GA

Support for Redirecting Client Connections has been released for general availability. This feature enables seamless redirection of client connections across Snowflake accounts in different regions and clouds to enable greater business continuity. Client Redirect, together with Account Replication and Failover, enables recovery of an account and client connections. Get more details here.

Data Warehousing

Support for GEOMETRY data type—now in preview

Support for Snowflake’s new GEOMETRY data type is currently available in preview. The GEOMETRY data type represents features in a planar (Euclidean, Cartesian) coordinate system. This feature is available to all Snowflake accounts. .

Data Programmability

Snowpark Stored Procedures in general availability

We are pleased to announce general availability for Snowpark Stored Procedures written in Java and Scala on Amazon Web Services (AWS) and Microsoft Azure. Snowpark Stored Procedures for Java and Scala is also available for preview on Google Cloud Platform (GCP). Support for stored procedures makes Snowpark more useful for developers—and it’s easy to execute. In your stored procedure, you can use the Snowpark API for Java and/or Scala to host your data pipelines in Snowflake. For example, you can write stored procedures in cases where you need to execute your Snowpark code without running a client application (e.g., from a task). Learn more about  Snowpark capabilities or getting started with Snowpark.

Snowflake Marketplace

Snowflake customers can tap into Snowflake Marketplace for access to more than 1,300 live and ready-to-query data, data services, and applications from over 310 third-party data providers and data service providers (as of July 2022), as well as market their own products across the Snowflake Data Cloud. Visit Snowflake Marketplace.

Recently Added Snowflake Marketplace Providers

Local

Geoscape

A critical collaborator, delivering spatial data to enable economic, social, and environmental outcomes across the economy. Geoscape’s vision is achieved through a wide and sustained ecosystem of partnerships and collaboration. Geoscape Australia is the trading name of PSMA Australia Limited, a self-funded public company owned by Australia’s governments. Learn More

—–

​​Forward-Looking Statements

This post contains express and implied forwarding-looking statements, including statements regarding (i) Snowflake’s business strategy, (ii) Snowflake’s products, services, and technology offerings, including those that are under development or not generally available, (iii) market growth, trends, and competitive considerations, and (iv) the integration, interoperability, and availability of Snowflake’s products with and on third-party platforms. These forward-looking statements are subject to a number of risks, uncertainties and assumptions, including those described under the heading “Risk Factors” and elsewhere in the Quarterly Reports on Form 10-Q and Annual Reports of Form 10-K that Snowflake files with the Securities and Exchange Commission. In light of these risks, uncertainties, and assumptions, actual results could differ materially and adversely from those anticipated or implied in the forward-looking statements.  As a result, you should not rely on any forwarding-looking statements as predictions of future events. 

© 2022 Snowflake Inc.  All rights reserved.  Snowflake, the Snowflake logo, and all other Snowflake product, feature and service names mentioned herein are registered trademarks or trademarks of Snowflake Inc. in the United States and other countries.  All other brand names or logos mentioned or used herein are for identification purposes only and may be the trademarks of their respective holder(s).  Snowflake may not be associated with, or be sponsored or endorsed by, any such holder(s).

Source

Originally posted on September 19, 2022 @ 10:43 pm