@yairofek wrote:
Hey,
In order to create more meaningful monitoring or usage or few platformic jobs I am using I need to be able to access the job_parameters object of jon runs.
While job_parameters exists in system.workflow.job_run_timeline table, it is not populated for most job runs, even if they have parameters.
The data is saved somewhere as it does exist in the UI.
Can you please advise how to get the full object, preferably is sql, so I could complete my dashboards?
Hello!
To access the full job_parameters object for job runs in the system.workflow.job_run_timeline table, you can use SQL queries to join this table with other relevant tables that might contain the missing data. Identify related tables that store job parameters or related information, then use SQL JOIN operations to combine data from these tables and extract the necessary fields to reconstruct the full job_parameters object. For example, you can join the job_run_timeline table with the job_parameters table on the job_run_id field and filter for a specific job ID. This approach helps in completing your dashboards with the required information.
