Here is a link to an article on efficiently querying azure diagnostics table.
The key piece of information is that the partitionkey is “0” + log capture time in ticks.
Query Azure Diagnostics Effectively
Random outpourings of a software developer
Developer Rants 