Support for unstructured data is now in public preview! That’s one of many of the exciting announcements made in September, in addition to a new serverless tasks feature, expanded public cloud regions, enhanced business continuity capabilities, and several new providers on Snowflake Data Marketplace.
Support for Unstructured Data
Snowflake support for unstructured data, now in public preview, makes it possible for organizations to manage and analyze all their data–structured, semi-structured, and unstructured—across clouds in one seamless experience. Support includes built-in capabilities for storing, accessing, processing, managing, governing, and sharing unstructured data including but not limited to images, audio files, and videos. Learn more.
Taking Serverless to Tasks
Snowflake tasks allow users to schedule the execution of a SQL statement. With serverless tasks, now in public preview, Snowflake takes care of the heavy lifting to manage pipeline tasks for customers. With this new capability, Snowflake leverages serverless computing and machine learning capabilities to automatically manage and optimize warehouse size and idle policy based on the customer’s pipeline use case. Learn more.
New Region Alert
Snowflake is expanding its availability to even more regions around the world. On Amazon Web Services (AWS), Snowflake now supports the US Gov West 1 region and Asia Pacific (Seoul). On Microsoft Azure, Snowflake supports Northern Europe (Ireland). With these additions, Snowflake supports 24 global regions across three cloud platforms (AWS, Google Cloud Platform, and Azure), as well as three regions across AWS and Azure for compliance with U.S. government regulations such as FIPS 140-2 and FedRAMP. View the full list of supported regions here.
Recover in Seconds with Snowflake Client Redirect
Now available in public preview, Client Redirect enables seamless redirection of client connections across Snowflake accounts in different regions and clouds for business continuity and minimal disruption to end users. Together with Snowflake Database Replication and Failover/Failback, users are able to recover data and client connections in seconds, at virtually any scale. For even higher resiliency, customers can use these features to perform failover across public clouds. Learn more.
Load SQL Scripts in Snowsight
With our new web interface, now available in public preview, users can load SQL scripts into Snowsight to create new worksheets or append SQL code to existing worksheets. This makes it easier than ever to get started using worksheets in Snowsight. Learn more.
Simplified Role Management with Secondary Roles
Secondary roles are now generally available, allowing all roles granted to a user to be activated in the user session. This means users can perform SQL actions on objects in a session using the aggregate privileges granted to the primary and secondary roles, instead of having to change roles depending on the action and privileges required. This simplifies role management, especially for organizations whose security model includes a large number of roles. Additionally, this is useful for operations such as cross-database joins, where different roles may have permissions to access objects in each database. To hear how Pinterest is using secondary roles, watch “What’s New: Security in Snowflake.”
SNOWFLAKE DATA MARKETPLACE
Snowflake customers can tap into Snowflake Data Marketplace to discover and access helpful third-party data and services from more than 200 providers (as of October 1, 2021) as well as market their own products across the Snowflake Data Cloud. Visit Snowflake Data Marketplace.
RECENTLY ADDED SNOWFLAKE DATA MARKETPLACE PROVIDERS
Algolytics’ Building Spatial Database is a standardized collection of data on all buildings/addresses in Poland. It contains basic address information as well as the detailed location of each building expressed in geographic coordinates. Learn more.
By linking individuals’ consumer profiles at home to their professional profiles at work, AnalyticsIQ strives to help companies know their customers better. AnalyticsIQ sources data from more than 100 sources and more than 117 million households and recently has added several data sets, including consumer finance data, automotive data, health data, and media data. Learn more.
Bitvore’s Cellenus for Corporate, Market, and Industry data set provides third-party risk intelligence data on more than 400,000 global public and private companies, markets, and industries from a diverse set of unstructured data that includes more than 60,000 sources, both public and licensed premium content. Learn more.
CACI’s Acorn data set is a geodemographic segmentation of the U.K.’s population. It segments households, postal codes, and neighborhoods into six categories, 18 groups, and 62 types, providing a detailed understanding of the consumer characteristics of people and places across the U.K. Learn more.
DataHawk is an ecommerce analytics and optimization platform for Amazon and Walmart that helps data-driven brands measure performance and generate insights to increase sales and margins. Learn more.
GWI provides target audience insights to the global marketing industry. Its GWI Core Taxonomy data set shares the survey questions GWI asks more than 18 million consumers across more than 40 countries to uncover insights such as consumer attitudes, perceptions, online habits, media use, and purchase drivers. Learn more.
Neutronian Quality Index (NQI) Scoring provides a standardized framework for evaluating data quality and compliance. This framework helps marketers mitigate risk, reduce compliance costs, and improve campaign performance by enabling analytics and decision-making based on data quality. Learn more.
Nexiga’s Pedestrian Frequency Atlas (PFA) provides key figures on pedestrian frequency—classified on a frequency scale of 0 to 10—for all European street segments and allows direct comparison of micro-locations, hot spots, and location characteristics. The PFA is calculated based on the locations of frequency providers such as retail shops, shopping malls, and train stations as well as other points of interest. Learn more.
Passerelle Data Rocket provides a framework for ingesting and integrating third-party data sets into a financial institution’s historical and real-time data to unlock insights into target demographics, customer spending, and opportunities for cross-selling and upselling to existing clients. Learn more.
PRECISIONxtract provides biopharmaceutical companies with innovative data management solutions, predictive multi-stakeholder analytics, and dynamic customer engagement solutions. Its Proprietary Payer Data Master data set provides turnkey data-agnostic payer data master with data enrichment for actionable insights. Learn more.
Rystad Energy’s UCube data set is used to study all parts of the global energy exploration and production (E&P) activity, history, and future, covering the years from 1900 to 2100. The global upstream database includes production and economics (costs, revenues, and valuation) covering the portfolios of more than 3,500 companies. Learn more.
Specialists Marketing Services
Specialists Marketing Services provides online and offline consumer and new-mover segments for mail and digital audience targeting. Its Consumer Demographics Master data set covers more than 240 million adults in the U.S., each with hundreds of demographic data points including age, income, and education status. Learn more.
Transform SR Brands
Transform SR Brands’ Sears Kmart Appliances—Sales and Home Services data set provides purchase-history data sourced from Sears, Sears Hometown, Kmart stores, and Sears.com since 2012. It also includes Sears Home Services data for appliances covered by a service contract or service order. Organizations can use this data to gain performance insights on major appliances, including breakdown rates by geography, brand, and season. Learn more.
Veritas Data Research
Veritas Data Research’s Fact of Death—U.S. Mortality data set provides comprehensive patient-level mortality information to help health providers and other stakeholders leverage mortality information as a foundational element on analytics and patient-care platforms. This data covers more than 90% of deaths in the U.S., with nearly 90% reported within a month of death. Learn more.