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
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
Hi Amit_Kar ,
It looks like you have found a solution. Could you please mark this helpful post as “Answered”?
This will help others in the community to easily find a solution if they are experiencing the same problem as you.
Thank you for your cooperation!
Best Regards,
Yang
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!