How to pass table name from global parameter in adf-CodePudding

Home > Software design > How to pass table name from global parameter in adf

How to pass table name from global parameter in adf

Time：05-31

I need to pass select query in adf for lookup dates My query is working fine

SELECT [LastSuccessWatermarkDate] FROM [dbo].[arddl_WaterMarkCntrl]
WHERE SourceTable = '@{item().entity_name}'

but I want to pass global parameter as tablename instead of [dbo].[arddl_WaterMarkCntrl]

How to proceed?

CodePudding user response：

You can leverage the below logic:

SELECT [LastSuccessWatermarkDate] FROM @{pipeline().globalParameters.TableName}
WHERE SourceTable = '@{item().entity_name}'