Steps to Configure VNet Peering 

🔗 How to Configure VNet Peering for Azure Data Factory and Oracle Integration This guide walks you through securely connecting Azure Data Factory (ADF) to an Oracle Virtual Machine hosted in a different Virtual Network. By setting up VNet Peering and configuring a Managed Virtual Network Integration Runtime (IR), you can enable private, secure data … Read more

Microsoft Fabric Readiness Review

Microsoft Fabric is designed to integrate multiple analytics workloads, including data engineering, data science, and business intelligence, within a unified platform. While our current Medallion structure already has a logical progression of data refinement (Bronze → Silver → Gold), there are key differences in architecture, tooling, and approach that we might consider while emulating a … Read more

Renewing the SAS Token

Security Reminder Keep your SAS URL secure! Avoid sharing it with unauthorised individuals, as anyone with the link can perform the permitted actions. Impact of Expiry: The SAS token will expire on the se date in the URL (e.g., se=2024-10-22T18:23:02Z). If your SAS token expires before renewal: To prevent disruptions, ensure you renew your token … Read more

Understanding the SAS URL

A SAS (Shared Access Signature) URL provides secure delegated access to resources in an Azure Storage account. The SAS URL you’ve shared grants specific permissions (like read, write, or delete) over a defined period. Here’s a guide on how to use it: Key Components of the SAS URL: Security Reminder Keep your SAS URL secure! … Read more

Using a SAS (Shared Access Signature) URL to attach Azure Container

Security Reminder Keep your SAS URL secure! Avoid sharing it with unauthorised individuals, as anyone with the link can perform the permitted actions. Renewing the SAS Token Install Azure Storage Explorer Connect to Azure Storage A SAS (Shared Access Signature) URL provides secure, delegated access to resources in an Azure Storage account. The SAS URL … Read more

An Overview of the Snapshot Pipeline

Objective: The Snapshot pipeline aims to streamline data analysis and management by creating optimised views from raw data files. Process Overview: Loading parquet files and Delta lake table Creation: View Creation API Access and loading into the data warehouse Conclusion: The Snapshot pipeline offers an efficient solution for transforming raw data into actionable insights. By … Read more

AzUnzipEverything

https://github.com/FBoucher/AzUnzipEverything A simple Azure Function to Unzip files from a blob storage container to another one The following features are supported in this current version: Supported Archive Types: .zip, .rarArchive support is currently implemented using the sharpcompress library Password protetected zip filesThe current solution provisions an Azure KeyVault instance for storing the zip archive(s) password used during … Read more