{"id":2816,"date":"2018-04-30T00:00:00","date_gmt":"2018-04-30T00:00:00","guid":{"rendered":""},"modified":"2023-05-11T15:40:07","modified_gmt":"2023-05-11T22:40:07","slug":"turbocharge-cloud-analytics-with-azure-sql-data-warehouse","status":"publish","type":"post","link":"https:\/\/azure.microsoft.com\/en-us\/blog\/turbocharge-cloud-analytics-with-azure-sql-data-warehouse\/","title":{"rendered":"Turbocharge cloud analytics with Azure SQL Data Warehouse"},"content":{"rendered":"<p>Data is transformative. The ability to turn data into breakthrough insights is foundational to remain relevant in an increasingly competitive market.<\/p>\n<p>To help our customers deliver fast insights from exponentially growing data, today we are announcing the <strong>general availability of the Compute Optimized Gen2 tier<\/strong> of Azure SQL Data Warehouse. With this performance optimized tier, we are bringing the best of Microsoft software and hardware innovations to dramatically accelerate query performance and concurrency for our customers.<\/p>\n<h2>Fast, flexible, and secure cloud data warehouse<\/h2>\n<p>We launched Azure SQL Data Warehouse three years ago to make a powerful SQL based MPP (massively parallel processing) architecture data warehousing accessible to all. It was the first data warehouse that helped customers reduce costs by enabling them to scale compute and storage independently, and by offering pause and resume capabilities. This flexibility, combined with fast query performance, comprehensive data security, and governance capabilities has led to adoption by thousands of customers like Adobe, Toshiba, and LG Electronics. To keep up with customer demand, we have expanded the service to 33 Azure regions and it is now the most globally available of all cloud data warehouse services.<\/p>\n<p>Azure SQL Data Warehouse Compute Optimized Gen2 tier sets new performance standards for cloud data warehousing. Customers now get up to 5 times better query performance, 4 times more concurrency, and 5 times higher computing power compared to the current generation. It can now serve 128 concurrent queries from a single cluster, the highest of any cloud data warehousing service.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"final image\" height=\"576\" src=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2018\/04\/644764cb-0718-4fc1-bca4-2b1178863a3a.webp\" title=\"final image\" width=\"1024\"><\/p>\n<p>Powering these performance gains is <a href=\"https:\/\/azure.microsoft.com\/en-us\/blog\/adaptive-caching-powers-azure-sql-data-warehouse-performance-gains\/\" target=\"_blank\" rel=\"noopener\">adaptive caching technology<\/a> that understands where data needs to be and when it needs to be there for the best possible performance. Azure SQL Data Warehouse takes a blended approach of using remote storage in combination with a fast SSD cache layer (using NVMes) that places data next to compute based on user access patterns and frequency. We have also added Transparent Data Encryption with customer-managed keys to keep your data truly in your control.<\/p>\n<p>Customers such as <strong>DriveTime<\/strong>, a leading used car retailer in the US, are taking advantage of the new tier to significantly improve performance while lowering their costs.<\/p>\n<p><em>\u201cDriveTime manages a lot of data: 400,000 loans per month with up to 1,000 data elements per loan,\u201d<\/em> says Peter Grisolano, Managing Director for Database Development at DriveTime. <em>\u201cWe were impressed by how quickly we could analyze this data with SQL Data Warehouse Compute Optimized Gen2 tier.\u201d<\/em><\/p>\n<h2>Azure is the best place for analytics<\/h2>\n<p>With its native integration with <a href=\"https:\/\/azure.microsoft.com\/en-us\/services\/databricks\/\" target=\"_blank\" rel=\"noopener\">Azure Databricks<\/a>, <a href=\"https:\/\/azure.microsoft.com\/en-us\/services\/data-factory\/\" target=\"_blank\" rel=\"noopener\">Azure Data Factory<\/a>, <a href=\"https:\/\/azure.microsoft.com\/en-us\/services\/storage\/blobs\/\" target=\"_blank\" rel=\"noopener\">Blob Storage<\/a> and <a href=\"https:\/\/powerbi.microsoft.com\/en-us\/\" target=\"_blank\" rel=\"noopener\">Power BI<\/a>, Azure SQL Data Warehouse allows customers to build new analytics solutions to support <a href=\"https:\/\/azure.microsoft.com\/en-us\/blog\/implementation-patterns-for-big-data-and-data-warehouse-on-azure\/\" target=\"_blank\" rel=\"noopener\">modern data warehousing, advanced analytics, and real-time analytics scenarios<\/a>.<\/p>\n<p>Azure SQL Data Warehouse also works with leading data integration and business intelligence solutions such as <a href=\"https:\/\/infa.media\/wp180430a\" target=\"_blank\" rel=\"noopener\">Informatica<\/a>, <a href=\"https:\/\/www.talend.com\/blog\/2017\/05\/09\/data-warehousing-big-data-microsoft-azure\/\" target=\"_blank\" rel=\"noopener\">Talend<\/a>, <a href=\"https:\/\/www.tableau.com\/about\/blog\/2018\/4\/announcing-support-azure-sql-data-warehouse-gen2-85822\" target=\"_blank\" rel=\"noopener\">Tableau<\/a>, <a href=\"https:\/\/ir.microstrategy.com\/news-releases\/news-release-details\/microstrategy-releases-three-new-gateways-microsoft-azure\" target=\"_blank\" rel=\"noopener\">MicroStrategy<\/a>, <a href=\"https:\/\/www.qlik.com\/us\/\" target=\"_blank\" rel=\"noopener\">Qlik<\/a>, and <a href=\"https:\/\/community.alteryx.com\/t5\/Analytics-Blog\/A-Modern-Foundation-for-Big-Data-Driven-Organizations\/ba-p\/158591\" target=\"_blank\" rel=\"noopener\">Alteryx<\/a>. Additionally, we have invested in partnerships with <a href=\"https:\/\/Datometry.com\" target=\"_blank\" rel=\"noopener\">Datometry<\/a> and <a href=\"https:\/\/Attunity.com\" target=\"_blank\" rel=\"noopener\">Attunity<\/a> to enable customers to simplify the migration of on-premises data warehouse to the cloud. These ecosystem investments allow our customers to build upon their existing infrastructure and significantly accelerate time to value for powerful analytics solutions.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" alt=\"Rich Partner Network\" height=\"720\" src=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2018\/04\/94944890-df81-40e9-b8d8-d6cd5031d838.webp\" title=\"Rich Partner Network\" width=\"1280\"><\/p>\n<p>To find out more, you can:<\/p>\n<ul>\n<li>See Azure SQL Data Warehouse Compute Optimized Gen2 tier in action in this <a href=\"https:\/\/youtu.be\/Ap8I3UZonzI\" target=\"_blank\" rel=\"noopener\">Microsoft Mechanics video<\/a>.<\/li>\n<li>Read about the <a href=\"https:\/\/azure.microsoft.com\/en-us\/blog\/blazing-fast-data-warehousing-with-sql-data-warehouse-gen2\" target=\"_blank\" rel=\"noopener\">key capabilities and features<\/a> of Azure SQL Data Warehouse Compute Optimized Gen2 tier.<\/li>\n<li>Discover how we built the <a href=\"https:\/\/azure.microsoft.com\/en-us\/blog\/adaptive-caching-powers-azure-sql-data-warehouse-performance-gains\/\" target=\"_blank\" rel=\"noopener\">Adaptive Cache<\/a> for Azure SQL Data Warehouse Compute Optimized Gen2 tier.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Data is transformative. The ability to turn data into breakthrough insights is foundational to remain relevant in an increasingly competitive market.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"ms_queue_id":[],"ep_exclude_from_search":false,"_classifai_error":"","_classifai_text_to_speech_error":"","_alt_title":"","footnotes":"","msx_community_cta_settings":[]},"categories":[1474],"tags":[],"audience":[3054,3057,3053],"content-type":[1465],"product":[1821,1544],"tech-community":[],"topic":[],"coauthors":[51],"class_list":["post-2816","post","type-post","status-publish","format-standard","hentry","category-analytics","audience-business-decision-makers","audience-data-professionals","audience-it-decision-makers","content-type-announcements","product-azure-data-factory","product-azure-databricks"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Turbocharge cloud analytics with Azure SQL Data Warehouse | Microsoft Azure Blog<\/title>\n<meta name=\"description\" content=\"Data is transformative. The ability to turn data into breakthrough insights is foundational to remain relevant in an increasingly competitive market. To help our customers deliver fast insights from\u2026\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/azure.microsoft.com\/en-us\/blog\/turbocharge-cloud-analytics-with-azure-sql-data-warehouse\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Turbocharge cloud analytics with Azure SQL Data Warehouse | Microsoft Azure Blog\" \/>\n<meta property=\"og:description\" content=\"Data is transformative. The ability to turn data into breakthrough insights is foundational to remain relevant in an increasingly competitive market. To help our customers deliver fast insights from\u2026\" \/>\n<meta property=\"og:url\" content=\"https:\/\/azure.microsoft.com\/en-us\/blog\/turbocharge-cloud-analytics-with-azure-sql-data-warehouse\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft Azure Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/microsoftazure\" \/>\n<meta property=\"article:published_time\" content=\"2018-04-30T00:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-05-11T22:40:07+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2018\/04\/644764cb-0718-4fc1-bca4-2b1178863a3a.webp\" \/>\n<meta name=\"author\" content=\"Rohan Kumar\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@azure\" \/>\n<meta name=\"twitter:site\" content=\"@azure\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Rohan Kumar\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/turbocharge-cloud-analytics-with-azure-sql-data-warehouse\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/turbocharge-cloud-analytics-with-azure-sql-data-warehouse\/\"},\"author\":[{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/author\/rohan-kumar\/\",\"@type\":\"Person\",\"@name\":\"Rohan Kumar\"}],\"headline\":\"Turbocharge cloud analytics with Azure SQL Data Warehouse\",\"datePublished\":\"2018-04-30T00:00:00+00:00\",\"dateModified\":\"2023-05-11T22:40:07+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/turbocharge-cloud-analytics-with-azure-sql-data-warehouse\/\"},\"wordCount\":573,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/turbocharge-cloud-analytics-with-azure-sql-data-warehouse\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2018\/04\/644764cb-0718-4fc1-bca4-2b1178863a3a.webp\",\"articleSection\":[\"Analytics\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/azure.microsoft.com\/en-us\/blog\/turbocharge-cloud-analytics-with-azure-sql-data-warehouse\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/turbocharge-cloud-analytics-with-azure-sql-data-warehouse\/\",\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/turbocharge-cloud-analytics-with-azure-sql-data-warehouse\/\",\"name\":\"Turbocharge cloud analytics with Azure SQL Data Warehouse | Microsoft Azure Blog\",\"isPartOf\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/turbocharge-cloud-analytics-with-azure-sql-data-warehouse\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/turbocharge-cloud-analytics-with-azure-sql-data-warehouse\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2018\/04\/644764cb-0718-4fc1-bca4-2b1178863a3a.webp\",\"datePublished\":\"2018-04-30T00:00:00+00:00\",\"dateModified\":\"2023-05-11T22:40:07+00:00\",\"description\":\"Data is transformative. The ability to turn data into breakthrough insights is foundational to remain relevant in an increasingly competitive market. To help our customers deliver fast insights from\u2026\",\"breadcrumb\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/turbocharge-cloud-analytics-with-azure-sql-data-warehouse\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/azure.microsoft.com\/en-us\/blog\/turbocharge-cloud-analytics-with-azure-sql-data-warehouse\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/turbocharge-cloud-analytics-with-azure-sql-data-warehouse\/#primaryimage\",\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2018\/04\/644764cb-0718-4fc1-bca4-2b1178863a3a.webp\",\"contentUrl\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2018\/04\/644764cb-0718-4fc1-bca4-2b1178863a3a.webp\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/turbocharge-cloud-analytics-with-azure-sql-data-warehouse\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Blog home\",\"item\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Analytics\",\"item\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/category\/analytics\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Turbocharge cloud analytics with Azure SQL Data Warehouse\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#website\",\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/\",\"name\":\"Microsoft Azure Blog\",\"description\":\"Get the latest Azure news, updates, and announcements from the Azure blog. From product updates to hot topics, hear from the Azure experts.\",\"publisher\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization\",\"name\":\"Microsoft Azure Blog\",\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2024\/06\/microsoft_logo.webp\",\"contentUrl\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2024\/06\/microsoft_logo.webp\",\"width\":512,\"height\":512,\"caption\":\"Microsoft Azure Blog\"},\"image\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/microsoftazure\",\"https:\/\/x.com\/azure\",\"https:\/\/www.instagram.com\/microsoftdeveloper\/\",\"https:\/\/www.linkedin.com\/company\/16188386\",\"https:\/\/www.youtube.com\/user\/windowsazure\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/person\/c702e5edd662b328b49b7e1180cab117\",\"name\":\"shakir\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g7664e653ea371ce16eaf75e9fa8952c4\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g\",\"caption\":\"shakir\"},\"sameAs\":[\"https:\/\/azure.microsoft.com\"],\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/author\/shakir\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Turbocharge cloud analytics with Azure SQL Data Warehouse | Microsoft Azure Blog","description":"Data is transformative. The ability to turn data into breakthrough insights is foundational to remain relevant in an increasingly competitive market. To help our customers deliver fast insights from\u2026","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:\/\/azure.microsoft.com\/en-us\/blog\/turbocharge-cloud-analytics-with-azure-sql-data-warehouse\/","og_locale":"en_US","og_type":"article","og_title":"Turbocharge cloud analytics with Azure SQL Data Warehouse | Microsoft Azure Blog","og_description":"Data is transformative. The ability to turn data into breakthrough insights is foundational to remain relevant in an increasingly competitive market. To help our customers deliver fast insights from\u2026","og_url":"https:\/\/azure.microsoft.com\/en-us\/blog\/turbocharge-cloud-analytics-with-azure-sql-data-warehouse\/","og_site_name":"Microsoft Azure Blog","article_publisher":"https:\/\/www.facebook.com\/microsoftazure","article_published_time":"2018-04-30T00:00:00+00:00","article_modified_time":"2023-05-11T22:40:07+00:00","og_image":[{"url":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2018\/04\/644764cb-0718-4fc1-bca4-2b1178863a3a.webp","type":"","width":"","height":""}],"author":"Rohan Kumar","twitter_card":"summary_large_image","twitter_creator":"@azure","twitter_site":"@azure","twitter_misc":{"Written by":"Rohan Kumar","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/turbocharge-cloud-analytics-with-azure-sql-data-warehouse\/#article","isPartOf":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/turbocharge-cloud-analytics-with-azure-sql-data-warehouse\/"},"author":[{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/author\/rohan-kumar\/","@type":"Person","@name":"Rohan Kumar"}],"headline":"Turbocharge cloud analytics with Azure SQL Data Warehouse","datePublished":"2018-04-30T00:00:00+00:00","dateModified":"2023-05-11T22:40:07+00:00","mainEntityOfPage":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/turbocharge-cloud-analytics-with-azure-sql-data-warehouse\/"},"wordCount":573,"commentCount":0,"publisher":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization"},"image":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/turbocharge-cloud-analytics-with-azure-sql-data-warehouse\/#primaryimage"},"thumbnailUrl":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2018\/04\/644764cb-0718-4fc1-bca4-2b1178863a3a.webp","articleSection":["Analytics"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/azure.microsoft.com\/en-us\/blog\/turbocharge-cloud-analytics-with-azure-sql-data-warehouse\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/turbocharge-cloud-analytics-with-azure-sql-data-warehouse\/","url":"https:\/\/azure.microsoft.com\/en-us\/blog\/turbocharge-cloud-analytics-with-azure-sql-data-warehouse\/","name":"Turbocharge cloud analytics with Azure SQL Data Warehouse | Microsoft Azure Blog","isPartOf":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/turbocharge-cloud-analytics-with-azure-sql-data-warehouse\/#primaryimage"},"image":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/turbocharge-cloud-analytics-with-azure-sql-data-warehouse\/#primaryimage"},"thumbnailUrl":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2018\/04\/644764cb-0718-4fc1-bca4-2b1178863a3a.webp","datePublished":"2018-04-30T00:00:00+00:00","dateModified":"2023-05-11T22:40:07+00:00","description":"Data is transformative. The ability to turn data into breakthrough insights is foundational to remain relevant in an increasingly competitive market. To help our customers deliver fast insights from\u2026","breadcrumb":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/turbocharge-cloud-analytics-with-azure-sql-data-warehouse\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/azure.microsoft.com\/en-us\/blog\/turbocharge-cloud-analytics-with-azure-sql-data-warehouse\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/turbocharge-cloud-analytics-with-azure-sql-data-warehouse\/#primaryimage","url":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2018\/04\/644764cb-0718-4fc1-bca4-2b1178863a3a.webp","contentUrl":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2018\/04\/644764cb-0718-4fc1-bca4-2b1178863a3a.webp"},{"@type":"BreadcrumbList","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/turbocharge-cloud-analytics-with-azure-sql-data-warehouse\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog home","item":"https:\/\/azure.microsoft.com\/en-us\/blog\/"},{"@type":"ListItem","position":2,"name":"Analytics","item":"https:\/\/azure.microsoft.com\/en-us\/blog\/category\/analytics\/"},{"@type":"ListItem","position":3,"name":"Turbocharge cloud analytics with Azure SQL Data Warehouse"}]},{"@type":"WebSite","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#website","url":"https:\/\/azure.microsoft.com\/en-us\/blog\/","name":"Microsoft Azure Blog","description":"Get the latest Azure news, updates, and announcements from the Azure blog. From product updates to hot topics, hear from the Azure experts.","publisher":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/azure.microsoft.com\/en-us\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization","name":"Microsoft Azure Blog","url":"https:\/\/azure.microsoft.com\/en-us\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2024\/06\/microsoft_logo.webp","contentUrl":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2024\/06\/microsoft_logo.webp","width":512,"height":512,"caption":"Microsoft Azure Blog"},"image":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/microsoftazure","https:\/\/x.com\/azure","https:\/\/www.instagram.com\/microsoftdeveloper\/","https:\/\/www.linkedin.com\/company\/16188386","https:\/\/www.youtube.com\/user\/windowsazure"]},{"@type":"Person","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#\/schema\/person\/c702e5edd662b328b49b7e1180cab117","name":"shakir","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g7664e653ea371ce16eaf75e9fa8952c4","url":"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/9342c7c05bb16548741bc5cd3a3e3b7ee0c8e746844ad2cc582db5beb5514c6f?s=96&d=mm&r=g","caption":"shakir"},"sameAs":["https:\/\/azure.microsoft.com"],"url":"https:\/\/azure.microsoft.com\/en-us\/blog\/author\/shakir\/"}]}},"msxcm_display_generated_audio":false,"msxcm_animated_featured_image":null,"distributor_meta":false,"distributor_terms":false,"distributor_media":false,"distributor_original_site_name":"Microsoft Azure Blog","distributor_original_site_url":"https:\/\/azure.microsoft.com\/en-us\/blog","push-errors":false,"_links":{"self":[{"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/posts\/2816","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/comments?post=2816"}],"version-history":[{"count":0,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/posts\/2816\/revisions"}],"wp:attachment":[{"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/media?parent=2816"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/categories?post=2816"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/tags?post=2816"},{"taxonomy":"audience","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/audience?post=2816"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/content-type?post=2816"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/product?post=2816"},{"taxonomy":"tech-community","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/tech-community?post=2816"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/topic?post=2816"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/coauthors?post=2816"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}