Error handling and logging in Azure Synapse data warehouse.

Question

Hello everyone, I was wondering if implementing try-catch logic in user-defined stored procedures is considered a good idea or best practice for handling errors in Synapse DW. Additionally, I would like to know if it is advisable to create table(s) and custom stored procedure(s) for logging purposes within Azure Synapse Data Warehouse during ETL. To provide some context: in SQL Server, ETL developers typically wrap stored procedures with try-catch blocks and use custom stored procedures or logging frameworks to log execution and errors. I am asking this question because I am new to Azure Synapse DW and have been tasked with creating stored procedures. However, the existing ones in the organization lack error handling and logging, and I haven't been able to find examples or discussions about this topic online. Is the approach of using try-catch and logging considered best practice in Azure Synapse DW? Thank you in advance.

Answer 1

Hi @Yamel Peraza

Implementing try catch is the recommended way to capture exception with SQL Server/Synapse analytics/az SQL database Since the try catch construct is the same for all these technologies, you might not see references related to exactly synapse procedures. But all the implemention is similar to that of SQL server. So you may go ahead ahead and implement exception handling/ logging as you have planned. Please let us know for anything else you would like to know.

Thanks.