CODEWITHSUNDEEP
azureazure-data-factory
Patterson
Patterson

Reputation: 2827

Modify Azure Data Factory Expression to include an Alias

I once received assistance converting the following T-SQL code to Azure Data Factory expression.

The T-SQL is:

SELECT
  deltaTable.*
FROM dbo.deltaTable
LEFT OUTER JOIN dbo.targetTable
  ON deltaTable.signature = targetTable.signature
WHERE targetTable.signature IS NULL

The pipeline expression is:

@concat('SELECT ',pipeline().parameters.DeltaTable,'.* FROM ',pipeline().parameters.tempdb,'.',pipeline().parameters.Domain,'.',pipeline().parameters.DeltaTable,' LEFT OUTER JOIN ',pipeline().parameters.tempdb,'.',pipeline().parameters.Domain,'.',pipeline().parameters.TableName,' ON ',pipeline().parameters.DeltaTable,'.signature = ',pipeline().parameters.TableName,'.signature WHERE ',pipeline().parameters.TableName,'.signature IS NULL')

Can someone help further the modify the Azure Data Factory expression for the following T-SQL code:

SELECT 
    DeltaTable.*
FROM dlt.DeltaTable
LEFT OUTER JOIN dbo.TableName AS tgt
    ON dlt.DeltaTable.signature = tgt.signature
WHERE tgt.signature IS NULL;

Upvotes: 0

Views: 25

Answers (0)

Related Questions