Error Message Logging in SQL Table

sonal_18
Level 1
Error Message Logging in SQL Table

Hi All,

I am building a Dataiku scenario for logging where it will build the dataset and insert the audit log status in a SQL Table. I want to store the error message as well in the SQL table for the failed scenarios. Is there a way to do this? How can i get a dynamic error message for each scenario build?

0 Kudos
1 Reply
AlexT
Dataiker

Hi,

You could use a Reporter in the scenario to send to an SQL dataset. The steps would be

1) Create a new managed dataset +Dataset - Internal - Managed Dataset - Select the SQL connection. 

Screenshot 2021-09-27 at 15.28.32.png

2) Edit the schema to include the time column and any other columns in this example my second column is "text"which and increased the size to 65000 ( from default 1000)

Screenshot 2021-09-27 at 15.36.32.png

3) Creat the reporter for the scenario run :

Screenshot 2021-09-27 at 15.27.18.png

Let me know if this is what you are looking for. 

 

0 Kudos