Download To Desktop Mac

Download Microsoft Remote Desktop for macOS 10.14 or later and enjoy it on your Mac. ‎Use Microsoft Remote Desktop for Mac to connect to a remote PC or virtual apps and desktops made available by your admin. WhatsApp Messenger: More than 2 billion people in over 180 countries use WhatsApp to stay in touch with friends and family, anytime and anywhere. WhatsApp is free and offers simple, secure, reliable messaging and calling, available on phones all over the world. AnyDesk for Mac provides the features and tools you need to connect with desktops or servers in any location. Our remote desktop app ensures a stable, secure, and super-fast connection. It can be individually tailored to your specific operations, thanks to flexible license models. Set up is quick and simple. Hang out with your friends on our desktop app and keep the conversation going on mobile. Download iOS Download. Android Download. Windows Download. Feeling experimental? Try our Public Test Build and test new features before.

-->

Kusto.Explorer is a rich desktop application that enables you to explore your data using the Kusto Query Language in an easy-to-use user interface. This overview explains how to get started with setting up your Kusto.Explorer and explains the user interface you will use.

With Kusto.Explorer, you can:

  • Query your data.
  • Search your data across tables.
  • Visualize your data in a wide variety of graphs.
  • Share queries and results by email or using deep links.
Drive

Installing Kusto.Explorer

  • Download and install the Kusto.Explorer tool from:

    • https://aka.ms/ke (CDN location)
    • https://aka.ms/ke-mirror (Non-CDN location)
  • Instead, access your Kusto cluster with your browser at:https://<your_cluster>.<region>.kusto.windows.net.Replace <your_cluster> and <region> with your Azure Data Explorer cluster name and deployment region.

Using Chrome and Kusto.Explorer

If you use Chrome as your default browser, make sure to install the ClickOnce extension for Chrome:

Overview of the user interface

The Kusto.Explorer user interface is designed with a layout based on tabs and panels, similar to that of other Microsoft products:

  1. Navigate through the tabs on the menu panel to perform various operations
  2. Manage your connections in the connections panel
  3. Create scripts to run in the script panel
  4. View the results of the scripts in the results panel

Menu panel

Kusto.Explorer Menu panel includes the following tabs:

Home tab

The Home tab shows the most recently used functions, divided into sections:

Query section

MenuBehavior
Mode dropdown
  • Query mode: Switches Query Window into a script mode. Commands can be loaded and saved as scripts (default)
  • Search mode: A single query mode where each command entered is processed immediately and presents a result in the Result Window
  • Search++ mode: Allows searching for a term using search syntax across one or more tables. Learn more about using Search++ Mode
New TabOpens a new tab for querying Kusto

Share section

MenuBehavior
Data To ClipboardExports Query and data set to a clipboard. If a chart is presented, it exports the chart as bitmap
Result To ClipboardExports the data set to a clipboard. If a chart is presented, it exports the chart as bitmap
Query to ClipboardExports the Query to a clipboard

Visualizations section

MenuBehavior
Area chartDisplays an area chart in which the X-axis is the first column (must be numeric). All numeric columns are mapped to different series (Y-axis)
Column ChartDisplays a column chart where all numeric columns are mapped to different series (Y-axis). The text column before numeric is the X-axis (can be controlled in the UI)
Bar ChartDisplays a bar chart where all numeric columns are mapped to different series (X-axis). The text column before numeric is the Y-axis (can be controlled in the UI)
Stacked Area chartDisplays a stacked area chart in which the X-axis is the first column (must be numeric). All numeric columns are mapped to different series (Y-axis)
Timeline ChartDisplays a time chart in which the X-axis is the first column (must be datetime). All numeric columns are mapped to different series (Y-axis).
Line ChartDisplays a line chart in which the X-axis is the first column (must be numeric). All numeric columns are mapped to different series (Y-axis).
Anomaly ChartSimilar to timechart, but finds anomalies in time series data, using the machine learning anomalies algorithm. For anomaly detection, Kusto.Explorer uses the series_decompose_anomalies function.
Pie ChartDisplays a pie chart in which the color-axis is the first column. The theta-axis (must be a measure, converted to percent) is the second column.
Time LadderDisplays a ladder chart in which the X-axis is the last two columns (must be datetime). The Y-axis is a composite of the other columns.
Scatter ChartDisplays a point graph in which the X-axis is the first column (must be numeric). All numeric columns are mapped to different series (Y-axis).
Pivot ChartDisplays a pivot table and pivot chart that gives the full flexibility of selecting data, columns, rows, and various chart types.
Time PivotInteractive navigation over the events time-line (pivoting on time axis)

