Azure-docs: How do you tell Log Analytics not to cast properties into types?

Created on 19 Aug 2019  Â·  8Comments  Â·  Source: MicrosoftDocs/azure-docs

I have property which looks like GUID but instead it's actually I want to be used as string. Currently LogAnalytics casts it automatically to GUID and changes column name to gave _g


Document Details

⚠ Do not edit this section. It is required for docs.microsoft.com ➟ GitHub issue linking.

Pri2 assigned-to-author log-analyticsvc product-question triaged

Most helpful comment

so, no solution for this? why closed?

All 8 comments

@artisticcheese Thanks for the question! We're investigating this and will get back to you shortly.

@bwren can you please provide your insights on this?

Checking with engineering team on this. #in-process

GUID values are actually being stored as a string, just adding a _g instead of _s. You can verify this with a simple query MyTable_CL | getschema. I'll add a note to the article.

Well that's exact thing I'm trying to avoid. I don't want my string values to be separated into different columns. Good example if I log events from Virtual Machines and put virtual machines in column called VM_Name, now if Virtual Machine happen to have name which looks like GUID it will go into VM_Name_g which I don't want to happen.

I'll pass the issue on to the engineering team, but I don't know of any current way to change this behavior.

please-close

so, no solution for this? why closed?

Was this page helpful?
0 / 5 - 0 ratings