Forum Discussion

ramankr48's avatar
ramankr48
Icon for Helper II rankHelper II
1 year ago
Solved

Getting error or issue while updating the column in log table in datawarehouse

Hi Team,   I have deigned a pipeline where iam running store procedure then updating the pipeline status into the table using script activity, but it's not changing, I have tried different method, ...
Need Help
Pipeline
  • v-sathmakuri's avatar
    v-sathmakuri
    1 year ago

    Hi ramankr48 ,

     

    Thank you for reaching out to Microsoft Fabric Community.

     

    please use the below script in the expression builder to update the Pipeline_Metadata_Log table with success status for the current run id.

     

    @{concat('UPDATE Pipeline_Metadata_Log SET Status = ''Success'' WHERE PipelineRunId= ''', pipeline().RunId, '''')}

     

    If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

     

    Thank you!!

v-sathmakuri's avatar
v-sathmakuri
Icon for Community Support rankCommunity Support
1 year ago

Hi ramankr48 ,

 

Thank you for reaching out to Microsoft Fabric Community.

 

please use the below script in the expression builder to update the Pipeline_Metadata_Log table with success status for the current run id.

 

@{concat('UPDATE Pipeline_Metadata_Log SET Status = ''Success'' WHERE PipelineRunId= ''', pipeline().RunId, '''')}

 

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

 

Thank you!!

NandanHegde's avatar
NandanHegde
Icon for Super User rankSuper User
1 year ago

This can be done without the concat as well as stated below wherein replace == with =