{"id":2723,"date":"2018-05-14T00:00:00","date_gmt":"2018-05-14T07:00:00","guid":{"rendered":"https:\/\/azure.microsoft.com\/blog\/accelerate-your-cloud-data-warehouse-with-automation-tools"},"modified":"2023-07-28T09:43:11","modified_gmt":"2023-07-28T16:43:11","slug":"accelerate-your-cloud-data-warehouse-with-automation-tools","status":"publish","type":"post","link":"https:\/\/azure.microsoft.com\/en-us\/blog\/accelerate-your-cloud-data-warehouse-with-automation-tools\/","title":{"rendered":"Accelerate your cloud data warehouse with automation tools"},"content":{"rendered":"

Gaining insights rapidly from data is critical to competitiveness in today\u2019s business world. Azure SQL Data Warehouse<\/a> (SQL DW), Microsoft\u2019s fully managed analytics platform, leverages Massively Parallel Processing (MPP) to run complex interactive SQL queries at every level of scale.<\/p>\n

An enterprise data warehouse doesn\u2019t exist in isolation but is part of a complete analytics solution that includes the \u2018pipelines\u2019 that extract, transform, and load data, often from many disparate sources, as well as staging and reporting layers. Tasks such as continuous integration and continuous delivery require extensive manual coding and doesn’t offer the flexibility needed for the rapidly changing business needs. This is where data warehouse automation tools provide value for customers.<\/p>\n

Data warehouse automation (DWA) tools are meta-data driven, code generation tools that streamline developing and managing a data warehouse solution. DWA tools provide more than just ETL automation, they automate the complete life cycle of a data warehouse solution, from analysis, design, and implementation to documentation, monitoring and maintenance.<\/p>\n

Benefits of data warehouse automation<\/h2>\n

Data warehouse automation (DWA) tools bring the benefits of meta-data driven automation, and code generation to streamline developing and managing a data warehouse solution. DWA tools provide more than just ETL automation, they automate the complete life cycle of a data warehouse solution, from analysis, design, and implementation to documentation, monitoring and maintenance.<\/p>\n

Acceleration<\/b>: By automating repeatable, tedious tasks such as source discovery, fact and dimension mapping, dimension type assignment, change-impact analysis and version control, DWA tools accelerate time to market for data warehouse projects.<\/p>\n

\u201cWhereScape automates the design, development and operation of agile data warehouse projects by increasing developer productivity by 10x. It leverages the enormous processing power of Azure SQL DW\u2019s MPP architecture together with the ease of use and support that comes with using T-SQL as the processing and query language.<\/i>\u201d<\/p>\n

\u2013 Douglas Barrett, Senior Solutions Architect, WhereScape<\/p>\n

Consistency<\/b>: By leveraging data warehouse design patterns and platform specific best practices, these tools deliver consistent, high quality code. Automatically-generated documentation improves understanding and helps with troubleshooting.<\/p>\n

\u201cIt\u2019s exciting to see BimlFlex customers benefiting from our Azure SQL DW automation experience. We provide optimal implementations that employ patterns approved by industry experts and Microsoft product teams – and can be selected or changed through simple modifications to our metadata store.\u201d<\/i><\/p>\n

\u2013 Scott Currie, CEO, Varigence<\/p>\n

Simplicity<\/b>: Graphical user interface (GUI) with point-and-click design capability offered by most DWA tools, simplify the user experience for source exploration, modelling fact and dimension tables, designing ETL pipelines and reporting.<\/p>\n

Flexibility<\/b>: By shortening iteration cycles, DWA tools help IT and business teams focus on business requirements and reduce the time-to-insight, increasing the business value of data warehousing.<\/p>\n

\u201cAnalytiX DS Epicenter\u2019s metadata driven automation platform allows code to be automatically generated to truly accelerate time to value for customers while automatically documenting the data integration processes in Epicenter\u2019s enterprise data mapping platform\u201d<\/i><\/p>\n

\u2013 Michael Boggs, CTO and Founder of AnalytiX DS<\/p>\n

SQL DW and data warehouse automation partners<\/h2>\n

The following data warehouse automation partners have certified their tools with SQL DW:<\/p>\n

\"biGENiUS_Logo_500x500px_ohne_R<\/a>\"Print\"<\/a>\u00a0\u00a0\u00a0 \u00a0\u00a0 \"image\"<\/a>\u00a0\u00a0\u00a0\u00a0 <\/p>\n

\"image\"<\/a><\/a><\/a><\/p>\n

\u201cWe help data driven companies be more successful with their data management. Azure SQL DW along with our powerful automation approach for designing, generating and deploying analytical solutions enables our customer to get maximum value out of their data. biGENiUS delivers optimized generator leveraging massively parallel processing capabilities of Azure SQL DW.<\/i>\u201d<\/p>\n

\u2013 Gregor Zeiler, Senior Solution Manager, biGENiUS<\/p>\n

\nThe following partners have support for SQL DW coming soon:<\/p>\n

\"image\"<\/a>\u00a0 \"image\"<\/a><\/p>\n

\u201cWe are excited to be providing support for Azure SQL DW in our efforts to align our road-map with our customer\u2019s choice of cloud data warehouse. Dimodelo Architect will speed up the transition, migrate existing data warehouse data, and automate development processes to realize the value from their cloud investment faster.<\/i>\u201d<\/i><\/p>\n

\u2013 Adam Gilmore, Chief Product Officer, Dimodelo Solutions<\/p>\n

\u201cDiscovery Hub by TimeXtender is a modern software platform that allows customers to build, deploy and manage a complete enterprise-grade, analytical architecture. We are pleased to be adding support for Azure DW, to complement our already broad Azure Data Services offering, in our Fall 2018 Discovery Hub release.\u201d<\/em><\/p>\n

\u2013 Heine Krog Iverson, CEO TimeXtender<\/p>\n

Customer testimonials<\/h2>\n

Read what customers have to say about data warehouse automation tools:<\/p>\n

\u201cWe started our cloud journey last year with SQL Data Warehouse to leverage its MPP architecture and the ease of scaling. It is fast becoming the backbone of all our corporate insights. To accelerate the development and to provide consistency across loading packages, we decided to use Varigence’s BimlFlex as it ticked all boxes for our acceptance criteria for loading patterns, technologies and prices. We have currently been using BimlFlex to load our production Azure SQL DW for over six months.\u201d<\/em><\/p>\n

\u2013 Stephen Townsend, Business Intelligence Architect, an energy company<\/p>\n

\u201cWith data warehouse automation, I define structural patterns that I consistently reuse – almost like a library I can import. It allows my team at Ashley to spend less time focusing on building out specific ETL and DW processes in the code and more time collaborating with end user on their business needs.<\/i>\u201d<\/p>\n

\u2013 Phil Haddad, Data Architect, Ashley Furniture<\/p>\n

\u201cAt Smurfit Kappa, we have been using biGENiUS to improve and maintain our reporting system that we have developed significantly over the last ten years. Reduction in development time, simplified loading experience, ease of disparate source addition and traceability are some of the key benefits that we gained from using a data warehouse automation tool.\u201d<\/i><\/p>\n

\u2013 Christian Foucher, Manager BI and Shared Applications, Smurfit Kappa<\/p>\n

\u201cWith AnalytiX DS Enterprise Mapping and Automation platform we were able to reduce overall project duration by close to 25 percent and cost by close to 35 percent. Our deliverable\u2019s have also improved considerably due to fact all development resources now have a common interface to a centralized metadata repository which provides us with complete process, flow and version control capability.\u201d<\/i><\/p>\n

\u2013 Tony Jurek, Practice Principal, DXC Technology<\/p>\n

Get started<\/h2>\n

Get started with data warehouse automation tools by checking out the free product trial or request a demo: AnalytiX DS<\/a>, AnalyticsCreator<\/a>, Varigence<\/a>, WhereScape<\/a>, and biGENiUS<\/a>.<\/p>\n

Learn more about SQL DW<\/a> and stay up-to-date with the latest news by following us on Twitter @AzureSQLDW<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"

Data warehouse automation (DWA) tools are meta-data driven, code generation tools that streamline developing and managing a data warehouse solution.<\/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":[1473,1466],"tags":[],"audience":[3057,3055,3053,3056],"content-type":[1481],"product":[1539],"tech-community":[],"topic":[],"coauthors":[97],"class_list":["post-2723","post","type-post","status-publish","format-standard","hentry","category-databases","category-hybrid-multicloud","audience-data-professionals","audience-developers","audience-it-decision-makers","audience-it-implementors","content-type-thought-leadership","product-azure-sql-database"],"yoast_head":"\nAccelerate your cloud data warehouse with automation tools | Microsoft Azure Blog<\/title>\n<meta name=\"description\" content=\"Data warehouse automation (DWA) tools are meta-data driven, code generation tools that streamline developing and managing a data warehouse solution.\" \/>\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\/accelerate-your-cloud-data-warehouse-with-automation-tools\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Accelerate your cloud data warehouse with automation tools | Microsoft Azure Blog\" \/>\n<meta property=\"og:description\" content=\"Data warehouse automation (DWA) tools are meta-data driven, code generation tools that streamline developing and managing a data warehouse solution.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/azure.microsoft.com\/en-us\/blog\/accelerate-your-cloud-data-warehouse-with-automation-tools\/\" \/>\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-05-14T07:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-07-28T16:43:11+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2018\/05\/5ff3d0a4-5932-4edc-8f67-4064e18c9a6b.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=\"5 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\/accelerate-your-cloud-data-warehouse-with-automation-tools\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/accelerate-your-cloud-data-warehouse-with-automation-tools\/\"},\"author\":[{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/author\/microsoft-azure\/\",\"@type\":\"Person\",\"@name\":\"Microsoft Azure\"}],\"headline\":\"Accelerate your cloud data warehouse with automation tools\",\"datePublished\":\"2018-05-14T07:00:00+00:00\",\"dateModified\":\"2023-07-28T16:43:11+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/accelerate-your-cloud-data-warehouse-with-automation-tools\/\"},\"wordCount\":1033,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/accelerate-your-cloud-data-warehouse-with-automation-tools\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2018\/05\/5ff3d0a4-5932-4edc-8f67-4064e18c9a6b.webp\",\"articleSection\":[\"Databases\",\"Hybrid + multicloud\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/azure.microsoft.com\/en-us\/blog\/accelerate-your-cloud-data-warehouse-with-automation-tools\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/accelerate-your-cloud-data-warehouse-with-automation-tools\/\",\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/accelerate-your-cloud-data-warehouse-with-automation-tools\/\",\"name\":\"Accelerate your cloud data warehouse with automation tools | Microsoft Azure Blog\",\"isPartOf\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/accelerate-your-cloud-data-warehouse-with-automation-tools\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/accelerate-your-cloud-data-warehouse-with-automation-tools\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2018\/05\/5ff3d0a4-5932-4edc-8f67-4064e18c9a6b.webp\",\"datePublished\":\"2018-05-14T07:00:00+00:00\",\"dateModified\":\"2023-07-28T16:43:11+00:00\",\"description\":\"Data warehouse automation (DWA) tools are meta-data driven, code generation tools that streamline developing and managing a data warehouse solution.\",\"breadcrumb\":{\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/accelerate-your-cloud-data-warehouse-with-automation-tools\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/azure.microsoft.com\/en-us\/blog\/accelerate-your-cloud-data-warehouse-with-automation-tools\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/accelerate-your-cloud-data-warehouse-with-automation-tools\/#primaryimage\",\"url\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2018\/05\/5ff3d0a4-5932-4edc-8f67-4064e18c9a6b.webp\",\"contentUrl\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2018\/05\/5ff3d0a4-5932-4edc-8f67-4064e18c9a6b.webp\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/accelerate-your-cloud-data-warehouse-with-automation-tools\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Blog home\",\"item\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Databases\",\"item\":\"https:\/\/azure.microsoft.com\/en-us\/blog\/category\/databases\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Accelerate your cloud data warehouse with automation tools\"}]},{\"@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":"Accelerate your cloud data warehouse with automation tools | Microsoft Azure Blog","description":"Data warehouse automation (DWA) tools are meta-data driven, code generation tools that streamline developing and managing a data warehouse solution.","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\/accelerate-your-cloud-data-warehouse-with-automation-tools\/","og_locale":"en_US","og_type":"article","og_title":"Accelerate your cloud data warehouse with automation tools | Microsoft Azure Blog","og_description":"Data warehouse automation (DWA) tools are meta-data driven, code generation tools that streamline developing and managing a data warehouse solution.","og_url":"https:\/\/azure.microsoft.com\/en-us\/blog\/accelerate-your-cloud-data-warehouse-with-automation-tools\/","og_site_name":"Microsoft Azure Blog","article_publisher":"https:\/\/www.facebook.com\/microsoftazure","article_published_time":"2018-05-14T07:00:00+00:00","article_modified_time":"2023-07-28T16:43:11+00:00","og_image":[{"url":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2018\/05\/5ff3d0a4-5932-4edc-8f67-4064e18c9a6b.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":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/accelerate-your-cloud-data-warehouse-with-automation-tools\/#article","isPartOf":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/accelerate-your-cloud-data-warehouse-with-automation-tools\/"},"author":[{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/author\/microsoft-azure\/","@type":"Person","@name":"Microsoft Azure"}],"headline":"Accelerate your cloud data warehouse with automation tools","datePublished":"2018-05-14T07:00:00+00:00","dateModified":"2023-07-28T16:43:11+00:00","mainEntityOfPage":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/accelerate-your-cloud-data-warehouse-with-automation-tools\/"},"wordCount":1033,"commentCount":0,"publisher":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#organization"},"image":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/accelerate-your-cloud-data-warehouse-with-automation-tools\/#primaryimage"},"thumbnailUrl":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2018\/05\/5ff3d0a4-5932-4edc-8f67-4064e18c9a6b.webp","articleSection":["Databases","Hybrid + multicloud"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/azure.microsoft.com\/en-us\/blog\/accelerate-your-cloud-data-warehouse-with-automation-tools\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/accelerate-your-cloud-data-warehouse-with-automation-tools\/","url":"https:\/\/azure.microsoft.com\/en-us\/blog\/accelerate-your-cloud-data-warehouse-with-automation-tools\/","name":"Accelerate your cloud data warehouse with automation tools | Microsoft Azure Blog","isPartOf":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/accelerate-your-cloud-data-warehouse-with-automation-tools\/#primaryimage"},"image":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/accelerate-your-cloud-data-warehouse-with-automation-tools\/#primaryimage"},"thumbnailUrl":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2018\/05\/5ff3d0a4-5932-4edc-8f67-4064e18c9a6b.webp","datePublished":"2018-05-14T07:00:00+00:00","dateModified":"2023-07-28T16:43:11+00:00","description":"Data warehouse automation (DWA) tools are meta-data driven, code generation tools that streamline developing and managing a data warehouse solution.","breadcrumb":{"@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/accelerate-your-cloud-data-warehouse-with-automation-tools\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/azure.microsoft.com\/en-us\/blog\/accelerate-your-cloud-data-warehouse-with-automation-tools\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/accelerate-your-cloud-data-warehouse-with-automation-tools\/#primaryimage","url":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2018\/05\/5ff3d0a4-5932-4edc-8f67-4064e18c9a6b.webp","contentUrl":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-content\/uploads\/2018\/05\/5ff3d0a4-5932-4edc-8f67-4064e18c9a6b.webp"},{"@type":"BreadcrumbList","@id":"https:\/\/azure.microsoft.com\/en-us\/blog\/accelerate-your-cloud-data-warehouse-with-automation-tools\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog home","item":"https:\/\/azure.microsoft.com\/en-us\/blog\/"},{"@type":"ListItem","position":2,"name":"Databases","item":"https:\/\/azure.microsoft.com\/en-us\/blog\/category\/databases\/"},{"@type":"ListItem","position":3,"name":"Accelerate your cloud data warehouse with automation tools"}]},{"@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\/2723","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=2723"}],"version-history":[{"count":0,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/posts\/2723\/revisions"}],"wp:attachment":[{"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/media?parent=2723"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/categories?post=2723"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/tags?post=2723"},{"taxonomy":"audience","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/audience?post=2723"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/content-type?post=2723"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/product?post=2723"},{"taxonomy":"tech-community","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/tech-community?post=2723"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/topic?post=2723"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/azure.microsoft.com\/en-us\/blog\/wp-json\/wp\/v2\/coauthors?post=2723"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}