Hello Jay D,
Welcome to the Microsoft Q&A forum.
You can run the below query to find the session_id of any locks on your table
SELECT * FROM sys.dm_pdw_lock_waits
WHERE object_name in ('your_table')
then you can Kill the session using KILL 'Session_id'
I hope this helps.