{"id":901,"date":"2019-11-07T00:00:00","date_gmt":"2019-11-07T08:00:00","guid":{"rendered":"https:\/\/azure.microsoft.com\/blog\/azure-sql-data-warehouse-is-now-azure-synapse-analytics"},"modified":"2025-06-26T11:38:54","modified_gmt":"2025-06-26T18:38:54","slug":"azure-sql-data-warehouse-is-now-azure-synapse-analytics","status":"publish","type":"post","link":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-sql-data-warehouse-is-now-azure-synapse-analytics\/","title":{"rendered":"Azure SQL Data Warehouse is now Azure Synapse Analytics"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">On November fourth, we <a href=\"https:\/\/aka.ms\/Blog_Hero\" target=\"_blank\" rel=\"noopener\">announced Azure Synapse Analytics<\/a>, the next evolution of Azure SQL Data Warehouse. Azure Synapse is a limitless analytics service that brings together enterprise data warehousing and Big Data analytics. It gives you the freedom to query data on your terms, using either serverless on-demand or provisioned resources\u2014at scale. Azure Synapse brings these two worlds together with a unified experience to ingest, prepare, manage, and serve data for immediate business intelligence and machine learning needs.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">With Azure Synapse, data professionals can query both relational and non-relational data using the familiar SQL language. This can be done using either <strong>serverless on-demand queries<\/strong> for data exploration and ad hoc analysis or <strong>provisioned resources<\/strong> for your most demanding <a href=\"https:\/\/azure.microsoft.com\/en-us\/resources\/cloud-computing-dictionary\/what-is-a-data-warehouse\" target=\"_blank\" rel=\"noopener\">data warehousing<\/a> needs. A single service for any workload.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In fact, it\u2019s the first and only analytics system to have run all the TPC-H queries at <strong>petabyte-scale<\/strong>. For current SQL Data Warehouse customers, you can continue running your existing data warehouse workloads in production today with Azure Synapse and will automatically benefit from the new preview capabilities when they become generally available. You can <a href=\"https:\/\/azure.microsoft.com\/services\/synapse-analytics\/request-for-private-preview\/\" target=\"_blank\" rel=\"noopener\">sign up to preview new features<\/a> like serverless on-demand query, Azure Synapse studio, and Apache Spark\u2122 integration.<\/p>\n\n\n\n<figure class=\"wp-block-image has-custom-border\"><img decoding=\"async\" src=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/11\/4f907102-6934-45ea-9eb4-acdfec680961.webp\" alt=\"A diagram showing how Azure Synapse Analytics connects Power BI, Azure Machine Learning, and your ecosystem.\" style=\"border-radius:0px\" title=\"A diagram showing how Azure Synapse Analytics connects Power BI, Azure Machine Learning, and your ecosystem.\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"taking-sql-beyond-data-warehousing\"><a href=\"https:\/\/azure.microsoft.com\/services\/synapse-analytics\/\" target=\"_blank\" rel=\"noopener\">Taking SQL beyond data warehousing<\/a><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">A cloud native, distributed SQL processing engine is at the foundation of Azure Synapse and is what enables the service to support the most demanding enterprise data warehousing workloads. This week at Ignite we introduced a number of exciting <a href=\"https:\/\/azure.microsoft.com\/services\/synapse-analytics\/\" target=\"_blank\" rel=\"noopener\">features<\/a> to make data warehousing with Azure Synapse easier and allow organizations to use SQL for a broader set of analytics use cases.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"unlock-powerful-insights-faster-from-all-data\">Unlock powerful insights faster from all data<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Azure Synapse deeply integrates with Power BI and Azure Machine Learning to drive insights for all users, from data scientists coding with statistics to the business user with Power BI. And to make all types of analytics possible, we\u2019re announcing native and built-in prediction support, as well as runtime level improvements to how Azure Synapse handles streaming data, parquet files, and Polybase. Let\u2019s dive into more detail:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li class=\"wp-block-list-item\"><strong>With the native PREDICT statement, you can score machine learning models within your data warehouse<\/strong>\u2014avoiding the need for large and complex data movement. The PREDICT function (available in preview) relies on open model framework and takes user data as input to generate predictions. Users can <a href=\"https:\/\/docs.microsoft.com\/windows\/ai\/windows-ml\/convert-model-winmltools\" target=\"_blank\" rel=\"noopener\">convert existing models<\/a> trained in Azure Machine Learning, Apache Spark\u2122, or other frameworks into an internal format representation without having to start from scratch, accelerating time to insight.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image has-custom-border\"><img decoding=\"async\" src=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/11\/9087d11c-6afa-4cc6-907a-a1a38a4aea98.webp\" alt=\"A diagram showing how you can create and upload models to score them with SQL Analytics in Data Warehouse.\" style=\"border-radius:0px\" title=\"A diagram showing how you can create and upload models to score them with SQL Analytics in Data Warehouse.\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li class=\"wp-block-list-item\">We\u2019ve enabled <strong>direct streaming ingestion support<\/strong> and ability to execute analytical queries over streaming data. Capabilities such as: joins across multiple streaming inputs, aggregations within one or more streaming inputs, transform semi-structured data and multiple temporal windows are all supported directly in your data warehousing environment (available in preview). For streaming ingestion, customers can integrate with Event Hubs (including Event Hubs for Kafka) and IoT Hubs.<\/li>\n\n\n\n<li class=\"wp-block-list-item\">We\u2019re also removing the barrier that inhibits securely and easily sharing data inside or outside your organization with <a href=\"https:\/\/azure.microsoft.com\/services\/data-share\/\" target=\"_blank\" rel=\"noopener\">Azure Data Share<\/a> integration for sharing both data lake and data warehouse data.<\/li>\n\n\n\n<li class=\"wp-block-list-item\">By using new <strong>ParquetDirect technology<\/strong>, we are making interactive queries over the data lake a reality (in preview). It\u2019s designed to access Parquet files with native support directly built into the engine. Through improved data scan rates, intelligent data caching and columnstore batch processing, we\u2019ve <strong>improved Polybase execution by over 13x<\/strong>.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image has-custom-border\"><img decoding=\"async\" src=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/11\/cdcaeea2-10be-4091-b722-d9b510ef2cb4.webp\" alt=\"A graph showing the performance improvement with ParquetDirect.\" style=\"border-radius:0px\" title=\"A graph showing the performance improvement with ParquetDirect.\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"workload-isolation\">Workload isolation<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">To support customers as they democratize their data warehouses, we are announcing new features for intelligent workload management. The new <a href=\"https:\/\/docs.microsoft.com\/azure\/sql-data-warehouse\/sql-data-warehouse-workload-isolation\" target=\"_blank\" rel=\"noopener\">Workload Isolation<\/a> functionality allows you to manage the execution of heterogeneous workloads while providing flexibility and control over data warehouse resources. This leads to improved execution predictability and enhances the ability to satisfy predefined SLAs.<\/p>\n\n\n\n<figure class=\"wp-block-image has-custom-border\"><img decoding=\"async\" src=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/11\/1a77c35f-9d6c-4f8f-935d-de39b61f1a7d.webp\" alt=\"An image showing workload isolation in Data Warehouse.\" style=\"border-radius:0px\" title=\"An image showing workload isolation in Data Warehouse.\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"copy-statement\">COPY statement<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Analyzing petabyte-scale data requires ingesting petabyte-scale data. To streamline the data ingestion process, we are introducing a simple and flexible COPY statement. With only one command, Azure Synapse now enables data to be seamlessly ingested into a data warehouse in a fast and secure manner.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">This new COPY statement enables using a single T-SQL statement to load data, parse standard CSV files, and more.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">COPY statement sample code:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><code>COPY INTO dbo.[FactOnlineSales] FROM \u2019<a href=\"https:\/\/contoso.blob.core.windows.net\/Sales\/%C3%A2%C2%80%C2%99\">https:\/\/contoso.blob.core.windows.net\/Sales\/\u2019<\/a><\/code><\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"safe-keeping-for-data-with-unmatched-security\">Safe keeping for data with unmatched security<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Azure has the most advanced security and privacy features in the market. These features are built into the fabric of Azure Synapse, such as automated threat detection and always-on data encryption. And for fine-grained access control businesses can ensure data stays safe <em>and<\/em> private using column-level security, native row-level security, and <a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/sql-database\/sql-database-dynamic-data-masking-get-started\" target=\"_blank\" rel=\"noopener\">dynamic data masking<\/a> (now generally available) to <em>automatically<\/em> protect sensitive data in real time.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">To further enhance security and privacy, we are introducing <a href=\"https:\/\/docs.microsoft.com\/azure\/sql-database\/sql-database-private-endpoint-overview\" target=\"_blank\" rel=\"noopener\">Azure Private Link<\/a>. It provides a secure and scalable way to consume deployed resources from your own Azure Virtual Network (VNet). A secure connection is established using a consent-based call flow. Once established, all data that flows between Azure Synapse and service consumers is isolated from the internet and stays on the Microsoft network. There is no longer a need for gateways, network addresses translation (NAT) devices, or public IP addresses to communicate with the service.<\/p>\n\n\n\n<figure class=\"wp-block-image has-custom-border\"><img decoding=\"async\" src=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/11\/986a9502-a3ba-40a5-8a14-4ec1636a8ffb.webp\" alt=\"An image showing Azure Private Link\u00e2\u20ac\u201da secure and scalable way to consume deployed resources from your own Azure Virtual Network (VNet). \" style=\"border-radius:0px\" title=\"An image showing Azure Private Link\u00e2\u20ac\u201da secure and scalable way to consume deployed resources from your own Azure Virtual Network (VNet). \" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"get-started-today\">Get started today<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Businesses can continue running their existing data warehouse workloads in production today with generally available features on Azure Synapse.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li class=\"wp-block-list-item\"><a href=\"mailto:askSynapsePreview@microsoft.com?subject=Azure%20Synapse%20Preview%20or%20New%20Data%20Warehousing%20Preview%20Features\">Email the team to nominate yourself to try the preview features announced in this blog.<\/a><\/li>\n\n\n\n<li class=\"wp-block-list-item\"><a href=\"https:\/\/aka.ms\/Azure_Synapse_Analytics\" target=\"_blank\" rel=\"noopener\">Visit the Azure Synapse Analytics page to learn more<\/a>.<\/li>\n\n\n\n<li class=\"wp-block-list-item\"><a href=\"https:\/\/azure.microsoft.com\/free\/sql-data-warehouse\/\" target=\"_blank\" rel=\"noopener\">Get started with a free Azure Synapse Analytics account<\/a>.<\/li>\n\n\n\n<li class=\"wp-block-list-item\"><a href=\"https:\/\/aka.ms\/Azure_Synapse_LVE\" target=\"_blank\" rel=\"noopener\">Register for the live virtual event with the Azure Synapse Analytics team<\/a>.<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\" \/>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Azure. Invent with purpose.<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"<p>On November fourth, we announced Azure Synapse Analytics, the next evolution of Azure SQL Data Warehouse. Azure Synapse is a limitless analytics service that brings together enterprise data warehousing and Big Data analytics.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","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":[1477],"tech-community":[],"topic":[],"coauthors":[97],"class_list":["post-901","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-synapse-analytics","review-flag-1680286581-295","review-flag-alway-1680286580-106","review-flag-free-1680286579-836","review-flag-integ-1680286579-214","review-flag-iot-1680286585-835","review-flag-machi-1680286585-314","review-flag-new-1680286579-546"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Azure SQL Data Warehouse is now Azure Synapse Analytics | Microsoft Azure Blog<\/title>\n<meta name=\"description\" content=\"On November fourth, we announced Azure Synapse Analytics, the next evolution of Azure SQL Data Warehouse. Azure Synapse is a limitless analytics service that brings together enterprise data warehousing and Big Data analytics.\" \/>\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\/azure-sql-data-warehouse-is-now-azure-synapse-analytics\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Azure SQL Data Warehouse is now Azure Synapse Analytics | Microsoft Azure Blog\" \/>\n<meta property=\"og:description\" content=\"On November fourth, we announced Azure Synapse Analytics, the next evolution of Azure SQL Data Warehouse. Azure Synapse is a limitless analytics service that brings together enterprise data warehousing and Big Data analytics.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-sql-data-warehouse-is-now-azure-synapse-analytics\/\" \/>\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=\"2019-11-07T08:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-26T18:38:54+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/11\/4f907102-6934-45ea-9eb4-acdfec680961.webp\" \/>\n<meta name=\"author\" content=\"Microsoft Azure\" \/>\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=\"Microsoft Azure\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 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\/azure-sql-data-warehouse-is-now-azure-synapse-analytics\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-sql-data-warehouse-is-now-azure-synapse-analytics\/\"},\"author\":[{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/author\/microsoft-azure\/\",\"@type\":\"Person\",\"@name\":\"Microsoft Azure\"}],\"headline\":\"Azure SQL Data Warehouse is now Azure Synapse Analytics\",\"datePublished\":\"2019-11-07T08:00:00+00:00\",\"dateModified\":\"2025-06-26T18:38:54+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-sql-data-warehouse-is-now-azure-synapse-analytics\/\"},\"wordCount\":934,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-sql-data-warehouse-is-now-azure-synapse-analytics\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/11\/4f907102-6934-45ea-9eb4-acdfec680961.webp\",\"articleSection\":[\"Analytics\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-sql-data-warehouse-is-now-azure-synapse-analytics\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-sql-data-warehouse-is-now-azure-synapse-analytics\/\",\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-sql-data-warehouse-is-now-azure-synapse-analytics\/\",\"name\":\"Azure SQL Data Warehouse is now Azure Synapse Analytics | Microsoft Azure Blog\",\"isPartOf\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-sql-data-warehouse-is-now-azure-synapse-analytics\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-sql-data-warehouse-is-now-azure-synapse-analytics\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/11\/4f907102-6934-45ea-9eb4-acdfec680961.webp\",\"datePublished\":\"2019-11-07T08:00:00+00:00\",\"dateModified\":\"2025-06-26T18:38:54+00:00\",\"description\":\"On November fourth, we announced Azure Synapse Analytics, the next evolution of Azure SQL Data Warehouse. Azure Synapse is a limitless analytics service that brings together enterprise data warehousing and Big Data analytics.\",\"breadcrumb\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-sql-data-warehouse-is-now-azure-synapse-analytics\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-sql-data-warehouse-is-now-azure-synapse-analytics\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-sql-data-warehouse-is-now-azure-synapse-analytics\/#primaryimage\",\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/11\/4f907102-6934-45ea-9eb4-acdfec680961.webp\",\"contentUrl\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/11\/4f907102-6934-45ea-9eb4-acdfec680961.webp\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-sql-data-warehouse-is-now-azure-synapse-analytics\/#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\":\"Azure SQL Data Warehouse is now Azure Synapse Analytics\"}]},{\"@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":"Azure SQL Data Warehouse is now Azure Synapse Analytics | Microsoft Azure Blog","description":"On November fourth, we announced Azure Synapse Analytics, the next evolution of Azure SQL Data Warehouse. Azure Synapse is a limitless analytics service that brings together enterprise data warehousing and Big Data analytics.","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\/azure-sql-data-warehouse-is-now-azure-synapse-analytics\/","og_locale":"en_US","og_type":"article","og_title":"Azure SQL Data Warehouse is now Azure Synapse Analytics | Microsoft Azure Blog","og_description":"On November fourth, we announced Azure Synapse Analytics, the next evolution of Azure SQL Data Warehouse. Azure Synapse is a limitless analytics service that brings together enterprise data warehousing and Big Data analytics.","og_url":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-sql-data-warehouse-is-now-azure-synapse-analytics\/","og_site_name":"Microsoft Azure Blog","article_publisher":"https:\/\/www.facebook.com\/microsoftazure","article_published_time":"2019-11-07T08:00:00+00:00","article_modified_time":"2025-06-26T18:38:54+00:00","og_image":[{"url":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/11\/4f907102-6934-45ea-9eb4-acdfec680961.webp","type":"","width":"","height":""}],"author":"Microsoft Azure","twitter_card":"summary_large_image","twitter_creator":"@azure","twitter_site":"@azure","twitter_misc":{"Written by":"Microsoft Azure","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-sql-data-warehouse-is-now-azure-synapse-analytics\/#article","isPartOf":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-sql-data-warehouse-is-now-azure-synapse-analytics\/"},"author":[{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/author\/microsoft-azure\/","@type":"Person","@name":"Microsoft Azure"}],"headline":"Azure SQL Data Warehouse is now Azure Synapse Analytics","datePublished":"2019-11-07T08:00:00+00:00","dateModified":"2025-06-26T18:38:54+00:00","mainEntityOfPage":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-sql-data-warehouse-is-now-azure-synapse-analytics\/"},"wordCount":934,"commentCount":0,"publisher":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization"},"image":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-sql-data-warehouse-is-now-azure-synapse-analytics\/#primaryimage"},"thumbnailUrl":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/11\/4f907102-6934-45ea-9eb4-acdfec680961.webp","articleSection":["Analytics"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/azure.microsoft.com\/en-us\/blog\/azure-sql-data-warehouse-is-now-azure-synapse-analytics\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-sql-data-warehouse-is-now-azure-synapse-analytics\/","url":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-sql-data-warehouse-is-now-azure-synapse-analytics\/","name":"Azure SQL Data Warehouse is now Azure Synapse Analytics | Microsoft Azure Blog","isPartOf":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-sql-data-warehouse-is-now-azure-synapse-analytics\/#primaryimage"},"image":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-sql-data-warehouse-is-now-azure-synapse-analytics\/#primaryimage"},"thumbnailUrl":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/11\/4f907102-6934-45ea-9eb4-acdfec680961.webp","datePublished":"2019-11-07T08:00:00+00:00","dateModified":"2025-06-26T18:38:54+00:00","description":"On November fourth, we announced Azure Synapse Analytics, the next evolution of Azure SQL Data Warehouse. Azure Synapse is a limitless analytics service that brings together enterprise data warehousing and Big Data analytics.","breadcrumb":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-sql-data-warehouse-is-now-azure-synapse-analytics\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/azure.microsoft.com\/en-us\/blog\/azure-sql-data-warehouse-is-now-azure-synapse-analytics\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-sql-data-warehouse-is-now-azure-synapse-analytics\/#primaryimage","url":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/11\/4f907102-6934-45ea-9eb4-acdfec680961.webp","contentUrl":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2019\/11\/4f907102-6934-45ea-9eb4-acdfec680961.webp"},{"@type":"BreadcrumbList","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/azure-sql-data-warehouse-is-now-azure-synapse-analytics\/#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":"Azure SQL Data Warehouse is now Azure Synapse Analytics"}]},{"@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\/901","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=901"}],"version-history":[{"count":1,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/posts\/901\/revisions"}],"predecessor-version":[{"id":43957,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/posts\/901\/revisions\/43957"}],"wp:attachment":[{"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/media?parent=901"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/categories?post=901"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/tags?post=901"},{"taxonomy":"audience","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/audience?post=901"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/content-type?post=901"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/product?post=901"},{"taxonomy":"tech-community","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/tech-community?post=901"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/topic?post=901"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/coauthors?post=901"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}