Table of contents
1.
Introduction
2.
Classification of data:
2.1.
Structured data
2.2.
Semi-Structured data
2.3.
Unstructured data
3.
Data Formats Supported by Azure Synapse
3.1.
Data compression formats
4.
Frequently Asked Questions
4.1.
What is Azure?
4.2.
What is Azure Data Factory?
4.3.
What are azure datasets?
5.
Conclusion
Last Updated: Mar 27, 2024

Data Formats in Azure

Author Harsh
0 upvote
Career growth poll
Do you think IIT Guwahati certified course can help you in your career?

Introduction

Everything that is stored on our computer is data. Data is of different types like numbers, text, images, etc. Different formats of data are used to represent different types of entities. 

This blog will show different types of data formats available in azure.
So let’s get started.

Logo

Classification of data:

In Azure, we can classify data as structured, semi-structured, and unstructured. Let’s discuss all three of them one by one.

Structured data

As structured data follows a fixed schema, all of the data in it has the same fields or attributes. For structured data entities, tabular forms are most commonly used.

For instance, tabular data representations for the Student entities are shown in the following image.

Structured data

Structured data Example

Semi-Structured data

Semi-structured data is data that has some structure but allows for some variation between entity instances. For example, some students may have an email account, but others may not have one at all.

JSON ( JavaScript Object Notation ) is the most widely used semi-structured data format. JSON is one of many formats for defining semi-structured data.

 

Semi-structured data

Semi-structured data Example

Unstructured data

Documents, images, music, videos, and binary files are the type of data that don’t follow the same structure every time. So, these data types cannot be classified as structured or semi-structured. Unstructured data is the name given to this type of data.

Unstructured data

Unstructured data Example

Data Formats Supported by Azure Synapse

The table below shows all of the available data formats supported by azure synapse.

Supported data formats

These are all the data formats available in azure.

Data compression formats

Data files can be compressed and saved. In the azure synapse, there are two different compression formats that we can use. They are as follows:

Compression types

For example, if we have a CSV file with the “NinjaFiles” name, then “NinjaFiles.csv.zip” indicates that the file is formatted as CSV, and the compression format that is used is zip.

Frequently Asked Questions

What is Azure?

Microsoft Azure (previously Windows Azure) is the company's public cloud computing platform. Many cloud services such as computing, analytics, storage, and networking are offered by Microsoft Azure. Users can select from these services to develop and expand new applications in the public cloud or to run existing apps.
 

What is Azure Data Factory?

Azure Data Factory is a cloud-based, serverless data integration tool and platform for developing ETL and ELT pipelines. It helps in the creation of data-driven workflows for the planning and execution of large-scale data migration and transformation projects.
 

What are azure datasets?

Datasets are used to identify data in linked data storage, such as SQL tables, files, folders, and documents. An Azure Storage connected service, for example, connects a storage account to a data factory.
 

Conclusion

In this article, we have extensively discussed the data formats available in azure. There are different data formats available and we have discussed each one of them. We have also discussed data formats available for compression.

If you think this blog has helped you enhance your knowledge about the data formats that are available in Azure, and if you would like to learn more, check out our articles Azure IoT HubAzure Synapse SQLAzure Content Delivery NetworkAzure PolicyAzure VPN Gateway, and many more on our Website.

Refer to our Guided Path on Coding Ninjas Studio to upskill yourself in Data Structures and AlgorithmsCompetitive ProgrammingJavaScriptSystem Design, and many more! If you have just started your learning process and are looking for questions from tech giants like Amazon, Microsoft, Uber, etc., you must look at the problemsinterview experiences, and interview bundle for placement preparations.

Please upvote our blog to help other ninjas grow.

Happy Learning!

Live masterclass