Forum Discussion
Helper IIGetting error or issue while updating the column in log table in datawarehouse
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!!
Community SupportHi 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!!
Helper IIHi v-sathmakuri
the solution you provided it worked, but the same update statement I have tried in adf it worked there but it's not working in fabric,
1. what is the reason??
2. so do we need to pass the sql statements in script like this always