Use Azure Logic Apps to import data into Azure SQL Database from Azure Blob Storage

 Use Azure Logic Apps to import data into Azure SQL Database from Azure Blob Storage

This article will show Azure Automation for Import data into Azure SQL Database from Azure Blob Storage container using Azure Logic Apps.

ntroduction

In the first part of the article, Automate data loading from email attachments using Azure Logic Apps, we implemented the following tasks using the Azure Logic Apps.

  • Upload the file into Azure Storage container once you get a new email having an Inbox attachment with a specific subject
  • Sends a confirmation email once the file is uploaded to a storage container
  • It marks an email as read

In the 2nd part of the article, we automatically upload this CSV file into Azure SQL Database. To integrate the Azure database with the storage container, we need to generate a shared access signature.

Configuration of Shared Access Signature

Shared Access Signature (SAS) is a way to grant limited access to resources in the Azure Storage account. You do not require to share the access keys with your client applications. You get the granular control such as

  • Which Object?
  • What permissions?
  • How long?

You can also specify specific IP addresses, protocols, and permissions for the storage account resources. Azure supports the following types of shared access signatures.

  • User delegation SAS
  • Service SAS
  • Account SAS

To configure the SAS, navigate to your storage account and search for Shared Access Signature. On this page, you have the following configurations.

  • Allowed permissions: Available options are Read, Write, Delete, List, Add,** Create, **Update, Process
  • Blob versioning permissions: You can give permissions to delete versions by selecting the option – Enable deletion of versions
  • Start and expiry date/time: You can set the expiry date of the permissions. After the expiry date, you cannot access the storage container resources. You can also select your suitable time zone from the drop-down list
  • Allowed IP address: If you want to restrict access to a specific IP address or address range, specify in the text box of the Allowed IP address
  • Allowed protocols: By default, it allows only HTTPS protocol; however, you can allow HTTP and HTTPS traffic

azure sql azure azure automation

What is Geek Coin

What is GeekCash, Geek Token

Best Visual Studio Code Themes of 2021

Bootstrap 5 Tutorial - Bootstrap 5 Crash Course for Beginners

Nest.JS Tutorial for Beginners

Hello Vue 3: A First Look at Vue 3 and the Composition API

Introduction to Structured Query Language SQL pdf

SQL stands for Structured Query Language. SQL is a scripting language expected to store, control, and inquiry information put away in social databases. The main manifestation of SQL showed up in 1974, when a gathering in IBM built up the principal model of a social database. The primary business social database was discharged by Relational Software later turning out to be Oracle.

How to set up Azure Data Sync between Azure SQL databases and on-premises SQL Server

In this article, you learn how to set up Azure Data Sync services. In addition, you will also learn how to create and set up a data sync group between Azure SQL database and on-premises SQL Server.

Azure Automation: Automate Azure SQL Database indexes and statistics maintenance

This article will show how to automate Azure SQL Database index and statistics maintenance.

Demo: Configure Azure SQL with Azure CLI | Azure SQL for beginners (Ep. 17)

In this video, see how to configure your Azure SQL connectivity leveraging the Azure CLI and PowerShell notebooks in Azure Data Studio. For the full Azure SQ...

Azure Automation: Create database copies of Azure SQL Database

This article will describe Azure Automation to create a database copy of an Azure SQL Database.