In this post, we will see how to resolve Azure Databricks Delta Live Table stored as SCD 2 is creating new records when no data changes Question: I have a streaming pipeline that ingests json files from a data lake. ...

In this post, we will see how to resolve How to make non-sequential ranges unique? Question: I am strugling with some T-SQL code to get column [Num] (in below example table). Basically, I am trying to create an index on ...