In this article, we will explore Azure Synapse Analytics,the which was formerly known as SQL Data Warehouse. Before getting started let’s have an overview of Azure Synapse database.
The Azure Synapse is a limitless analytics service that has been offered by Azure for bringing together enterprise data and big data analytics by using serverless on demand resources at scale. It also brings a unified experience to ingest, prepare, manage and serve data for immediate BI with machine learning needs. The SQL analytics refers to enterprise data warehousing features which are generally available with Azure Synapse.
The Azure synapse has the major four following components:
- SQL analytics (complete T-SQL based analytics)
- Spark: Deeply integrated Apache Spark (Preview)
- Data integration: Hybrid Data Integration (preview) and
- Studio: Unified User Experience (Preview)
Prerequisites
- An Active Azure Login Subscription.
- SQL Management Studio.
Step 1
Login into your
Azure portal and Click >> + new resource and Select >> Databases and Select >> Azure Synapse Analytics (formerly SQL DW)
Step 2
Now let’s get started. We have to fill in some of the required values of our data warehouse name and create a server. For creating a server just Click >> Create new and provide the server name and admin login and password along with selecting the region and Select >> OK and finally Click >> Review + Create and Click >> Create.
Step 3
After completing the deployment process, we have to create a firewall. For that select the databases. We can see the server name in the overview page. Select the server name for connecting to the server and the database.
Step 4
Click >> Firewall settings and from the Firewall settings Select >> Add Client IP for adding a new firewall rule and we will get a notification that the firewall rule has been successfully updated.
Step 5
Now all we have to do is to connect to the server as server admin. For that open SQL management studio and establish a connection to SQL server in Azure.
Just Open SSMS and in the connect to server dialog box provide the required information, such as selecting the server type andname, and providing the authentication name and password that has been given as admin login details and finally Click >> Connect.
Step 6
Now that we have connected with Azure we can proceed with the next steps such as expanding the databases and expanding the database name which has been created for viewing the objects.
Step 7
Now it’s time for querying. Let’s run some queries in it, and for that right click >> the database name and Select >> New Query and execute the following query in the window
SELECT * FROM sys.databases and Click >> Execute and the output will be of two databases such as master and the created database name.
Step 8
Now we can also execute our own queries. I have just executed a sample query for creating employee data and I got the following output on execution.
And when we have completed the work, we can just wrap the data and delete the following resource by clicking >> Delete for deleting the resources.
I hope this article will be useful for you. Thanks for reading!