Using Quick Actions
Quick actions allow querying data placed in the clipboard quickly and without leaving making any substantial or long lasting changes to the Kusto Cluster you are querying against. Quick Actions are designed to run fast and require minimal interaction to operate.
All quick actions end by invoking a query on the resulting data using the chosen query editor. Further processing is done in the query editor.
The top menu line shows the current content type placed in the Clipboard, and the target Kusto cluster and database. The content will show Table for recognized tabular data, Text for text data and Files for files and folders.
Clicking on this menu item will present a selector for the quick action target. Use it to choose a cluster from the set of clusters configured in Settings, or to modify the target database.
If you wish to add a new cluster, do so from Settings.
Copy a file, table or text data then Open Klipboard's menu and chose one of 4 quick actions to invoke.
Klipboard offers 4 quick actions to use:
| Name | Action | Pros | Limits |
|---|---|---|---|
| Inline Query | Converts the input into a KQL datatable and invokes a query on it | Column name tolerant; Value Format tolerant | Data must be structured; Input Size is limited to around 60KB |
| Inline Free Text Query | Converts the input into a text lines KQL datatable and invokes a query on it | Convenient on small data sets; Allows in-query parsing using KQL | Input Size is limited to around 60KB; Resulting query is verbose |
| External Data Query | Upload the input to a blob and invokes an external data query on it | No Size restriction in input text or table data | Multiple Files are not supported; Parsing is less tolerant of column names or cell format |
| Temporary Table Query | Upload input to a temporary table and invoke a query on it | Can handle larger volume of files; data persists for a limited time then auto-deletes | Up to 100 files; Parsing is less tolerant of column names or cell format |