Note

Anomaly Chart:The algorithm expects timeseries data, which consists of two columns:

  • Time in fixed interval buckets
  • Numeric value for anomaly detectionTo produce timeseries data in Kusto.Explorer, summarize by the time field and specify the time bucket bin.
Download To Desktop Mac

View section

MenuBehavior
Full View ModeMaximizes the work space by hiding the ribbon menu and Connection Panel. Exit Full View Mode by selecting Home > Full View Mode, or by pressing F11.
Hide Empty ColumnsRemoves empty columns from the data grid
Collapse Singular ColumnsCollapses columns with singular values
Explore Column ValuesShows column values distribution
Increase FontIncreases the font size of the query tab and of the results data grid
Decrease FontDecreases the font size of the query tab and of the results data grid

Note

Data View Settings:

Kusto.Explorer keeps track of what settings are used per unique set of columns. When columns are reordered or removed, the data view is saved and will be reused whenever the data with the same columns is retrieved. To reset the view to its defaults, in the View tab, select Reset View.

File tab

MenuBehavior
---------Query Script---------
New TabOpens a new tab window for querying Kusto
Open FileLoads data from a *.kql file to the active script panel
Save To FileSaves the content of the active script panel to *.kql file
Close TabCloses the current tab window
---------Save Data---------
Data To CSVExports data to a CSV (comma-separated-values) file
Data To JSONExports data to a JSON formatted file
Data To ExcelExports data to an XLSX (Excel) file
Data To TextExports data to a TXT (text) file
Data To KQL ScriptExports Query to a script file
Data To ResultsExports Query and data to a Results (QRES) file
Run Query Into CSVRuns a query and saves the results to a local CSV file
---------Load Data---------
From ResultsLoads Query and data from a Results (QRES) file
---------Clipboard---------
Query and Results To ClipboardExports Query and data set to a clipboard. If a chart is presented, it exports the chart as a bitmap
Result To ClipboardExports data set to a clipboard. If a chart is presented, it exports the chart as a bitmap
Query to ClipboardExports the Query to a clipboard
---------Results---------
Clear results cacheClears cached results of previously executed queries

Connections tab

MenuBehavior
---------Groups---------
Add GroupAdds a new Kusto Server group
Rename GroupRenames the existing Kusto Server group
Remove GroupRemoves the existing Kusto Server group
---------Clusters---------
Import ConnectionsImports connections from a file specifying connections
Export ConnectionsExports connections to a file
Add ConnectionAdds a new Kusto Server connection
Edit ConnectionOpens a dialog for Kusto Server connection properties editing
Remove ConnectionRemoves the existing connection to Kusto Server
RefreshRefreshes properties of a Kusto server connection
---------Security---------
Inspect Your ADD PrincipalShows currents active user details
Sign-out From AADSigns-out the current user from the connection to AAD
---------Data Scope---------
Caching scope
  • Hot DataExecute queries only on hot data cache
  • All Data: Execute queries on all available data (default)
DateTime ColumnName of column which may be used for time pre-filter
Time FilterValue of time pre-filter

View tab

MenuBehavior
---------Appearance---------
Full View ModeMaximizes the work space by hiding the ribbon menu and Connection Panel
Increase FontIncreases the font size of the query tab and of the results data grid
Decrease FontDecreases the font size of the query tab and of the results data grid
Reset LayoutResets the layout of the tool's docking controls and windows
Rename Document TabRename the selected tab
---------Data View---------
Reset ViewResets data view settings to its defaults
Explore Column ValuesShows column values distribution
Focus on Query StatisticsChanges the focus to query statistics instead of query results upon query completion
Hide DuplicatesToggles removal of the duplicate rows from the query results
Hide Empty ColumnsToggles removal of empty columns from the query results
Collapse Singular ColumnsToggles collapsing columns with singular value
---------Data Filtering---------
Filter Rows In SearchToggles the option to show only matching rows in query results search (Ctrl+F)
---------Visualizations---------
VisualizationsSee Visualizations, above.

Note

