{"repo":"NeilMacMullen/kusto-loco","free":true,"listed":false,"github":"https://github.com/NeilMacMullen/kusto-loco","clone":"git clone https://github.com/NeilMacMullen/kusto-loco.git","description":"C# KQL query engine with flexible I/O layers and visualization","language":"C#","stars":140,"topics":["charting","data-mining","data-visualization","kql","kusto"],"license":"MIT","category":"analytics","readme_excerpt":"If you are using this project please give it a :star: to show your appreciation - thanks! Feel free to drop over the Kusto-Loco discord server if you have questions or feedback. Kusto-Loco Kusto-Loco is a set of libraries and applications based around the Kusto Query Language (KQL). KQL is normally used against data held in Azure Data Explorer but Kusto-Loco allows you to query in-memory data held in your own applications. For a super-quick introduction to KQL see this wiki page but to give you a flavour here's a simple query that calculates the average rating of all PCs in a product table and renders the results as a chart. Kusto-Loco makes it easy to load data from CSV, JSON or Parquet files or from sets of POCOs held in memory. Query results can be serialised back to files or objects or rendered to HTML charts using the Vega-Lite charting library. Loading data, running a query and rendering the results to a chart can be done in a few lines of code after referencing the appropriate Nuget Packages. If you just want to get started playing around with KQL on your own file-based data you can use the supplied LokqlDX cross-platform application. Kusto-Loco even comes with a Powershell module that allows you use KQL queries in a Powershell pipeline. Quick Starts - For application developers who want to consume the libraries - LokqlDX - a simple data explorer for local files - Lokql - a command line version of lokqldx, suitable for automation or quick tasks - Powershell integration","default_branch":null,"files":null,"tree":[],"storefront":"/r/NeilMacMullen","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/NeilMacMullen/kusto-loco/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}