Error Message Logging in SQL Table

sonal_18
sonal_18 Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered, Frontrunner 2022 Participant Posts: 12 ✭✭✭✭

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?

Answers

  • Alexandru
    Alexandru Dataiker, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 1,226 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.

Setup Info
    Tags
      Help me…