Kusto.Explorer keeps track of the settings used per unique set of columns. When columns are reordered or removed, the data view is saved and will be reused whenever the data with the same columns is retrieved. To reset the view to its defaults, in the View tab, select Reset View.

Download to desktop mac os

Tools tab

Desktop
MenuBehavior
---------IntelliSense---------
Enable IntelliSenseEnables and disables IntelliSense on the Script Panel
---------Analyze---------
Query AnalyzerLaunches the Query Analyzer tool
Query CheckerAnalyzes the current query and outputs a set of applicable improvement recommendations
CalculatorLaunches the calculator
---------Analytics---------
Analytical ReportsOpens a dashboard with multiple pre-built reports for data analysis
---------Translate---------
Query to Power BITranslates a query to a format suitable for using in Power BI
---------Options---------
Reset OptionsSets application settings to default values
OptionsOpens a tool for configuring application settings. Learn more about Kusto.Explorer options.

Monitoring tab

MenuBehavior
---------Monitor---------
Cluster DiagnosticsShows a health summary for the Server Group currently selected in Connections Panel
Latest data: All tablesShows a summary of the latest data in all tables of the currently selected database
Latest data: Selected tableShows in the status bar the latest data in the selected table

Management tab

MenuBehavior
---------Authorized Principals---------
Manage Cluster Authorized PrincipalsEnables managing a cluster's principals for authorized users
Manage Database Authorized PrincipalsEnables managing a database's principals for authorized users
Manage Table Authorized PrincipalsEnables managing a table's principals for authorized users
Manage Function Authorized PrincipalsEnables managing a function's principals for authorized users

Help tab

MenuBehavior
---------Documentation---------
HelpOpens a link to the Kusto online documentation
What's newOpens a document that lists all Kusto.Explorer changes
Report IssueOpens a dialog with two options:
  • Report issues related to service
  • Report issues in the client application
Suggest FeatureOpens a link to the Kusto feedback forum
Check UpdatesChecks if there are updates to your version of Kusto.Explorer

Connections panel

Drive

The Connections pane shows all the configured cluster connections. For each cluster the databases, tables, and attributes (columns)that they store are shown. Select items (which sets an implicit contextfor the search/query in the main panel), or double-click items to copy the name to the search/query panel.

If the actual schema is large (such as a database with hundreds of tables), you can search it by pressing CTRL+F and entering asubstring (case-insensitive) of the entity name you're looking for.

Kusto.Explorer supports controlling the Connection panel from the query window, which is useful for scripts. For example, you can start a script file with a command that instructs Kusto.Explorer to connect to the cluster/database whose data is being queried by the script, by using the following syntax:

Run each line using F5, or similar.

Control the user identity connecting to Kusto.Explorer

Download Yahoo To Desktop

The default security model for new connections isAAD-Federated security. Authentication is done through theAzure Active Directory using the default AAD user experience.

If you need finer control over the authentication parameters, you can expand the'Advanced: Connection Strings' edit box and provide a validKusto connection string value.

For example, users with a presence inmultiple AAD tenants sometimes need to use a particular 'projection'of their identities to a specific AAD tenant. Do this byproviding a connection string, such as the one below (replace words IN CAPITALS with specific values):

  • AAD_TENANT_OF_CLUSTER is a domain name or AAD tenant ID (a GUID) of the AAD tenant in which the cluster is hosted. This is usually the domain name of the organization that owns the cluster, such as contoso.com.
  • USER_DOMAIN is the identity of the user invited into that tenant (for example, user@example.com).

Note

The domain name of the user is not necessarily the same as that of the tenant hosting the cluster.

Download To Desktop Mac Os

Keyboard shortcuts

You might find that using keyboard shortcuts enables you to perform operations faster than with the mouse. Take a look at this list of Kusto.Explorer keyboard shortcuts to learn more.

Table row colors

Kusto.Explorer tries to interpret the severity or verbosity level of each row in the results panel and color them accordingly. It does this by matching the distinct values of each column with a set of known patterns ('Warning', 'Error', and so on).

Github Desktop Download For Mac

To modify the output color scheme, or turn this behavior off, from the Tools menu, select Options > Results Viewer > Verbosity color scheme.

Excel color scheme legendVivid color scheme legend

Next steps

Learn more about working with Kusto.Explorer:

Learn more about Kusto.Explorer tools and utilities: