ADF UNTIL ACTIVITY || REAL TIME SCENARIO || VERIFY COUNT OF RECORDS ||

In this video we will understand the Privilege's of Using Until Activity in ADF

CREATE TABLE dev.TableMetadata (
TableName NVARCHAR(128),
LastRowCount INT
);

-- Initialize the metadata for your table if not already done
IF NOT EXISTS (SELECT 1 FROM dev.TableMetadata WHERE TableName = 'YourTableName')
BEGIN
INSERT INTO dev.TableMetadata (TableName, LastRowCount)
VALUES ('YourTableName', 0);
END

CREATE PROCEDURE dev.UpdateRowCount
@TableName NVARCHAR(128),
@NewRowCount INT
AS
BEGIN
UPDATE dev.TableMetadata
SET LastRowCount = @NewRowCount
WHERE TableName = @TableName;
END

#databricks
#azuredataengineer
#azuresql
#azuredatafactory
#azuretutorials
#dataengineering
#sql
#pyspark