In databases, we often find columns that are stored in a hierarchy structure, not unlike a file path on your drive. For example, in the Microsoft Logs sample database the
Perftable stores its counter path this way:
It would be helpful to have a way to easily break this path out into its individual parts. KQL provides us a way of doing this using the
Check out examples of how you can perform splitting.