CODEWITHSUNDEEP
azure-data-factory
Patterson
Patterson

Reputation: 2823

Azure Data Factory Unable to locate table on Source Side

I have converted the following T-SQL code into an Azure Data factory expression.

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

The Azure Data factory copy activity expression generated from above T-SQL code is as follows:

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

However, when I execute the copy activity I get the error: No Table name

enter image description here

Any thoughts on why I'm getting the error?

Upvotes: 0

Views: 10

Answers (0)

Related Questions