ADF UNTIL ACTIVITY || REAL TIME SCENARIO || VERIFY COUNT OF RECORDS ||
Vložit
- čas přidán 7. 09. 2024
- 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
Highly underrated channel and need more videos