Skip to content
  • AT SNOWFLAKE
  • Industry solutions
  • Partner & Customer Value
  • Product & Technology
  • Strategy & Insights
Languages
  • Deutsch
  • English
  • 한국어
  • Español
  • Français
  • Italiano
  • 日本語
  • Português
  • Deutsch
  • English
  • 한국어
  • Español
  • Français
  • Italiano
  • 日本語
  • Português
  • AT SNOWFLAKE
  • Industry solutions
  • Partner & Customer Value
  • Product & Technology
  • Strategy & Insights
  • Deutsch
  • English
  • 한국어
  • Español
  • Français
  • Italiano
  • 日本語
  • Português
  • Aperçu
    • Pourquoi Snowflake
    • Témoignages de clients
    • Partenaires
    • Services
  • Aperçu
    • Le Data Cloud
    • Aperçu de la plateforme
    • Snowflake Data Marketplace
    • Powered by Snowflake
    • Démo en direct
  • Workloads
    • Collaboration
    • Data Science & ML
    • Cybersécurité
    • Applications
    • Data Warehouse
    • Data Lake
    • Data Engineering
    • Unistore
  • Tarification
    • Options de tarification
    • Calculateur de valeur
  • Pour les industries
    • Publicités, médias et divertissement
    • Services financiers
    • Secteur de la santé et sciences de la vie
    • Marketing
    • Secteur public
    • Secteur du retail et des biens de consommation
    • Technologie
  • Apprendre
    • Bibliothèque de ressources
    • Documentation
    • Webinars
    • Formation
  • Connecter
    • Blog
    • Communauté Snowflake
    • Événements
    • Webinar
    • Podcast
  • Aperçu
    • À propos de Snowflake
    • Les investisseurs
    • Direction et Administration
    • Carrière
Author
Bharath Sitaraman Bharath Sitaraman
Ismail Oukid Ismail Oukid
Share
Subscribe
Mar 08, 2021

Now Generally Available, Snowflake’s Search Optimization Service Accelerates Queries Dramatically

  • Produit et technologie
    • AI et ML
Now Generally Available, Snowflake’s Search Optimization Service Accelerates Queries Dramatically

Snowflake customers want to discover insights from their data faster than ever, which is challenging because data volumes are growing at a breakneck pace. Effective searches are critical to customer satisfaction. Today, we’re excited to announce the general availability of search optimization, which significantly improves the performance of selective queries on large tables. 

The search optimization service is an example of Snowflake’s focus on accelerating performance for a variety of workloads and enabling data engineers, data scientists, and BI analysts to work effectively with massive data sets within Snowflake.

Using The Search Optimization Service

The search optimization service enables users to analyze billions of rows of data, giving them faster insight on specific narrow questions. For example, data scientists can run several ad-hoc queries to make sense of a given data set, and data analysts can find useful insights that were previously hidden.

During the preview period, many Snowflake customers experienced much faster searches to find specific and small answers in massive data sets like transactions or activities for one user or how a single coupon code was used on a particular item. In some, specific cases, search times decreased from several minutes to a few seconds, as shown in the following table:

Customer Use CaseQuery without Search Optimization Service


Query with Search Optimization Service


Improvement




Fortune 500 Financial Service Company


A lookup for financial transactions and account lookups for a given user

5:16 minutes 2.2 seconds 143x


HYAS



A lookup of all the logs and data associated with one of many attributes

37:14 minutes 18.54 seconds 120x


Fortune 500 Media Company


Lookups of specific user accounts and activity

1:22 minutes 16 seconds 5x
Fortune 500 Retail Company
Looking for specific coupon usage on an item
8.91 seconds 2.3 seconds 4x

You can activate the search optimization service on selected tables and let Snowflake do the maintenance in the background. Snowflake automatically tracks additions, updates, or deletions while preserving the optimal access structure underneath. 

In addition to speeding up your workloads, the search optimization service can cut costs by enabling you to use smaller virtual warehouses on existing workloads. 

Randy Fox, Senior Software Engineer at HYAS, said, “Without search optimization, we would not be able to easily allow our customers to quickly interrogate hundreds of billions of rows of data without a big hardware footprint. Snowflake enabled us to serve our customers quickly and reliably with an end-to-end solution not mired in barely manageable archaic database paradigms. Layering search optimization on top has given us the speed and flexibility that we required, while keeping a simple data model.” 

The feedback we received during the search optimization service preview highlights how important efficient data exploration is to all kinds of enterprises with critical data strategies and SLAs. Users described additional use cases involving more cost-effective security and log analytics. We will jointly explore these use cases further and provide updates in the coming months. 

To learn more, see the  detailed documentation and join us at our March 18 webinar. 


Innovating as One Global Engineering Team 
The general availability of the search optimization service marks a key milestone for Snowflake’s growing engineering teams in Europe. The search optimization service is the result of the work developed in Snowflake’s Berlin Development Center, in close collaboration with Snowflake’s engineering team in San Mateo, California. At the beginning of March 2021, the Berlin office consists of more than 30 engineers with diverse backgrounds, working together to enhance the Snowflake stack. If you’d like to learn more and help our European team build the future of Snowflake, see our careers page and select the Berlin location.

Share

The Right Tools to Analyze Data Require the Right Data Warehouse

Learn why it takes more than the right tools to analyze data. You also need a scalable, flexible cloud data warehouse.

Delve into the details
Lire la suite

Concepts of Data Warehousing

Learn why concepts of data warehousing have changed significantly over the past decade as businesses move from on-prem to cloud.

Find Out More
Lire la suite

Data Mining for Business Analytics

Data mining for business analytics allows companies to comb through large data sets to identify patterns and relationships that point to solutions.

Full Details
Lire la suite

AI Governance Best Practices

AI governance is critical to addressing the ethical, legal, and societal implications of AI systems. Here are five crucial best practices for AI governance.

More Details
Lire la suite
Snowflake Inc.
  • PLATEFORME
    • Cloud Data Platform
    • Architecture
    • Tarification
    • Data Marketplace
  • SOLUTIONS
    • Snowflake pour le secteur de la santé et les sciences de la vie
    • Snowflake pour les services financiers
    • Snowflake pour les analyses marketing
    • Snowflake pour le secteur du retail
    • Snowflake pour l’éducation
  • RESSOURCES
    • Bibliothèque de ressources
    • Webinaires
    • Communauté
    • Légal
  • EXPLORER
    • Actualités
    • Blog
    • Tendances
  • À PROPOS
    • À propos de Snowflake
    • Direction et administration
    • Partenaires
    • Carrières
    • Contact

Sign up for Snowflake Communications

Thanks for signing up!

  • Privacy Notice
  • Site Terms
  • Cookie Settings

© 2023 Snowflake Inc. All Rights Reserved