In March, Snowflake released a number of exciting new capabilities including Python Worksheets, the Snowflake Connector for ServiceNow, and expanded support for geospatial data. Read on to learn more about the full set of features that were just announced.
Snowflake Connectors
Snowflake Connector for ServiceNow – public preview
Ingest data from ServiceNow into Snowflake automatically. The connector supports both the initial load of historical data as well as incremental updates. The latest data is regularly pulled from ServiceNow, and you control how frequently it is refreshed. See the Snowflake documentation for more info and get started today using the Quickstart Guide.
Data Pipelines
Snowpipe Streaming – public preview
While data generated in real time is valuable, it is more valuable when paired with historical data that helps provide context. With Snowpipe Streaming as a new framework for low-latency ingestions, developers can augment existing data-ingestion scenarios and stream Kafka topics and rowsets directly to Snowflake tables. Read our blog to learn more.
Streams on views – general availability (GA)
Streams on views extends table streams to track change data capture (CDC) records for views, including secure views. Learn more.
Python Worksheets
Try Snowpark for Python within Snowflake – public preview
Python developers have always had flexibility in terms of which IDE/notebook to use; just install the Snowpark client API and connect to a Snowflake account. But to make it even faster to get started you can now develop in Snowflake using Python worksheet’s type-sensitive autocomplete and inline documentation – no install required to use Python libraries. Write simple Snowpark programs and deploy them as procedures — great for data engineers building pipelines. Read more.
Geospatial Support
New geospatial functions for shape transformation and orientation – public preview
Snowflake continues to lead in the geospatial space with the release of several new geospatial functions. These new functions—three for the GEOMETRY data type and one for the GEOGRAPHY data type—specifically streamline the process of performing orientation transformations. Learn more about what these new functions are and how they work in our recent blog post.
Snowflake increases support for handling invalid geospatial shapes – public preview
Get more control over the validation and repair process when handling invalid shapes. With this release, Snowflake allows conversion functions to create GEOGRAPHY and GEOMETRY objects for invalid shapes. This release also makes it easy to determine if the shape for a GEOGRAPHY or GEOMETRY object is invalid. Learn more about how to get started in the Snowflake documentation.
Snowsight
New individual task observability visuals in Snowsight – general availability (GA)
Snowsight, the Snowflake interface, continues its march to help you get from data to decision faster by creating an interface that makes it easy to get common jobs done. With the GA release of individual task observability, tasks are now visible in a graph view to highlight dependencies and order of execution. With observability for individual task runs, you can perform monitoring tasks such as identifying long-running tasks, consistently skipped tasks, and databases with a high volume of tasks. Learn more about how to get started in the Snowflake documentation.
Snowgrid: Cross-Cloud Data Governance
Allow masked columns as inputs to row access policies and conditional masking policies – general availability (GA)
Advanced use cases require a masked column in a mapping table to be used as input to a row access policy for row-level authorization. With this feature release, the signature of a row access policy and a conditional masking policy can now specify a column protected by a masking policy. Learn more.
Snowgrid: Cross-Cloud Business Continuity
Account replication now supports notification integration – public preview
You can now replicate email and push notification integrations easily with Account Replication. Email notifications play a critical role in observability and monitoring of various workloads running in your Snowflake account, and now you can replicate these integrations to your secondary account. When an outage occurs and you decide to failover, these notification integrations are readily available, preventing the need for any manual workarounds and reducing recovery time objective (RTO).
Search Optimization Service
Column selection for search optimization; faster searches in VARIANT, ARRAY, OBJECT, and GEOGRAPHY data types; and faster substring searches in string columns – general availability (GA)
Snowflake customers now have the ability to select specific columns for search optimization to bring down costs and increase efficiency. The new features also enable customers to easily search in logs and semi-structured data stored in VARIANT, ARRAY, and OBJECT columns, which prove to be especially useful for cybersecurity vendors who perform needle-in-a-haystack-type queries. And lastly, customers can speed up GEOGRAPHY search predicates by utilizing the additional filters on these columns. Learn how customers are using Search Optimization Service today.
Snowflake Marketplace
Snowflake customers can tap into Snowflake Marketplace for access to more than 1,800 live data sets, packages of data sets, or data services (applications are currently in private preview) from over 390 third-party data providers and data service providers (as of Jan 31, 2023), as well as market their own products across the Snowflake Data Cloud. Visit Snowflake Marketplace.
Commerce
Merchant AI provides up-to-date Amazon Vendor Central, Seller Central, advertising, and marketplace data in the Data Cloud. Reports can be customized to meet business needs and are fast, reliable, and accurate.
Daltix provides quality retail data you can trust. The company’s data is highly accurate, which makes deriving insights easy and decision-making truly fact based. Data access is daily and seamless, another significant benefit in the industry’s competitive landscape. Daltix’s data collection spans over at least 100 retailers across Europe, and the experienced data science team manages the processing of more than 100M data points per day.
Since 1995, ParcelQuest has been proud to partner directly with California County Assessors and other local, state, and federal agencies to collect, standardize, and publish proprietary, best-in-class, continuously updated property data, ownership information, parcel maps, recorded documents, property tax data, and zoning information statewide.
Blueshift is an intelligent customer engagement platform that helps brands deliver relevant, connected experiences across every customer interaction. Blueshift’s AI platform provides the only all-in-one solution for data, decisioning, and delivery. With unified customer data, AI-powered decisioning, and cross-channel delivery in an easy-to-use platform, Blueshift gives brands all the tools they need to seamlessly deliver 1:1 experiences in real time across the entire customer journey. Blueshift has been recognized in the Deloitte Technology Fast 500 lists in 2020, 2021, and 2022 as one of the fastest-growing technology companies in North America.
Intellizence, Inc., is an award-winning AI startup focused on company and market intelligence, enabling customers to identify emerging opportunities and risks proactively with timely and actionable intelligence.
Demographics
Zoopla is a leading online U.K. property portal that offers a comprehensive platform to help people find their dream homes. Zoopla’s website features millions of properties for sale and for rent from all over the U.K., giving users a vast range of options to choose from. In addition, the company offers a range of tools to help users with their property search, such as property valuations, mortgage calculators, and local area guides.
Energy
Enverus is the most trusted, energy-dedicated SaaS platform, offering real-time access to analytics, insights, and benchmark cost and revenue data sourced from its partnerships to 98% of U.S. energy producers, and more than 35,000 suppliers. With intelligent connections, the Enverus platform drives more efficient production and distribution, capital allocation, renewable energy development, investment, and sourcing, and the company’s experienced industry experts support its customers through thought leadership, consulting, and technology innovations. Enverus provides intelligence across the energy ecosystem: renewables, oil and gas, financial institutions, and power and utilities, with more than 6,000 customers in 50 countries.
Environment
Ambee is an environmental and climate intelligence company that provides high-resolution, global, and hyperlocal environmental data. Ambee’s environmental data combines data from on-ground sensors, satellites, and multiple open sources. By leveraging AI and machine learning (ML) technologies with proprietary algorithms, Ambee delivers the most accurate results. Businesses and administrators across the globe trust Ambee’s AI-powered, scientifically validated data for their businesses. Ambee aims to democratize access to environmental and climate data to create a better and healthier living experience.
Financial
Cardinal uses proprietary ML models to generate highly accurate end-of-day credit risk scores. The company’s data empowers users to quickly identify the underlying credit risk of companies in an industry or region.
CoreLogic Australia helps people build better lives by providing rich, up-to-the-minute property insights that inform the very best property decisions. With an extensive breadth and depth of knowledge gathered over the past 30 years, the company provides services across a wide range of industries, including banking and finance, real estate, government, insurance, and construction. CoreLogic Australia’s diverse, innovative solutions help its clients identify and manage growth opportunities, improve performance, and mitigate risk.
Founded in 1998 and headquartered in Switzerland, RepRisk is a pioneer in ESG data science that leverages AI and ML technologies combined with human intelligence to systematically analyze 100,000 public sources in 23 languages and assess material ESG incidents. RepRisk has the world’s largest ESG database with daily updates on over 220,000 public and private companies, and over 60,000 infrastructure projects, sectors, and countries.
Geospatial
Data provider dataplor delivers the most accurate global point of interest (POI) data, with local experts providing final confirmation.
Health & Life Sciences
Medical Data Vision Co., Ltd. (メディカル・データ・ビジョン株式会社)
Medical Data Vision Co., Ltd., was founded in 2003 and owns one of the largest medical data sets in Japan. It provides management support to hospitals and data utilization services to pharmaceutical companies and research institutions.
Healthcare payers looking to beat the challenge of accessing usable data to improve their operations and member experience look to Abacus Insights’ Buy+Build approach. Abacus Insights is the U.S. leader in data usability for payers, supporting their tech teams, data teams, and business units. Payers work with the company because it offers them usable data at an unprecedented 4-6 month time-to-value and 60% lower TCO.
Legal
LexisNexis Intellectual Property Solutions empowers innovators to shape the future. The company combines subject matter IP know-how with expert knowledge in data science and cutting-edge software engineering. Its data and software solutions support customers in driving efficiencies, predicting developments, and gaining insights for strategic decision-making. Built by experts and backed by science, LexisNexus solutions bring clarity to innovation.
Marketing
Map Marketing, Co., Ltd. is a marketing GIS vendor. It also provides marketing data such as census data and estimated data such as income data.
Statara uses industry-leading data sourcing, modeling, enhancement, and auditing to produce Statara Identity Insights: a data set of ~260 million individuals (U.S.). Statara Identity Insights features over 800 attributes depicting contact information, demographics, consumer interests, buying behaviors, model scores, voting information, donation history, and more.
Media
Attain is a data company powered by a financial services app, retail loyalty account linking, SKU-level APIs, and the industry’s most holistic consumer panel. Attain is uniquely positioned to provide deeper insights into how, what, when, and where consumers spend their money.
—–
Forward-Looking Statements
This post contains express and implied forward-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 forward-looking statements as predictions of future events.
© 2023 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).