{"id":22645,"date":"2021-02-24T10:33:17","date_gmt":"2021-02-24T10:33:17","guid":{"rendered":"https:\/\/www.experfy.com\/blog\/azure-synapse-analytics-introduction\/"},"modified":"2023-09-04T17:21:34","modified_gmt":"2023-09-04T17:21:34","slug":"azure-synapse-analytics-introduction","status":"publish","type":"post","link":"https:\/\/www.experfy.com\/blog\/ai-ml\/azure-synapse-analytics-introduction\/","title":{"rendered":"Azure Synapse Analytics\u200a\u2014\u200aIntroduction"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"22645\" class=\"elementor elementor-22645\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t<section class=\"has_eae_slider elementor-section elementor-top-section elementor-element elementor-element-806ad1d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"806ad1d\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"has_eae_slider elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-ffa509b\" data-id=\"ffa509b\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-70808a6 elementor-widget elementor-widget-text-editor\" data-id=\"70808a6\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p class=\"has-medium-font-size\"><em>A brief overview of what, why, and how for Azure Synapse Analytics<\/em><\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-54a5164 elementor-widget elementor-widget-heading\" data-id=\"54a5164\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Introduction<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-5ee8480 elementor-widget elementor-widget-text-editor\" data-id=\"5ee8480\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p id=\"ada0\">Synapse Analytics is an integrated platform service from Microsoft Azure that combines the capabilities of data warehousing, data integrations, ETL pipelines, analytics tools &amp; services, the scale for big-data capabilities, visualization &amp; dashboards.<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0811700 elementor-widget elementor-widget-image\" data-id=\"0811700\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img fetchpriority=\"high\" decoding=\"async\" width=\"1021\" height=\"567\" src=\"https:\/\/www.experfy.com\/blog\/wp-content\/uploads\/2021\/05\/1A55tGy7jyrdQAFqaDk969Q.png\" class=\"attachment-large size-large wp-image-18793\" alt=\"Azure Synapse Analytics\u200a\u2014\u200aIntroduction\" srcset=\"https:\/\/www.experfy.com\/blog\/wp-content\/uploads\/2021\/05\/1A55tGy7jyrdQAFqaDk969Q.png 1021w, https:\/\/www.experfy.com\/blog\/wp-content\/uploads\/2021\/05\/1A55tGy7jyrdQAFqaDk969Q-300x167.png 300w, https:\/\/www.experfy.com\/blog\/wp-content\/uploads\/2021\/05\/1A55tGy7jyrdQAFqaDk969Q-768x426.png 768w, https:\/\/www.experfy.com\/blog\/wp-content\/uploads\/2021\/05\/1A55tGy7jyrdQAFqaDk969Q-610x339.png 610w, https:\/\/www.experfy.com\/blog\/wp-content\/uploads\/2021\/05\/1A55tGy7jyrdQAFqaDk969Q-750x417.png 750w\" sizes=\"(max-width: 1021px) 100vw, 1021px\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\">Microsoft Azure Synapse Analytics Logical Architecture. Credit: Microsoft Azure<\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ac90c4a elementor-widget elementor-widget-text-editor\" data-id=\"ac90c4a\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p id=\"f242\">The platform enables enterprise-wide analytics requirements for decision-making. The tools, processes, and techniques support \u2014 Analytics capabilities across the dimensions:\u00a0<strong><em>Descriptive\u00a0<\/em><\/strong>&amp;<strong>\u00a0<em>Diagnostic Analytics<\/em><\/strong>by leveraging its data-warehouse capabilities whereby gathering business insights with the help of T-SQL queries. It empowers an organization\u2019s decision-making by leveraging\u00a0<strong><em>Predictive<\/em><\/strong>and\u00a0<strong><em>Prescriptive<\/em><\/strong><em>\u00a0Analytics\u00a0<\/em>capabilities using its integration with Apache Spark, Databricks, Stream Analytics.<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2752d82 elementor-widget elementor-widget-heading\" data-id=\"2752d82\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">How it Works<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-73931a3 elementor-widget elementor-widget-heading\" data-id=\"73931a3\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">Azure Synapse Analytics is a one-stop-shop analytics solution that offers the following capabilities:<\/h4>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-750c427 elementor-widget elementor-widget-text-editor\" data-id=\"750c427\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ul>\n<li>The dedicated-poolof SQL Servers<strong>,\u00a0<\/strong>known as,\u00a0<strong>Synapse SQL,\u00a0<\/strong>is the backbone for the entire analytics data storage, these provide the necessary infrastructure for implementing a data warehouse under its hood. Enables engineers to execute T-SQL queries native to their existing experience.<br \/>It also enables empower with the\u00a0<strong><em>serverless<\/em><\/strong>\u00a0model is for unplanned or ad-hoc workloads, by using\u00a0<em>data virtualization\u00a0<\/em>allows unlocking insights from their own data stores without going through the formal processes of setting up a data warehouse.<\/li>\n<li>ETL and data integration capabilities from disparate sources using\u00a0<strong>Synapse Pipelines<\/strong>\u00a0enables the organization to churn the data efficiently for warehousing and analytical purpose. The reusable workflows and Pipeline orchestration capabilities are easy to adapt. The support for big-data compute services such as HDInsight for Hadoop and DataBricks make this a more powerful ETL tool.<\/li>\n<li>Enable the development of big-data workloads and <a href=\"https:\/\/www.experfy.com\/blog\/ai-ml\/a-simple-hands-on-tutorial-of-azure-machine-learning-studio\/\" target=\"_blank\" rel=\"noreferrer noopener\">machine learning solutions<\/a> with\u00a0<strong>Apache Spark<\/strong>\u00a0for Azure Synapse. This platform processes big data workloads by enabling massively scalable high-performance-compute resources. SparkML algorithms and Azure ML integration make it a complete solution for training machine learning workloads.<\/li>\n<li>Deliver real-time operational analytics from operational data sources using\u00a0<strong>Synapse Link<\/strong>.<\/li>\n<\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6f6386a elementor-widget elementor-widget-heading\" data-id=\"6f6386a\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Where it fits?<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d25616c elementor-widget elementor-widget-text-editor\" data-id=\"d25616c\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p id=\"2413\">The most common business use-cases for Azure Synapse Analytics are:<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-509fcc1 elementor-widget elementor-widget-text-editor\" data-id=\"509fcc1\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ul>\n<li><em>Data Warehouse<\/em>: Ability to integrate with various data platforms and services.<\/li>\n<li><em>Descriptive\/Diagnostic Analytics<\/em>: Use T-SQL queries against the Synapse database to perform data exploration and discovery.<\/li>\n<li><em>Realtime Analytics<\/em>: Azure Synapse Link enables integration with disparate operational data sources to implement real-time analytics solutions.<\/li>\n<li><em>Advanced Analytics<\/em>: Uses Azure Databricks to support decision-making by leveraging Azure Databricks.<\/li>\n<li><em>Reporting &amp; Visualization<\/em>: Integrate with PowerBI to empower and enhance business decision-making.<\/li>\n<\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c6849d1 elementor-widget elementor-widget-heading\" data-id=\"c6849d1\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Features Walkthrough<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2e033b6 elementor-widget elementor-widget-text-editor\" data-id=\"2e033b6\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p id=\"8af5\">Assuming that you have already\u00a0<a href=\"https:\/\/docs.microsoft.com\/en-in\/azure\/synapse-analytics\/get-started-create-workspace\" target=\"_blank\" rel=\"noreferrer noopener\"><em>set up and configured<\/em><\/a>\u00a0the Azure Synapse Analytics workspace in your Azure subscription.<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b0d3b85 elementor-widget elementor-widget-image\" data-id=\"b0d3b85\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"1024\" height=\"319\" src=\"https:\/\/www.experfy.com\/blog\/wp-content\/uploads\/2021\/05\/1h4PqH3mKG1EMh5do-akCOA-1024x319.png\" class=\"attachment-large size-large wp-image-18794\" alt=\"Azure Synapse Analytics\u200a\u2014\u200aIntroduction\" srcset=\"https:\/\/www.experfy.com\/blog\/wp-content\/uploads\/2021\/05\/1h4PqH3mKG1EMh5do-akCOA-1024x319.png 1024w, https:\/\/www.experfy.com\/blog\/wp-content\/uploads\/2021\/05\/1h4PqH3mKG1EMh5do-akCOA-300x94.png 300w, https:\/\/www.experfy.com\/blog\/wp-content\/uploads\/2021\/05\/1h4PqH3mKG1EMh5do-akCOA-768x240.png 768w, https:\/\/www.experfy.com\/blog\/wp-content\/uploads\/2021\/05\/1h4PqH3mKG1EMh5do-akCOA-610x190.png 610w, https:\/\/www.experfy.com\/blog\/wp-content\/uploads\/2021\/05\/1h4PqH3mKG1EMh5do-akCOA-750x234.png 750w, https:\/\/www.experfy.com\/blog\/wp-content\/uploads\/2021\/05\/1h4PqH3mKG1EMh5do-akCOA-1140x356.png 1140w, https:\/\/www.experfy.com\/blog\/wp-content\/uploads\/2021\/05\/1h4PqH3mKG1EMh5do-akCOA.png 1510w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\">Synapse Analytics Workspace \u2014\u00a0<em>Credit: MS Azure-Synapse-Analytics Studio<\/em><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3c393fb elementor-widget elementor-widget-text-editor\" data-id=\"3c393fb\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<blockquote class=\"wp-block-quote\">\n<p>Setting up and configuration of Azure Synapse Analytics workspace is beyond the scope of this article. Please look into the references section for more details.<\/p>\n<\/blockquote>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ea77759 elementor-widget elementor-widget-heading\" data-id=\"ea77759\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Load and Analyze Data using Spark<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1a681e5 elementor-widget elementor-widget-text-editor\" data-id=\"1a681e5\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ul>\n<li>From\u00a0<em>Data Hub,\u00a0<\/em>Browse the gallery and the\u00a0<code>covid-tracking<\/code>\u00a0dataset.<\/li>\n<li>Open the new Spark notebook using the dataset as below.<\/li>\n<\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f6dd656 elementor-widget elementor-widget-image\" data-id=\"f6dd656\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"841\" height=\"601\" src=\"https:\/\/www.experfy.com\/blog\/wp-content\/uploads\/2021\/05\/1-KOpJmfUulgoA0e46d8u2g.png\" class=\"attachment-large size-large wp-image-18795\" alt=\"Azure Synapse Analytics\u200a\u2014\u200aIntroduction\" srcset=\"https:\/\/www.experfy.com\/blog\/wp-content\/uploads\/2021\/05\/1-KOpJmfUulgoA0e46d8u2g.png 841w, https:\/\/www.experfy.com\/blog\/wp-content\/uploads\/2021\/05\/1-KOpJmfUulgoA0e46d8u2g-300x214.png 300w, https:\/\/www.experfy.com\/blog\/wp-content\/uploads\/2021\/05\/1-KOpJmfUulgoA0e46d8u2g-768x549.png 768w, https:\/\/www.experfy.com\/blog\/wp-content\/uploads\/2021\/05\/1-KOpJmfUulgoA0e46d8u2g-610x436.png 610w, https:\/\/www.experfy.com\/blog\/wp-content\/uploads\/2021\/05\/1-KOpJmfUulgoA0e46d8u2g-120x86.png 120w, https:\/\/www.experfy.com\/blog\/wp-content\/uploads\/2021\/05\/1-KOpJmfUulgoA0e46d8u2g-350x250.png 350w, https:\/\/www.experfy.com\/blog\/wp-content\/uploads\/2021\/05\/1-KOpJmfUulgoA0e46d8u2g-750x536.png 750w\" sizes=\"(max-width: 841px) 100vw, 841px\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\">Screengrab of a demo \u2014 C<em>reate Spark notebook. Credit: MS Azure-Synapse-Analytics Studio<\/em><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2b978c3 elementor-widget elementor-widget-text-editor\" data-id=\"2b978c3\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ul>\n<li>The notebook contains the following default code, with further capabilities to analyze the dataset using Spark backbone framework:-<\/li>\n<\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-890dd25 elementor-widget elementor-widget-text-editor\" data-id=\"890dd25\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<pre class=\"wp-block-preformatted\">## ---- ##<br \/>df = spark.read.parquet(wasbs_path)<br \/>display(df.limit(10))<\/pre>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-257dc4d elementor-widget elementor-widget-image\" data-id=\"257dc4d\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"489\" src=\"https:\/\/www.experfy.com\/blog\/wp-content\/uploads\/2021\/05\/1Rz-8pTXnp9u0-zKxBNJlgA-1024x489.png\" class=\"attachment-large size-large wp-image-18796\" alt=\"Azure Synapse Analytics\u200a\u2014\u200aIntroduction\" srcset=\"https:\/\/www.experfy.com\/blog\/wp-content\/uploads\/2021\/05\/1Rz-8pTXnp9u0-zKxBNJlgA-1024x489.png 1024w, https:\/\/www.experfy.com\/blog\/wp-content\/uploads\/2021\/05\/1Rz-8pTXnp9u0-zKxBNJlgA-300x143.png 300w, https:\/\/www.experfy.com\/blog\/wp-content\/uploads\/2021\/05\/1Rz-8pTXnp9u0-zKxBNJlgA-768x367.png 768w, https:\/\/www.experfy.com\/blog\/wp-content\/uploads\/2021\/05\/1Rz-8pTXnp9u0-zKxBNJlgA-1536x733.png 1536w, https:\/\/www.experfy.com\/blog\/wp-content\/uploads\/2021\/05\/1Rz-8pTXnp9u0-zKxBNJlgA-610x291.png 610w, https:\/\/www.experfy.com\/blog\/wp-content\/uploads\/2021\/05\/1Rz-8pTXnp9u0-zKxBNJlgA-750x358.png 750w, https:\/\/www.experfy.com\/blog\/wp-content\/uploads\/2021\/05\/1Rz-8pTXnp9u0-zKxBNJlgA-1140x544.png 1140w, https:\/\/www.experfy.com\/blog\/wp-content\/uploads\/2021\/05\/1Rz-8pTXnp9u0-zKxBNJlgA.png 1812w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c19423b elementor-widget elementor-widget-heading\" data-id=\"c19423b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Analyze the Data in Serverless SQL Pool<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7b387e9 elementor-widget elementor-widget-text-editor\" data-id=\"7b387e9\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ul>\n<li>Again, load the sample dataset from the Data Hub, but, this time create a New SQL Script as shown below:<\/li>\n<\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d4f7650 elementor-widget elementor-widget-image\" data-id=\"d4f7650\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"909\" height=\"513\" src=\"https:\/\/www.experfy.com\/blog\/wp-content\/uploads\/2021\/05\/17MVXyYBUwj4_YKI9ls_f-Q.png\" class=\"attachment-large size-large wp-image-18797\" alt=\"Azure Synapse Analytics\u200a\u2014\u200aIntroduction\" srcset=\"https:\/\/www.experfy.com\/blog\/wp-content\/uploads\/2021\/05\/17MVXyYBUwj4_YKI9ls_f-Q.png 909w, https:\/\/www.experfy.com\/blog\/wp-content\/uploads\/2021\/05\/17MVXyYBUwj4_YKI9ls_f-Q-300x169.png 300w, https:\/\/www.experfy.com\/blog\/wp-content\/uploads\/2021\/05\/17MVXyYBUwj4_YKI9ls_f-Q-768x433.png 768w, https:\/\/www.experfy.com\/blog\/wp-content\/uploads\/2021\/05\/17MVXyYBUwj4_YKI9ls_f-Q-610x344.png 610w, https:\/\/www.experfy.com\/blog\/wp-content\/uploads\/2021\/05\/17MVXyYBUwj4_YKI9ls_f-Q-750x423.png 750w\" sizes=\"(max-width: 909px) 100vw, 909px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6053de3 elementor-widget elementor-widget-text-editor\" data-id=\"6053de3\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ul>\n<li>This will give you the free hand script to analyze the data set using native T-SQL queries<\/li>\n<\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-57bec2a elementor-widget elementor-widget-image\" data-id=\"57bec2a\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"574\" src=\"https:\/\/www.experfy.com\/blog\/wp-content\/uploads\/2021\/05\/1yP9TsADW-Irqt95qCK0kYQ-1024x574.png\" class=\"attachment-large size-large wp-image-18798\" alt=\"Azure Synapse Analytics\u200a\u2014\u200aIntroduction\" srcset=\"https:\/\/www.experfy.com\/blog\/wp-content\/uploads\/2021\/05\/1yP9TsADW-Irqt95qCK0kYQ-1024x574.png 1024w, https:\/\/www.experfy.com\/blog\/wp-content\/uploads\/2021\/05\/1yP9TsADW-Irqt95qCK0kYQ-300x168.png 300w, https:\/\/www.experfy.com\/blog\/wp-content\/uploads\/2021\/05\/1yP9TsADW-Irqt95qCK0kYQ-768x430.png 768w, https:\/\/www.experfy.com\/blog\/wp-content\/uploads\/2021\/05\/1yP9TsADW-Irqt95qCK0kYQ-610x342.png 610w, https:\/\/www.experfy.com\/blog\/wp-content\/uploads\/2021\/05\/1yP9TsADW-Irqt95qCK0kYQ-750x420.png 750w, https:\/\/www.experfy.com\/blog\/wp-content\/uploads\/2021\/05\/1yP9TsADW-Irqt95qCK0kYQ-1140x639.png 1140w, https:\/\/www.experfy.com\/blog\/wp-content\/uploads\/2021\/05\/1yP9TsADW-Irqt95qCK0kYQ.png 1439w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\">Screengrab of a demo \u2014\u00a0<em>Analyze dataset using SQL Scripts. Credit: MS AzureSynapse Analytics Studio<\/em><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-afa063d elementor-widget elementor-widget-heading\" data-id=\"afa063d\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Setup and Integrate a Pipeline<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a7a585d elementor-widget elementor-widget-text-editor\" data-id=\"a7a585d\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p id=\"26e2\">This small demo will show to integrate pipeline tasks in Azure Synapse<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6f3ea0d elementor-widget elementor-widget-text-editor\" data-id=\"6f3ea0d\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ul>\n<li>From the\u00a0<strong><em>Integrate\u00a0<\/em><\/strong>hub of the Synapse Analytics Studio select the\u00a0<strong><em>Pipeline.<\/em><\/strong><\/li>\n<\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a380579 elementor-widget elementor-widget-image\" data-id=\"a380579\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"657\" height=\"403\" src=\"https:\/\/www.experfy.com\/blog\/wp-content\/uploads\/2021\/05\/1AzeRrbW03PJeRMlO9z5d0g.png\" class=\"attachment-large size-large wp-image-18799\" alt=\"Azure Synapse Analytics\u200a\u2014\u200aIntroduction\" srcset=\"https:\/\/www.experfy.com\/blog\/wp-content\/uploads\/2021\/05\/1AzeRrbW03PJeRMlO9z5d0g.png 657w, https:\/\/www.experfy.com\/blog\/wp-content\/uploads\/2021\/05\/1AzeRrbW03PJeRMlO9z5d0g-300x184.png 300w, https:\/\/www.experfy.com\/blog\/wp-content\/uploads\/2021\/05\/1AzeRrbW03PJeRMlO9z5d0g-610x374.png 610w\" sizes=\"(max-width: 657px) 100vw, 657px\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\">Screengrab of a demo \u2014 create integration\u00a0<em>Pipeline. Credit: MS AzureSynapse Analytics Studio<\/em><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-332f38d elementor-widget elementor-widget-text-editor\" data-id=\"332f38d\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ul>\n<li>Once the pipeline is instantiated \u2014 you can add workflow\u00a0<strong><em>Activities\u00a0<\/em><\/strong>according to the problem at hand.<\/li>\n<\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a74c69b elementor-widget elementor-widget-image\" data-id=\"a74c69b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"529\" src=\"https:\/\/www.experfy.com\/blog\/wp-content\/uploads\/2021\/05\/1f9ttmIACmvVCUsj7J9VHQQ-1024x529.png\" class=\"attachment-large size-large wp-image-18800\" alt=\"Once the pipeline is instantiated\" srcset=\"https:\/\/www.experfy.com\/blog\/wp-content\/uploads\/2021\/05\/1f9ttmIACmvVCUsj7J9VHQQ-1024x529.png 1024w, https:\/\/www.experfy.com\/blog\/wp-content\/uploads\/2021\/05\/1f9ttmIACmvVCUsj7J9VHQQ-300x155.png 300w, https:\/\/www.experfy.com\/blog\/wp-content\/uploads\/2021\/05\/1f9ttmIACmvVCUsj7J9VHQQ-768x397.png 768w, https:\/\/www.experfy.com\/blog\/wp-content\/uploads\/2021\/05\/1f9ttmIACmvVCUsj7J9VHQQ-610x315.png 610w, https:\/\/www.experfy.com\/blog\/wp-content\/uploads\/2021\/05\/1f9ttmIACmvVCUsj7J9VHQQ-750x388.png 750w, https:\/\/www.experfy.com\/blog\/wp-content\/uploads\/2021\/05\/1f9ttmIACmvVCUsj7J9VHQQ-1140x589.png 1140w, https:\/\/www.experfy.com\/blog\/wp-content\/uploads\/2021\/05\/1f9ttmIACmvVCUsj7J9VHQQ.png 1317w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\">Screengrab of a demo \u2014 setup\u00a0<em>Pipeline activities. Credit: MS Azure Synapse Analytics Studio<\/em><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-72bf5c3 elementor-widget elementor-widget-text-editor\" data-id=\"72bf5c3\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ul>\n<li>You can add\u00a0<em>trigger\u00a0<\/em>conditions to respond to an event or manual execution of the Pipeline workflow. Also, select the\u00a0<strong><em>Monitor hub<\/em><\/strong>, and choose the\u00a0<strong><em>Pipeline runs\u00a0<\/em><\/strong>to monitor any pipeline execution progress.<\/li>\n<\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a001c8c elementor-widget elementor-widget-image\" data-id=\"a001c8c\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"459\" src=\"https:\/\/www.experfy.com\/blog\/wp-content\/uploads\/2021\/05\/1A3Ri0PqM03GpZqpHqqysbw-1024x459.png\" class=\"attachment-large size-large wp-image-18801\" alt=\"select the Monitor hub, and choose the Pipeline runs\" srcset=\"https:\/\/www.experfy.com\/blog\/wp-content\/uploads\/2021\/05\/1A3Ri0PqM03GpZqpHqqysbw-1024x459.png 1024w, https:\/\/www.experfy.com\/blog\/wp-content\/uploads\/2021\/05\/1A3Ri0PqM03GpZqpHqqysbw-300x134.png 300w, https:\/\/www.experfy.com\/blog\/wp-content\/uploads\/2021\/05\/1A3Ri0PqM03GpZqpHqqysbw-768x344.png 768w, https:\/\/www.experfy.com\/blog\/wp-content\/uploads\/2021\/05\/1A3Ri0PqM03GpZqpHqqysbw-1536x688.png 1536w, https:\/\/www.experfy.com\/blog\/wp-content\/uploads\/2021\/05\/1A3Ri0PqM03GpZqpHqqysbw-610x273.png 610w, https:\/\/www.experfy.com\/blog\/wp-content\/uploads\/2021\/05\/1A3Ri0PqM03GpZqpHqqysbw-750x336.png 750w, https:\/\/www.experfy.com\/blog\/wp-content\/uploads\/2021\/05\/1A3Ri0PqM03GpZqpHqqysbw-1140x511.png 1140w, https:\/\/www.experfy.com\/blog\/wp-content\/uploads\/2021\/05\/1A3Ri0PqM03GpZqpHqqysbw.png 1565w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\">Screengrab of a demo \u2014 explore Monitor options of Synapse Studio<em>. Credit: MS Azure Synapse Analytics Studio<\/em><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4e35338 elementor-widget elementor-widget-heading\" data-id=\"4e35338\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Integrate Linked Services<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-eecae2f elementor-widget elementor-widget-text-editor\" data-id=\"eecae2f\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p id=\"69f7\">Use Synapse Analytics Studio to integrate and enable various Linked Services, e.g. Power BI<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-cb37ab7 elementor-widget elementor-widget-text-editor\" data-id=\"cb37ab7\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ul>\n<li>Use\u00a0<strong><em>Manage\u00a0<\/em><\/strong>Hub to see existing\u00a0<strong><em>Linked services<\/em><\/strong><\/li>\n<\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-aceca7a elementor-widget elementor-widget-image\" data-id=\"aceca7a\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"359\" src=\"https:\/\/www.experfy.com\/blog\/wp-content\/uploads\/2021\/05\/1Hf42kGMOULpd1i6FaOHucQ-1024x359.png\" class=\"attachment-large size-large wp-image-18802\" alt=\"Manage Hub to see existing Linked services\" srcset=\"https:\/\/www.experfy.com\/blog\/wp-content\/uploads\/2021\/05\/1Hf42kGMOULpd1i6FaOHucQ-1024x359.png 1024w, https:\/\/www.experfy.com\/blog\/wp-content\/uploads\/2021\/05\/1Hf42kGMOULpd1i6FaOHucQ-300x105.png 300w, https:\/\/www.experfy.com\/blog\/wp-content\/uploads\/2021\/05\/1Hf42kGMOULpd1i6FaOHucQ-768x269.png 768w, https:\/\/www.experfy.com\/blog\/wp-content\/uploads\/2021\/05\/1Hf42kGMOULpd1i6FaOHucQ-1536x538.png 1536w, https:\/\/www.experfy.com\/blog\/wp-content\/uploads\/2021\/05\/1Hf42kGMOULpd1i6FaOHucQ-610x214.png 610w, https:\/\/www.experfy.com\/blog\/wp-content\/uploads\/2021\/05\/1Hf42kGMOULpd1i6FaOHucQ-750x263.png 750w, https:\/\/www.experfy.com\/blog\/wp-content\/uploads\/2021\/05\/1Hf42kGMOULpd1i6FaOHucQ-1140x399.png 1140w, https:\/\/www.experfy.com\/blog\/wp-content\/uploads\/2021\/05\/1Hf42kGMOULpd1i6FaOHucQ.png 1895w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\">Screengrab of a demo \u2014 explore Linked Services of Synapse Studio<em>. Credit: MS Azure Synapse Analytics Studio<\/em><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-bcb438a elementor-widget elementor-widget-text-editor\" data-id=\"bcb438a\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ul>\n<li>Also, create a link to the\u00a0<strong><em>PowerBI\u00a0<\/em><\/strong>workspace to leverage data visualization and reporting.<\/li>\n<\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-623c714 elementor-widget elementor-widget-image\" data-id=\"623c714\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"758\" height=\"834\" src=\"https:\/\/www.experfy.com\/blog\/wp-content\/uploads\/2021\/05\/1ZIz65NH0CGIfJvvOGny2Ew.png\" class=\"attachment-large size-large wp-image-18803\" alt=\"link to the PowerBI workspace\" srcset=\"https:\/\/www.experfy.com\/blog\/wp-content\/uploads\/2021\/05\/1ZIz65NH0CGIfJvvOGny2Ew.png 758w, https:\/\/www.experfy.com\/blog\/wp-content\/uploads\/2021\/05\/1ZIz65NH0CGIfJvvOGny2Ew-273x300.png 273w, https:\/\/www.experfy.com\/blog\/wp-content\/uploads\/2021\/05\/1ZIz65NH0CGIfJvvOGny2Ew-610x671.png 610w, https:\/\/www.experfy.com\/blog\/wp-content\/uploads\/2021\/05\/1ZIz65NH0CGIfJvvOGny2Ew-750x825.png 750w\" sizes=\"(max-width: 758px) 100vw, 758px\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\">Screengrab of a demo \u2014 create and setup Linked Services of Synapse Studio<em>. Credit: MS Azure Synapse Analytics Studio<\/em><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-566595d elementor-widget elementor-widget-heading\" data-id=\"566595d\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Conclusion<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c8c96d1 elementor-widget elementor-widget-text-editor\" data-id=\"c8c96d1\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p id=\"4873\">In this brief introduction of\u00a0<strong><em>Azure Synapse Analytics,\u00a0<\/em><\/strong>I have navigated through the shallow waters to understand the basic functional capabilities of this managed service from Azure.<\/p>\n<p id=\"d82c\">You now understand\u00a0<em>what\u00a0<\/em>is Synapse Analytics,\u00a0<em>why\u00a0<\/em>it is very important to solve optimize organizations&#8217; goals, and very slightly about\u00a0<em>how<\/em>\u00a0its capabilities can be leveraged for various analytical use-case.<\/p>\n<p id=\"4ee2\">Hope you have gained some insights, do let me know about your feedback and queries.<\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Synapse Analytics is an integrated platform service from Microsoft Azure that combines the capabilities of data warehousing, data integrations, ETL pipelines, analytics tools &#038; services, the scale for big-data capabilities, visualization &#038; dashboards.<\/p>\n","protected":false},"author":1067,"featured_media":18804,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"content-type":"","footnotes":""},"categories":[183],"tags":[120,1360,122,92,1055],"ppma_author":[3852],"class_list":["post-22645","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-ai-ml","tag-analytics","tag-azure","tag-big-data","tag-machine-learning","tag-warehouses"],"authors":[{"term_id":3852,"user_id":1067,"is_guest":0,"slug":"pankaj-jainani","display_name":"Pankaj Jainani","avatar_url":"https:\/\/www.experfy.com\/blog\/wp-content\/uploads\/2021\/05\/Pankaj-Jainani-150x150.jpeg","user_url":"https:\/\/www.mphasis.com\/","last_name":"Jainani","first_name":"Pankaj","job_title":"","description":"Pankaj Jainani  is Solution Architect for Artificial Intelligence &amp; Microsoft Azure at Mphasis."}],"_links":{"self":[{"href":"https:\/\/www.experfy.com\/blog\/wp-json\/wp\/v2\/posts\/22645","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.experfy.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.experfy.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.experfy.com\/blog\/wp-json\/wp\/v2\/users\/1067"}],"replies":[{"embeddable":true,"href":"https:\/\/www.experfy.com\/blog\/wp-json\/wp\/v2\/comments?post=22645"}],"version-history":[{"count":5,"href":"https:\/\/www.experfy.com\/blog\/wp-json\/wp\/v2\/posts\/22645\/revisions"}],"predecessor-version":[{"id":32121,"href":"https:\/\/www.experfy.com\/blog\/wp-json\/wp\/v2\/posts\/22645\/revisions\/32121"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.experfy.com\/blog\/wp-json\/wp\/v2\/media\/18804"}],"wp:attachment":[{"href":"https:\/\/www.experfy.com\/blog\/wp-json\/wp\/v2\/media?parent=22645"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.experfy.com\/blog\/wp-json\/wp\/v2\/categories?post=22645"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.experfy.com\/blog\/wp-json\/wp\/v2\/tags?post=22645"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.experfy.com\/blog\/wp-json\/wp\/v2\/ppma_author?post=22645"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}