{"id":28149,"date":"2020-12-24T11:50:20","date_gmt":"2020-12-24T11:50:20","guid":{"rendered":"https:\/\/www.testpreptraining.com\/tutorial\/?page_id=28149"},"modified":"2020-12-24T11:50:22","modified_gmt":"2020-12-24T11:50:22","slug":"implement-polybase","status":"publish","type":"page","link":"https:\/\/www.testpreptraining.ai\/tutorial\/implement-polybase\/","title":{"rendered":"Implement PolyBase"},"content":{"rendered":"\n<p><a href=\"https:\/\/www.testpreptraining.ai\/tutorial\/exam-dp-200-implementing-an-azure-data-solution\/\" target=\"_blank\" rel=\"noreferrer noopener\">Go back to DP-200 Tutorials<\/a><\/p>\n\n\n\n<p>In this we will talk about PolyBase to load the WideWorldImportersDW data warehouse from Azure Blob storage to your data warehouse in Azure Synapse Analytics SQL pool. <\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Create a blank data warehouse in SQL pool<\/strong><\/h4>\n\n\n\n<p>A SQL pool is created with a defined set of compute resources. The SQL pool is created within an Azure resource group and in a logical SQL server.<\/p>\n\n\n\n<p><strong>Follow these steps to create a blank SQL pool.<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Firstly, select Create a resource in the the Azure portal.<\/li><li>Secondly, select Databases from the New page, and select Azure Synapse Analytics under Featured on the New page.<\/li><li>Thirdly, fill out the Project Details section with the following information:<\/li><\/ul>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"750\" height=\"130\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/12\/source-15-750x130.png\" alt=\"Implement PolyBase\" class=\"wp-image-28186\" srcset=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/12\/source-15-750x130.png 750w, https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/12\/source-15.png 910w\" sizes=\"auto, (max-width: 750px) 100vw, 750px\" \/><figcaption>Image Source: Microsoft<\/figcaption><\/figure><\/div>\n\n\n\n<ul class=\"wp-block-list\"><li>Next, under SQL pool details, provide a name for your SQL pool. Next, either select an existing server from the drop down, or select Create new under the Server settings to create a new server. Fill out the form with the following information:<\/li><\/ul>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"622\" height=\"400\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/12\/source-16-622x400.png\" alt=\"Implement PolyBase\" class=\"wp-image-28187\" srcset=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/12\/source-16-622x400.png 622w, https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/12\/source-16.png 902w\" sizes=\"auto, (max-width: 622px) 100vw, 622px\" \/><figcaption>Image Source: Microsoft<\/figcaption><\/figure><\/div>\n\n\n\n<ul class=\"wp-block-list\"><li>After that, select performance level. The slider by default is set to DW1000c. Move the slider up and down to choose the desired performance scale.<\/li><li>Then, on the Additional Settings page, set the Use existing data to None, and leave the Collation at the default of SQL_Latin1_General_CP1_CI_AS.<\/li><li>Lastly, select Review + create to review your settings, and then select Create to create your data warehouse. You can monitor your progress by opening the deployment in progress page from the Notifications menu.<\/li><\/ul>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><a href=\"https:\/\/www.testpreptraining.ai\/implementing-an-azure-data-solution-dp-200-free-practice-test\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" width=\"961\" height=\"150\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/08\/dp-200-pracice-tests-1.png\" alt=\"DP-200 practice tests\" class=\"wp-image-18535\" srcset=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/08\/dp-200-pracice-tests-1.png 961w, https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/08\/dp-200-pracice-tests-1-750x117.png 750w\" sizes=\"auto, (max-width: 961px) 100vw, 961px\" \/><\/a><\/figure><\/div>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Create a server-level firewall rule<\/strong><\/h4>\n\n\n\n<p>The Azure Synapse Analytics service creates a firewall at the server-level that prevents external applications and tools from connecting to the server or any databases on the server. To enable connectivity, you can add firewall rules that enable connectivity for specific IP addresses. <\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Firstly, after the deployment completes, search for your pool name in the search box in the navigation menu, and select the SQL pool resource. Select the server name.<\/li><li>Secondly, select the server name. <\/li><li>Thirdly, select Show firewall settings. The Firewall settings page for the server opens.<\/li><li>Then, on the Firewalls and virtual networks page, select Add client IP to add your current IP address to a new firewall rule. A firewall rule can open port 1433 for a single IP address or a range of IP addresses.<\/li><li>Lastly, select Save. A server-level firewall rule is created for your current IP address opening port 1433 on the server.<\/li><\/ul>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Connect to the server as server admin<\/strong><\/h4>\n\n\n\n<p>This section uses SQL Server Management Studio (SSMS) to establish a connection to your server.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Firstly, open SQL Server Management Studio.<\/li><li>Secondly, in the Connect to Server dialog box, enter the following information:<\/li><\/ul>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"750\" height=\"347\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/12\/source-17-750x347.png\" alt=\"server dialog box\" class=\"wp-image-28190\" srcset=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/12\/source-17-750x347.png 750w, https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/12\/source-17.png 919w\" sizes=\"auto, (max-width: 750px) 100vw, 750px\" \/><figcaption>Image Source: Microsoft<\/figcaption><\/figure><\/div>\n\n\n\n<ul class=\"wp-block-list\"><li>Then, click Connect. The Object Explorer window opens in SSMS.<\/li><li>Next, in Object Explorer, expand Databases. Then expand System databases and master to view the objects in the master database. Expand SampleDW to view the objects in your new database.<\/li><\/ul>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Create a user for loading data<\/strong><\/h4>\n\n\n\n<p>The server admin account is meant to perform management operations, and is not suited for running queries on user data. Loading data is a memory-intensive operation. Memory maximums are defined according to the Generation of SQL pool you&#8217;re using, data warehouse units, and resource class.<\/p>\n\n\n\n<p>Since you are currently connected as the server admin, you can create logins and users. Use these steps to create a login and user called LoaderRC60. Then assign the user to the staticrc60 resource class.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Firstly, in SSMS, right-click master to show a drop-down menu, and choose New Query. A new query window opens.<\/li><li>Secondly, In the query window, enter these T-SQL commands to create a login and user named LoaderRC60, substituting your own password for &#8216;a123STRONGpassword!&#8217;.<\/li><\/ul>\n\n\n\n<p><strong>SQL<\/strong><br><em>CREATE LOGIN LoaderRC60 WITH PASSWORD = &#8216;a123STRONGpassword!&#8217;;<br>CREATE USER LoaderRC60 FOR LOGIN LoaderRC60;<\/em><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Then, click Execute.<\/li><li>After that, right-click SampleDW, and choose New Query. A new query Window opens.<\/li><li>Next, enter the following T-SQL commands to create a database user named LoaderRC60 for the LoaderRC60 login. The second line grants the new user CONTROL permissions on the new data warehouse. The third line adds the new user as a member of the staticrc60 resource class.<\/li><\/ul>\n\n\n\n<p><strong>SQL<\/strong><br><em>CREATE USER LoaderRC60 FOR LOGIN LoaderRC60;<br>GRANT CONTROL ON DATABASE::[SampleDW] to LoaderRC60;<br>EXEC sp_addrolemember &#8216;staticrc60&#8217;, &#8216;LoaderRC60&#8217;;<\/em><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Lastly, click Execute.<\/li><\/ul>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><a href=\"https:\/\/www.testpreptraining.ai\/implementing-an-azure-data-solution-dp-200-practice-exam\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" width=\"961\" height=\"150\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/08\/dp-200-online-course-1.png\" alt=\"Implement PolyBase DP-200 Online course\" class=\"wp-image-18534\" srcset=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/08\/dp-200-online-course-1.png 961w, https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/08\/dp-200-online-course-1-750x117.png 750w\" sizes=\"auto, (max-width: 961px) 100vw, 961px\" \/><\/a><\/figure><\/div>\n\n\n\n<p class=\"has-text-align-right\"><strong>Reference: <\/strong><a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/synapse-analytics\/sql-data-warehouse\/load-data-wideworldimportersdw\" target=\"_blank\" rel=\"noreferrer noopener\">Microsoft Documentation<\/a><\/p>\n\n\n\n<p><a href=\"https:\/\/www.testpreptraining.ai\/tutorial\/exam-dp-200-implementing-an-azure-data-solution\/\" target=\"_blank\" rel=\"noreferrer noopener\">Go back to DP-200 Tutorials<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Go back to DP-200 Tutorials In this we will talk about PolyBase to load the WideWorldImportersDW data warehouse from Azure Blob storage to your data warehouse in Azure Synapse Analytics SQL pool. Create a blank data warehouse in SQL pool A SQL pool is created with a defined set of compute resources. The SQL pool&#8230;<\/p>\n","protected":false},"author":2,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"footnotes":""},"categories":[],"tags":[],"class_list":["post-28149","page","type-page","status-publish","hentry"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Implement PolyBase - Testprep Training Online Tutorials<\/title>\n<meta name=\"description\" content=\"Enhance your skills and knowledge by learning about Implementing PolyBase using Microsoft DP-200 online course and Practice Exam Now!\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.testpreptraining.ai\/tutorial\/implement-polybase\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Implement PolyBase - Testprep Training Online Tutorials\" \/>\n<meta property=\"og:description\" content=\"Enhance your skills and knowledge by learning about Implementing PolyBase using Microsoft DP-200 online course and Practice Exam Now!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.testpreptraining.ai\/tutorial\/implement-polybase\/\" \/>\n<meta property=\"og:site_name\" content=\"Testprep Training Tutorials\" \/>\n<meta property=\"article:modified_time\" content=\"2020-12-24T11:50:22+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/12\/source-15-750x130.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/implement-polybase\/\",\"url\":\"https:\/\/www.testpreptraining.ai\/tutorial\/implement-polybase\/\",\"name\":\"Implement PolyBase - Testprep Training Online Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#website\"},\"datePublished\":\"2020-12-24T11:50:20+00:00\",\"dateModified\":\"2020-12-24T11:50:22+00:00\",\"description\":\"Enhance your skills and knowledge by learning about Implementing PolyBase using Microsoft DP-200 online course and Practice Exam Now!\",\"breadcrumb\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/implement-polybase\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.testpreptraining.ai\/tutorial\/implement-polybase\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/implement-polybase\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.testpreptraining.ai\/tutorial\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Implement PolyBase\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#website\",\"url\":\"https:\/\/www.testpreptraining.ai\/tutorial\/\",\"name\":\"Testprep Training Tutorials\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.testpreptraining.ai\/tutorial\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#organization\",\"name\":\"Testprep Training\",\"url\":\"https:\/\/www.testpreptraining.ai\/tutorial\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png\",\"contentUrl\":\"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png\",\"width\":583,\"height\":153,\"caption\":\"Testprep Training\"},\"image\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Implement PolyBase - Testprep Training Online Tutorials","description":"Enhance your skills and knowledge by learning about Implementing PolyBase using Microsoft DP-200 online course and Practice Exam Now!","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:\/\/www.testpreptraining.ai\/tutorial\/implement-polybase\/","og_locale":"en_US","og_type":"article","og_title":"Implement PolyBase - Testprep Training Online Tutorials","og_description":"Enhance your skills and knowledge by learning about Implementing PolyBase using Microsoft DP-200 online course and Practice Exam Now!","og_url":"https:\/\/www.testpreptraining.ai\/tutorial\/implement-polybase\/","og_site_name":"Testprep Training Tutorials","article_modified_time":"2020-12-24T11:50:22+00:00","og_image":[{"url":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/12\/source-15-750x130.png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/implement-polybase\/","url":"https:\/\/www.testpreptraining.ai\/tutorial\/implement-polybase\/","name":"Implement PolyBase - Testprep Training Online Tutorials","isPartOf":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#website"},"datePublished":"2020-12-24T11:50:20+00:00","dateModified":"2020-12-24T11:50:22+00:00","description":"Enhance your skills and knowledge by learning about Implementing PolyBase using Microsoft DP-200 online course and Practice Exam Now!","breadcrumb":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/implement-polybase\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.testpreptraining.ai\/tutorial\/implement-polybase\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/implement-polybase\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.testpreptraining.ai\/tutorial\/"},{"@type":"ListItem","position":2,"name":"Implement PolyBase"}]},{"@type":"WebSite","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#website","url":"https:\/\/www.testpreptraining.ai\/tutorial\/","name":"Testprep Training Tutorials","description":"","publisher":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.testpreptraining.ai\/tutorial\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#organization","name":"Testprep Training","url":"https:\/\/www.testpreptraining.ai\/tutorial\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/","url":"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png","contentUrl":"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png","width":583,"height":153,"caption":"Testprep Training"},"image":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/28149","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/comments?post=28149"}],"version-history":[{"count":7,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/28149\/revisions"}],"predecessor-version":[{"id":28224,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/28149\/revisions\/28224"}],"wp:attachment":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/media?parent=28149"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/categories?post=28149"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/tags?post=28149"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}