I want to automate the cost tracking of my synapse workspace on a weekly basis.
I plan to use a KQL script in Logs analytics workspace to do this.
These are the tables available
Ive checked each table and filtered out the data by isBillable and billsize but I cant find the actual cost.
Im honestly not sure how to do this.
Is there a better way.