Azure Synapse Analytics(workspace preview) creation step-by-step

In this post, I'll walk through creation of Azure Synapse Analytics(workspace preview) through Azure UI. And here is my earlier post link where I walked through the Azure Synapse Analytics(formerly SQL DW).


Okay, lets start on the creation process. Search 'Azure Synapse' on creation search box and then click on Azure Synapse Analytics(workspace preview). And then follow the steps and click on create.


Once the Synapse Analytics gets created, go to the resource and land on the home overview page. This is looks like below. Overview page holds all major information. Note, SQL Server and default DB creation is part of the creation process. So, you will have the information about DB server and other details.


Click on Open under 'Open Synapse Studio' box land you on the Synapse workspace. 

This could be pretty familiar t you if you worked with Azure Data Factory. On the extreme left navigation, you have Home, DB, Pipeline, Monitoring etc icon which are same as Azure Data factory (ADF) UI.


Clicking on the DB icon, you can check the existing database/server there and actually you can create a new database just running a handy SQL as below.


Once DB creation completes, simply browse the Azure UI just like you do with SQL Management Studio. You can click your custom table clicking on External tables. You can run handy SQL for table creation there.


Similar ADF way we can build the pipeline here. I'm not going in details on how to create a pipeline and dataflow in this post. I'll come up in a future post.


And on the monitoring icon(second from the bottom), allow you to monitor what are the activities happening/happened through Synapse. Very simple and easy to learn. Enjoy Azure Synapse!

Comments

Post a Comment

Popular posts from this blog

How to fix Azure DevOps error MSB4126

Image
Setting up build and release pipeline always tedious and we face many build related issues. Here is one common error I face couple of times while setting app Web or windows apps in Azure DevOps After placing the code in repos, and creating the build pipeline and run it, you can face the following error ##[error]D:\a\8\s\<your solution file>.sln.metaproj(0,0): Error MSB4126: The specified solution configuration "release|$(BuildPlatform)" is invalid. Please specify a valid solution configuration using the Configuration and Platform properties (e.g. MSBuild.exe Solution.sln /p:Configuration=Debug /p:Platform="Any CPU") or leave those properties blank to use the default solution configuration. To understand what is target platform defined in your project you need to visit or open the solution(.sln) file and review the following sections. In my case, this has been defined as x86 as target platform.                   GlobalSecti
Read more

SharePoint Admin Center

Image
 SharePoint Admin Center allows you to view your organization's SharePoint site including communication sites, channel sites, and sites that belong to Microsoft 365 group. This is same like Site Admin in earlier days of SharePoint versions. You can search organizational site, sort them or filter sites the way you want. Easy way to find and apply/change site settings. Under Policies, click on Sharing - This will allow you to create rules/ set control sharing at the organization level in SharePoint and OneDrive Here, in this page, you can apply settings to restrict how users are allowed to access content in SharePoint and OneDrive. Term store, the word getting populated from SharePoint 2010. You can feed metadata of metadata information of your organization level, program level, project level in Term store. helps your organization's knowledge better.  AI soon will play a vital role here and using AI, you can acyually find collect and process and finally yoour organization's d
Read more

How to create Custom Visuals in Power BI – Initial few Steps

Image
This post will help you to know the steps to create custom visuals in PowerBI. Microsoft defined them as well at https://docs.microsoft.com/en-us/power-bi/service-custom-visuals-getting-started-with-developer-tools . First things first, and you need to download and install NodeJS , in case if you do not have npm setup in your machine.  Second step is to run couple of npm commands to install Power BI Visual Tools and create & publish the cert. Finally, create your own package and upload with the help of npm. 1.       npm install -g powerbi-visuals-tools 2.       pbiviz --create-cert pbiviz --install-cert 3.       pbiviz new My Visual name – This will create the file under the name of your visual file. 4.      pbiviz start – You need to go to the folder where your custom visual  resides, and run this command. You can change a few things in your pbiviz.json file, like author, display name, icon, style etc. Finally, package your
Read more