How to initiate tables lock for stored procedure in Azure Synapse Analytics?

Currently, I encountered an issue on Azure Synapse Analytics. I have a parent_cust_industry table which is full refresh – The table loads using stored procedure as below: CREATE PROCEDURE [trans_globalreference_edw_tedw].[parent_cust_industry_proc] @pipeline_name VARCHAR(100), @pipeline_run_id VARCHAR(100), @pipeline_trigger_name VARCHAR(100), @pipeline_trigger_id VARCHAR(100), @pipeline_trigger_type VARCHAR(100), @pipeline_trigger_date_time_utc DATETIME2 AS BEGIN TRY — LOAD TYPE: Full refresh IF EXISTS (SELECT 1 FROM … Read more