Azure Synapse Analytics – Automation Activity

On this article, we’ll find out about automation job, particularly about emailing the billing particulars on a month-to-month foundation or as per the consumer’s selection for the sources we use for Azure Synapse Analytics. This lesson can nevertheless be used to know in regards to the billing quantity for specified time length for multitudes of sources and providers utilized in Azure.   

Azure Synapse Analytics 

Azure Synapse is a limitless enterprise analytics service that permits us to get perception from knowledge analytics and knowledge warehousing. Utilizing devoted sources or serverless structure, knowledge could be queried and offers scalability as per the rise within the measurement of the information. You possibly can be taught extra about it within the earlier article, Azure Synapse Analytics.  

Information Warehouse 

Information Warehouse could be understood as a core a part of enterprise intelligence which allows knowledge evaluation and reporting and are principally the main repository that consists of knowledge which can be built-in from totally different disparate sources. The limitless chance of knowledge mining begins with Information Warehousing.  

This text is part of the Azure Synapse Analytics Articles Sequence. You possibly can try different articles within the collection from the next hyperlinks. 

1. Azure Synapse Analytics    
2. Azure Synapse Analytics – Create Devoted SQL Pool    
3. Azure Synapse Analytics – Creating Firewall at Server-level    
4. Azure Synapse Analytics – Join, Question and Delete Information Warehouse SQL Pool    
5. Azure Synapse Analytics – Load Dataset to Warehouse from Azure Blob Storage    
6. Azure Synapse Analytics – Finest Practices to Load Information into SQL Pool Information Warehouse   
7. Azure Synapse Analytics – Restore Level  
8. Azure Synapse Analytics – Exploring Question Editor 
9. Azure Synapse Analytics – Automation Activity 

Automation Activity  

Automation Activity in Azure refers back to the logic app useful resource with a workflow which begins with set off. We all know that billing and metering are based mostly on the set off for various motion executions within the logic app workflow. This can be utilized to supply ourselves with Billing particulars for the utilization of various sources in Azure with the consumption pricing mannequin.  

Allow us to be taught to create our automation job for the providers we used. Right here in our case, Azure Synapse Analytics.  

Step 1 

Go to the Azure Portal. Now, create a useful resource similar to a SQL pool and discover with some queries.  

Step 2 

Discover the SQL Pool we created utilizing following the Azure Synapse Analytics – Create Devoted SQL Pool.  

Step 3 

On the SQL pool useful resource web page, click on on Duties below Automation. It will take you to the Duties web page.  

Step 4 

Now, Click on on Add Activity or the Add a job button on the Menu.  

Step 5 

Now, you’ll be taken to the Template Choice Web page. Right here, we’re going to automate the month-to-month billing price for the useful resource of Azure Synapse Analytics.  

Click on on Choose below Ship month-to-month price for useful resource.  

Step 6 

Now, we’ll be forwarded to Authenticate web page. Right here, we will see the providers listed – the Azure Useful resource Supervisor and Workplace 365 Outlook.  

Allow us to select Workplace 365 Outlook and Click on on Create.  

Step 7 

We’ll be taken to Sign up to create connection with out electronic mail account.  

Click on on Sign up.  

Now you can choose the e-mail account you need to obtain the month-to-month automated emails to.  

Step 8 

Now, we will see, the Workplace 365 Outlook account has now been linked. 

Step 9 

Choose the Azure Useful resource Supervisor now and Click on on Create.  

Step 10  

Now, we’ll be taken to Configure web page. Identify the Activity Identify as per your Want. I’ve named it as Billing and added my electronic mail id.  

Step 11 

Now, because the check in connection is profitable, we will see, the Related Inexperienced Tick bars in Standing.  

Now, click on on Evaluate + Create. 

Step 12 

Now, we’ll be taken to Evaluate + Create Web page. Right here, the Logic App can be in course of to be created for our Billing. Click on on Create.  

Step 13 

Now, because the automation job is created, we’re notified of the method.  

As the duty is created, we’ll now be robotically emailed about our month-to-month billing to our electronic mail id that we added for the sources we used – right here in our case the SQL Pool Information Warehouse.  

Conclusion 

Thus, on this article, we discovered to create an automation job to electronic mail us about our month-to-month bills for useful resource utilization. The automation job can carry out different providers identical to billing. Furthermore, the billing could be carried out and scheduled for the time restrict as we select to from weekly, month-to-month, and so forth.