Forum Discussion
Advocate IDebugging Warehouse deployment errors
Hi Yang,
I have not managed to raise a support ticket for the overall issue of "lack of avenues to debug pipeline deployment errors", but I have now found that any procs with CTAS statements in them need to be dropped in the target before deployment. I am using CTAS statements to fill the gap due to lack of temp tables in fabric. So , we need to add this to the list of checks prior to triggering a pipeline deployment.
Cheers,
Amit
Advocate IThanks FabianSchut . I dont think that is the issue here. The reason being the fact when I deleted the target warehouse and redeployed, it deployed fine. I could do that now as we are still in development phase and a complete no go when we go live. I will check out the link that you have posted and see if it provides some extra details on the error.
Cheers,
AK
Helper IIYou can check this Amit. I hope it helps.
Find all deployment related issues with their creative solutions here. I tested and implemented all of them. Hope it helps.