I am trying to make a monitoring system that collect information from Azure synapse into log analytics and then try to ingest data into Azure database.
I created a log analytics workspace and turn on diagnostic in azure synapse and connect to log analytics workspace but can not find and example on how to run the query
to get the job information pipeline info in log analytics and ingest info to database.
How can I do that? Do you have any example? And how can I save this information into azure sql