{"id":1586,"date":"2018-11-15T10:59:45","date_gmt":"2018-11-15T15:59:45","guid":{"rendered":"https:\/\/solutionsreview.com\/data-management\/?p=1586"},"modified":"2018-11-15T11:11:13","modified_gmt":"2018-11-15T16:11:13","slug":"snowflake-beefs-up-its-cloud-data-warehouse-query-performance","status":"publish","type":"post","link":"https:\/\/solutionsreview.com\/data-management\/snowflake-beefs-up-its-cloud-data-warehouse-query-performance\/","title":{"rendered":"Snowflake Beefs Up its Cloud Data Warehouse Query Performance"},"content":{"rendered":"<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1587\" src=\"https:\/\/solutionsreview.com\/data-management\/files\/2018\/11\/oie_ExKgJ7vHHSwX.jpg\" alt=\"Snowflake Beefs Up its Cloud Data Warehouse Query Performance \" width=\"800\" height=\"400\" srcset=\"https:\/\/solutionsreview.com\/data-management\/files\/2018\/11\/oie_ExKgJ7vHHSwX.jpg 800w, https:\/\/solutionsreview.com\/data-management\/files\/2018\/11\/oie_ExKgJ7vHHSwX-300x150.jpg 300w, https:\/\/solutionsreview.com\/data-management\/files\/2018\/11\/oie_ExKgJ7vHHSwX-768x384.jpg 768w, https:\/\/solutionsreview.com\/data-management\/files\/2018\/11\/oie_ExKgJ7vHHSwX-600x300.jpg 600w, https:\/\/solutionsreview.com\/data-management\/files\/2018\/11\/oie_ExKgJ7vHHSwX-162x81.jpg 162w, https:\/\/solutionsreview.com\/data-management\/files\/2018\/11\/oie_ExKgJ7vHHSwX-360x180.jpg 360w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<p style=\"text-align: justify\">Snowflake Computing <a href=\"https:\/\/www.snowflake.com\/news\/snowflake-announces-automatic-clustering-and-materialized-views\/\" target=\"_blank\" rel=\"noopener\">has announced<\/a> the availability of new cloud data warehouse performance features to optimize query performance. When combined, automatic clustering and materialized views deliver increased speed for insight generation by all an organization&#8217;s Snowflake users.<\/p>\n<div class=\"widget\"><div class=\"aside-card\">\t\t\t<div class=\"textwidget\"><a class=\"speedbump\" href=\"https:\/\/solutionsreview.com\/data-management\/data-management-data-warehouse-buyers-guide\/\" title=\"Download link to Data Management Buyers Guide\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" class=\"alignleft size-full wp-image-1682\" src=\"https:\/\/solutionsreview.com\/data-management\/files\/2019\/01\/data-management-speedbump-cta.jpg\" alt=\"Download Link to Data Management Buyers Guide\" width=\"800\" height=\"225\" \/><\/a><\/div>\n\t\t<\/div><\/div>\n<p style=\"text-align: justify\"><a class=\"external\" href=\"https:\/\/www.snowflake.com\/\" target=\"_blank\" rel=\"noopener nofollow\">Snowflake<\/a>\u00a0has a unique data warehouse as a service offering, and its own SQL data architecture that claims to do more than the alternative. The company\u00a0has made a slew of improvements to its product portfolio recently, including Snowpipe, an automated data loading tool, a cloud data warehouse for the financial services, and a new Sharehouse add-on.<\/p>\n<p style=\"text-align: justify\">Automatic clustering optimizes the self-organization of data storage. It also merges and drops data to close gaps, which Snowflake does automatically and in the background. Non-blocking execution of ETL pipelines that contain DML statements ad incremental clustering to tables as new data arrives round out automatic clustering.<\/p>\n<p style=\"text-align: justify\">Materialized views\u00a0 offer performance improvement for queries that repeatedly use the same subquery results. Snowflake automatically maintains materialized views when new data arrives or existing data in the base table is modified. The tool will remain &#8220;always up-to-date&#8221; independent of modifications in the base table.<\/p>\n<p style=\"text-align: justify\">In a statement to the media, the company&#8217;s Vice President of Product Christian Kleinerman said: &#8220;Automatic clustering is the obvious next step for Snowflake, and similar to how we\u2019ve automated security, maintenance and instant elasticity into our data warehouse-as-a-service.\u00a0Materialized views in Snowflake take a fresh approach to an age old problem. We\u2019ve leveraged the decades of experience we have with large-scale database processing, combined with the benefits of the cloud.&#8221;<\/p>\n<p style=\"text-align: justify\">This announcement comes on the heels of the company&#8217;s <a href=\"https:\/\/solutionsreview.com\/data-management\/the-snowflake-cloud-data-warehouse-is-now-available-on-microsoft-azure\/\" target=\"_blank\" rel=\"noopener\">September news<\/a> that its cloud data warehouse would be available on Microsoft Azure.\u00a0Snowflake will utilize the Azure infrastructure for data storage and query processing while also integrating with services such as Azure Data Lake Store and Power BI.<\/p>\n<div class=\"hr hr\"><\/div>\n<br \/>Widget not in any sidebars<br \/>\n","protected":false},"excerpt":{"rendered":"<p>Snowflake Computing has announced the availability of new cloud data warehouse performance features to optimize query performance. When combined, automatic clustering and materialized views deliver increased speed for insight generation by all an organization&#8217;s Snowflake users. Snowflake\u00a0has a unique data warehouse as a service offering, and its own SQL data architecture that claims to do [&hellip;]<\/p>\n","protected":false},"author":23,"featured_media":1587,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[1],"tags":[497,499,498,59,181],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Snowflake Beefs Up its Cloud Data Warehouse Query Performance<\/title>\n<meta name=\"description\" content=\"Snowflake Computing has announced the availability of new cloud data warehouse performance features to optimize query performance.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/solutionsreview.com\/data-management\/snowflake-beefs-up-its-cloud-data-warehouse-query-performance\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Snowflake Beefs Up its Cloud Data Warehouse Query Performance\" \/>\n<meta property=\"og:description\" content=\"Snowflake Computing has announced the availability of new cloud data warehouse performance features to optimize query performance.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/solutionsreview.com\/data-management\/snowflake-beefs-up-its-cloud-data-warehouse-query-performance\/\" \/>\n<meta property=\"og:site_name\" content=\"Best Data Management Software, Vendors and Data Science Platforms\" \/>\n<meta property=\"article:published_time\" content=\"2018-11-15T15:59:45+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-11-15T16:11:13+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/solutionsreview.com\/data-management\/files\/2018\/11\/oie_ExKgJ7vHHSwX.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"800\" \/>\n\t<meta property=\"og:image:height\" content=\"400\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Tim King\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Tim King\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/solutionsreview.com\/data-management\/snowflake-beefs-up-its-cloud-data-warehouse-query-performance\/\",\"url\":\"https:\/\/solutionsreview.com\/data-management\/snowflake-beefs-up-its-cloud-data-warehouse-query-performance\/\",\"name\":\"Snowflake Beefs Up its Cloud Data Warehouse Query Performance\",\"isPartOf\":{\"@id\":\"https:\/\/solutionsreview.com\/data-management\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/solutionsreview.com\/data-management\/snowflake-beefs-up-its-cloud-data-warehouse-query-performance\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/solutionsreview.com\/data-management\/snowflake-beefs-up-its-cloud-data-warehouse-query-performance\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/solutionsreview.com\/data-management\/files\/2018\/11\/oie_ExKgJ7vHHSwX.jpg\",\"datePublished\":\"2018-11-15T15:59:45+00:00\",\"dateModified\":\"2018-11-15T16:11:13+00:00\",\"author\":{\"@id\":\"https:\/\/solutionsreview.com\/data-management\/#\/schema\/person\/154e152a275103e373e24ada7f2feb5c\"},\"description\":\"Snowflake Computing has announced the availability of new cloud data warehouse performance features to optimize query performance.\",\"breadcrumb\":{\"@id\":\"https:\/\/solutionsreview.com\/data-management\/snowflake-beefs-up-its-cloud-data-warehouse-query-performance\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/solutionsreview.com\/data-management\/snowflake-beefs-up-its-cloud-data-warehouse-query-performance\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/solutionsreview.com\/data-management\/snowflake-beefs-up-its-cloud-data-warehouse-query-performance\/#primaryimage\",\"url\":\"https:\/\/solutionsreview.com\/data-management\/files\/2018\/11\/oie_ExKgJ7vHHSwX.jpg\",\"contentUrl\":\"https:\/\/solutionsreview.com\/data-management\/files\/2018\/11\/oie_ExKgJ7vHHSwX.jpg\",\"width\":800,\"height\":400,\"caption\":\"Snowflake Beefs Up its Cloud Data Warehouse Query Performance\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/solutionsreview.com\/data-management\/snowflake-beefs-up-its-cloud-data-warehouse-query-performance\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/solutionsreview.com\/data-management\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Snowflake Beefs Up its Cloud Data Warehouse Query Performance\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/solutionsreview.com\/data-management\/#website\",\"url\":\"https:\/\/solutionsreview.com\/data-management\/\",\"name\":\"Best Data Management Software, Vendors and Data Science Platforms\",\"description\":\"Enterprise Information Management\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/solutionsreview.com\/data-management\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/solutionsreview.com\/data-management\/#\/schema\/person\/154e152a275103e373e24ada7f2feb5c\",\"name\":\"Tim King\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/solutionsreview.com\/data-management\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/solutionsreview.com\/data-management\/files\/2023\/12\/tk.jpg\",\"contentUrl\":\"https:\/\/solutionsreview.com\/data-management\/files\/2023\/12\/tk.jpg\",\"caption\":\"Tim King\"},\"description\":\"Tim is Solutions Review's Executive Editor covering the human impact of AI on the future of work and learning. He is also the Media Strategist behind Insight Jam (1M+ on YouTube) events and programming. A 2017 and 2018 Most Influential Business Journalist and 2021 \\\"Who's Who\\\" in multiple categories, Tim is a recognized thought leader in enterprise tech and AI.\",\"url\":\"https:\/\/solutionsreview.com\/data-management\/author\/timking\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Snowflake Beefs Up its Cloud Data Warehouse Query Performance","description":"Snowflake Computing has announced the availability of new cloud data warehouse performance features to optimize query performance.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/solutionsreview.com\/data-management\/snowflake-beefs-up-its-cloud-data-warehouse-query-performance\/","og_locale":"en_US","og_type":"article","og_title":"Snowflake Beefs Up its Cloud Data Warehouse Query Performance","og_description":"Snowflake Computing has announced the availability of new cloud data warehouse performance features to optimize query performance.","og_url":"https:\/\/solutionsreview.com\/data-management\/snowflake-beefs-up-its-cloud-data-warehouse-query-performance\/","og_site_name":"Best Data Management Software, Vendors and Data Science Platforms","article_published_time":"2018-11-15T15:59:45+00:00","article_modified_time":"2018-11-15T16:11:13+00:00","og_image":[{"width":800,"height":400,"url":"https:\/\/solutionsreview.com\/data-management\/files\/2018\/11\/oie_ExKgJ7vHHSwX.jpg","type":"image\/jpeg"}],"author":"Tim King","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Tim King","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/solutionsreview.com\/data-management\/snowflake-beefs-up-its-cloud-data-warehouse-query-performance\/","url":"https:\/\/solutionsreview.com\/data-management\/snowflake-beefs-up-its-cloud-data-warehouse-query-performance\/","name":"Snowflake Beefs Up its Cloud Data Warehouse Query Performance","isPartOf":{"@id":"https:\/\/solutionsreview.com\/data-management\/#website"},"primaryImageOfPage":{"@id":"https:\/\/solutionsreview.com\/data-management\/snowflake-beefs-up-its-cloud-data-warehouse-query-performance\/#primaryimage"},"image":{"@id":"https:\/\/solutionsreview.com\/data-management\/snowflake-beefs-up-its-cloud-data-warehouse-query-performance\/#primaryimage"},"thumbnailUrl":"https:\/\/solutionsreview.com\/data-management\/files\/2018\/11\/oie_ExKgJ7vHHSwX.jpg","datePublished":"2018-11-15T15:59:45+00:00","dateModified":"2018-11-15T16:11:13+00:00","author":{"@id":"https:\/\/solutionsreview.com\/data-management\/#\/schema\/person\/154e152a275103e373e24ada7f2feb5c"},"description":"Snowflake Computing has announced the availability of new cloud data warehouse performance features to optimize query performance.","breadcrumb":{"@id":"https:\/\/solutionsreview.com\/data-management\/snowflake-beefs-up-its-cloud-data-warehouse-query-performance\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/solutionsreview.com\/data-management\/snowflake-beefs-up-its-cloud-data-warehouse-query-performance\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/solutionsreview.com\/data-management\/snowflake-beefs-up-its-cloud-data-warehouse-query-performance\/#primaryimage","url":"https:\/\/solutionsreview.com\/data-management\/files\/2018\/11\/oie_ExKgJ7vHHSwX.jpg","contentUrl":"https:\/\/solutionsreview.com\/data-management\/files\/2018\/11\/oie_ExKgJ7vHHSwX.jpg","width":800,"height":400,"caption":"Snowflake Beefs Up its Cloud Data Warehouse Query Performance"},{"@type":"BreadcrumbList","@id":"https:\/\/solutionsreview.com\/data-management\/snowflake-beefs-up-its-cloud-data-warehouse-query-performance\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/solutionsreview.com\/data-management\/"},{"@type":"ListItem","position":2,"name":"Snowflake Beefs Up its Cloud Data Warehouse Query Performance"}]},{"@type":"WebSite","@id":"https:\/\/solutionsreview.com\/data-management\/#website","url":"https:\/\/solutionsreview.com\/data-management\/","name":"Best Data Management Software, Vendors and Data Science Platforms","description":"Enterprise Information Management","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/solutionsreview.com\/data-management\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/solutionsreview.com\/data-management\/#\/schema\/person\/154e152a275103e373e24ada7f2feb5c","name":"Tim King","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/solutionsreview.com\/data-management\/#\/schema\/person\/image\/","url":"https:\/\/solutionsreview.com\/data-management\/files\/2023\/12\/tk.jpg","contentUrl":"https:\/\/solutionsreview.com\/data-management\/files\/2023\/12\/tk.jpg","caption":"Tim King"},"description":"Tim is Solutions Review's Executive Editor covering the human impact of AI on the future of work and learning. He is also the Media Strategist behind Insight Jam (1M+ on YouTube) events and programming. A 2017 and 2018 Most Influential Business Journalist and 2021 \"Who's Who\" in multiple categories, Tim is a recognized thought leader in enterprise tech and AI.","url":"https:\/\/solutionsreview.com\/data-management\/author\/timking\/"}]}},"_links":{"self":[{"href":"https:\/\/solutionsreview.com\/data-management\/wp-json\/wp\/v2\/posts\/1586"}],"collection":[{"href":"https:\/\/solutionsreview.com\/data-management\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/solutionsreview.com\/data-management\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/solutionsreview.com\/data-management\/wp-json\/wp\/v2\/users\/23"}],"replies":[{"embeddable":true,"href":"https:\/\/solutionsreview.com\/data-management\/wp-json\/wp\/v2\/comments?post=1586"}],"version-history":[{"count":0,"href":"https:\/\/solutionsreview.com\/data-management\/wp-json\/wp\/v2\/posts\/1586\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/solutionsreview.com\/data-management\/wp-json\/wp\/v2\/media\/1587"}],"wp:attachment":[{"href":"https:\/\/solutionsreview.com\/data-management\/wp-json\/wp\/v2\/media?parent=1586"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/solutionsreview.com\/data-management\/wp-json\/wp\/v2\/categories?post=1586"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/solutionsreview.com\/data-management\/wp-json\/wp\/v2\/tags?post=1586"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}