Transforming Data from a Blob Storage File
I recently had a Power Automate Flow challenge where I wanted to access and transform my data. Sounds like a simple task, but it took me a while to figure out t
I recently had a Power Automate Flow challenge where I wanted to access and transform my data. Sounds like a simple task, but it took me a while to figure out the solution…
My data was generated by Azure Synapse and stored in an Azure Blob Storage. As you can see, each record is stored as JSON in a single row:
- Azure Blob Storage
- Transform and Parse
- Summary
What ist Azure Blog Storage
Microsoft Azure Blob storage is a cloud-based storage service that is designed for storing large amounts of unstructured data, such as text or binary data. It is part of the Azure Storage service, which also includes Azure Queue storage for message queuing and Azure Table storage for structured data storage.
Blob storage is especially useful for storing data that does not fit well into a traditional relational database, such as images, audio files, and video files. It can also be used for storing large amounts of text data, such as log files or CSV files.
One of the key features of Azure Blob storage is that it is highly scalable, allowing you to store and retrieve large amounts of data quickly and efficiently. It is also highly available, with multiple replicas of data stored across multiple regions to ensure that your data is always accessible.
You can access Azure Blob storage using a variety of tools and libraries, including the Azure Storage REST APIs, the Azure Storage .NET library, and the Azure Storage Explorer tool. You can also use Azure Blob storage with other Azure services, such as Azure Functions and Azure Stream Analytics, to build powerful cloud-based applications and solutions.
https://azure.microsoft.com/en-us/products/storage/blobs/
What is Azure Synapse Analytics
Azure Synapse is an enterprise analytics service that accelerates time to insight across data warehouses and big data systems.
https://docs.microsoft.com/en-us/azure/synapse-analytics/overview-what-is
Azure Synapse Analytics
Azure Synapse Analytics is a limitless analytics service that brings together data integration, enterprise data warehousing, and big data analytics. It gives you the freedom to query data on your terms, using either serverless or dedicated options—at scale….
https://azure.microsoft.com/en-us/services/synapse-analytics/
Azure Synapse Analytics
Azure Synapse is a limitless analytics service that brings together enterprise data warehousing and Big Data analytics. It gives you the freedom to query data on your terms, using either serverless or dedicated resources—at scale.
https://docs.microsoft.com/en-us/azure/synapse-analytics/
Find more about Data Analytics on hubsite365.com: