I would like to use a KQL script to automate the weekly tracking of my synapse workspace cost usage.

So far I have tried using Logs Analytics workspace to query the tables but I’m getting only the _isBillable data and _Billedsize from the tables.
This is a screenshot of my tables available, im not sure which to use

Open to other suggestions on how to do this