Today I Learned
GitHubTwitterBlog
Search…
Today I Learned
dotnet
NuGet
Accessing Tor .onion URLs via HttpClient with .NET6
Installing .NET 5.0 on Raspberry Pi 4
Quickly check C# compiler and language version
Disable diagnostic analyzers for entire folder/submodules
Persisting output files from source generators
Use C# 9 records in non-net5.0 projects
AsyncLocal never leaks and is safe for CallContext-like state
Using HashCode in .NETFramework
How to locate dotnet
testing
Conditional unit tests
Skip tagged scenarios in SpecFlow with Xunit
msbuild
Modifying the build for every solution in a repository
Detect CI builds for every CI system
Modify all command-line builds in entire repo
Write entire XML fragments in MSBuild with XmlPoke
How to select first item in an ItemGroup
How to include commit URL in nuget package description
How to include package reference files in your nuget
How to build project when content files change
azure
How to launch multiple Azure Functions apps on different ports
C# script function apps beyond Azure portal
Publishing function app from GitHub folder
Exploring Azure Data with Kusto and Dashboards
Shared secret authorization with Azure SignalR Service
Using Azure File Copy from DevOps yaml pipeline
Code-less redirection with serverless Azure Functions
DevOps/CI/CD
How to run Azure Storage unit tests in CI
How to skip steps or jobs in GitHub Actions for PRs from forks
Update version and publish npm from GH
Push to protected branch from GitHub actions
Powered By GitBook
Exploring Azure Data with Kusto and Dashboards
In order to more effectively learn Kusto (the query language powering Azure analytics, log querying and PowerBI) and data visualization capabilites in Azure, I did the following:
  1. 1.
    ​Created a cluster and database (this takes quite a while)
  2. 2.
    Open the Azure Data Explorer (a.k.a. Kusto Web Explorer) at https://aka.ms/kwe​
  3. 3.
    Add the cluster with the full URI or alternatively just the name.region parts (i.e. kzukusto.centralus vs https://kzukusto.centralus.kusto.windows.net)
  4. 4.
    Optionally add an arbitrary Application Insights app as a "virtual cluster", using a url with the format https://ade.applicationinsights.io/subscriptions/<id>/resourcegroups/<name>/providers/microsoft.insights/components/<ai-app-name>
  5. 5.
    Right--lick database and select Ingest new data
    ​
    ​
  6. 6.
    Find some interesting Azure Open Dataset from the catalog that has an Azure storage URL readily available from the Azure Open Datasets catalog, such as the Bing COVID-19 Data (I used the .jsonl link). NOTE: the .json one will not properly infer schema because it has a root object of type array. The .jsonl is actually a "JSON fragment" (if that even exists, would be the equivalent of an XML fragment) where each entry is just a JSON entry/line in the file.
    ​
    ​
    The JSON version is preferable to .csv because it properly infer the data type for columns.
  7. 7.
    Click on Dashboards for the new stuff here. Parameters driven by queries are particularly handy:
Query-driven multi-select parameter for widget
While editing the query/widget, if the parameter is used in the query, you can interactively change its value to explore the visualizations. For example:
Used parameter becomes enabled for selection
Whereas if it wasn't used:
Unused parameter unavailable
After shaping the Resultsthe way you want, clicking the Visual tab allows configuring a bunch of visualizations. Inference works quite nicely if the data/results are filtered to just what you want to display.
Many chart options and inference that works great
azure - Previous
Publishing function app from GitHub folder
Next - azure
Shared secret authorization with Azure SignalR Service
Last modified 1mo ago
Copy link