Blogs

Move data from MariaDB to Azure blob using python

INTRODUCTION:

  • Generally, we will prefer to store data in the cloud, Azure is one of the best cloud platforms to store data. In this blog, I explain how to copy data from Maria DB to Azure blob using python.
  • Maria DB is an open-source database that is made up of an original MYSQL developer.
  • Azure is a cloud platform which includes IAAS, SAAS, PAAS services used for analytics, storage purpose, networking, etc.
  • The Azure storage account used to store data, text files, images, pdf’s, can be used for replying to queries of message processing.
  • Azure Storage account is of 4 types (Azure blob,Azure tableAzure file,and Azure queue). Azure blob stores data in an unstructured format.

Fig1: Data copy from Maria DB to Azure Blob

  • We are going to store the data created in Maria DB as a text file in Azure Blob.

PREREQUISITES:

  1. Python
  2. Maria DB
  3. Azure Account
  • As we are going to store data in Azure Blob, we need to create an Azure storage account.

STEPS TO CREATE STORAGE ACCOUNT IN AZURE:

  • STEP 1: Log into Azure Account
  • STEP 2: Click on Storage Account on the Home page and click on “Add” to create a new storage account.
  • STEP 3: Create a storage account as shown below and click on the Create button.
  • STEP 4: Now open the storage account created and click on the container

STEP 5: Now click on Add to add a new container that stores data in the blob.

STEPS TO MOVE DATA FROM MARIA DB TO AZURE BLOB:

  • STEP 1: Create a table in Maria DB as below:
  • STEP 2: Execute below Python code to retrieve the tables from Maria DB.
  • Packages to install while connecting to Maria DB:

pip install mariadb

  • STEP 3: Execute the below Python code to move the data from the table created in Maria DB to Azure BLOB.
  • Package to install while connecting to Azure Blob:
  • pip install Azure-storage-blob==2.1.0

STEP 4: By executing the above code text file will be created in Azure blob as shown below, db.txt is the file got created:

  • By following the above steps we can move easily data from Maria DB to Azure Blob using python.
  • Purpose of the article – To migrate data from Maria DB to Cloud
  • Intended Audience – Who are migrating data from Maria DB to Cloud

Contact for further details:

Sahithi Bandaru
EPM Analytics Senior Analyst
MOURI Tech

Leave A Comment

Related Post

WordPress REST APIs

Purpose of the Article: To Learn about WordPress Rest APIs Intended Audience: PHP Developers Tools and Technology: WordPress Keywords: WordPress Rest API What Is API?

Read More »

Secure Browsing

Purpose of the Article: How to Browse the Internet safely? Intended Audience: Whoever uses the Internet. Tools and Technology: Cyber Security Keywords: Cyber Security, Data

Read More »