azure-synapse

Scalefree's dbt package for a Data Vault 2 implementation congruent to the original Data Vault 2 definition by Dan Linstedt including the Staging Area, DV2 main entities, PITs and Snapshot Tables.

A stand-alone test framework that allows to write unit tests for Data Factory pipelines on Microsoft Fabric, Azure Data Factory and Azure Synapse Analytics.

A data discovery and manipulation toolset for unstructured data

PowerShell module to deploy Synapse workspace (and more) in Microsoft Azure.

Data Lineage for Microsoft SQL Server, Azure SQL Server and Azure Synapse

Azure Synapse and SAP SFLIGHT demo application integration scenario

Azure End To End Data Engineering Project

This repo contains "Azure Data Engineer Associate" Questions and related docs.

VS Code extension for visualizing SQL Server database object dependencies from .dacpac files or MS SQL DB import. Interactive graph with trace, search, DDL preview and Copilot support.

Template for using the finnts package on Azure Synapse for scalable time series forecasting within corporate finance.

💻 Migration of On-Prem database to Azure cloud, then transformation and reporting of data

Azure Synapse Notebook Tests

Master Azure Data Engineering with this Basic to Advance guide! Covers SQL, PySpark, Kafka, Databricks, Snowflake & Airflow. Build 15+ industrial projects using Azure (ADF, Synapse, Event Hubs), GCP & modern table formats (Delta Lake, Iceberg, Hudi). Learn real-time streaming, Medallion architecture, and cloud data warehousing with hands-on labs.

Workshop for integrating Dynamics 365 Customer Insights and Azure Data Services

Sample code for analyzing VCF files (converted to Parquet) in Azure Databricks and Synapse.

fabrix - a Python toolkit to evaluate, validate, and debug Azure Data Factory & Microsoft Fabric pipeline expressions with rich tracing.

End-to-end real-time data pipeline using Kafka, Spark, Delta Lake, DuckDB, and Power BI. Simulates clickstream analytics with batch + streaming workflows for modern data engineering.

PS module for auto-creation of firewall rules in Synapse/Sql

Enterprise accelerator that discovers, inventories, assesses, reports, recommends, visualizes, and prepares optimization packs for an Azure Synapse Analytics estate so consultants can plan a practical migration to Microsoft Fabric.

Bachelor thesis on query optimization for Business Intelligence systems. Analysis of ETL, physical design (indexing, partitioning, compression, caching), and materialized views on SQL Server and Azure Synapse. Includes SQL scripts and TPC-DS evaluations.