Browsed by
Category: SQL Server

Dataset Synapse to Fabric
Load data from Synapse to Fabric

Load data from Synapse to Fabric

Comments 0 Comment

In this short post, we will cover how to load data from Synapse to Fabric or from Azure Data Factory using Sznapse/ADF pipelines. Note that at the time of writing this post the feature to load data from Synapse to Fabric is still in preview.Note that loading data from Synapse to Fabric using Synapse notebooks was already feasible, but these notebooks don’t natively support connections to on-premise SQL databases. Why loading data from Synapse to Fabric In the best world,…

Read More Read More

Populating Time Dimension

Populating Time Dimension

Comments 1 Comment

A ready-made script that I have modified to create and populate a Kimball Time dimension. This script will create a time dimension and populate it with different levels of granularity: second, minute, hour.