title | description | author | ms.author | ms.reviewer | ms.topic | ms.custom | ms.date | no-loc | ms.collection | ||
---|---|---|---|---|---|---|---|---|---|---|---|
Copilot for Real-Time Intelligence (preview) |
Learn how Copilot in Real-Time Intelligence can help you explore your data and extract valuable insights. |
yaelschuster |
yaschust |
mibar |
conceptual |
|
06/11/2024 |
|
ce-skilling-ai-copilot |
Copilot for Real-Time Intelligence is an advanced AI tool designed to help you explore your data and extract valuable insights. You can input questions about your data, which are then automatically translated into Kusto Query Language (KQL) queries. Copilot streamlines the process of analyzing data for both experienced KQL users and citizen data scientists.
[!INCLUDE preview-note]
- A workspace with a Microsoft Fabric-enabled capacity
- Read or write access to a KQL queryset
[!INCLUDE copilot-note-include]
Copilot for Real-Time Intelligence lets you effortlessly translate natural language queries into Kusto Query Language (KQL). The copilot acts as a bridge between everyday language and KQL's technical intricacies, and in doing so removes adoption barriers for citizen data scientists. By harnessing OpenAI's advanced language understanding, this feature allows you to submit business questions in a familiar, natural language format, which are then converted into KQL queries. Copilot accelerates productivity by simplifying the query creation process with a user-friendly and efficient approach to data analysis.
- To access Copilot for Real-Time Intelligence, navigate to a new or existing KQL queryset.
- Connect to a database. For more information, see Select a database
- Select the Copilot button.
- In the Copilot pane, enter your business question in natural language.
- Press Enter. After a few seconds, Copilot will generate a KQL query based on your input. You can copy the query to the clipboard, or insert it directly in the KQL query editor. To run the query in the query editor, you must have write access to the KQL queryset.
- Select the Run button to execute the query.
Note
- Copilot doesn't generate control commands.
- Copilot doesn't automatically run the generated KQL query. Users are advised to run the queries at their own discretion.
You can continue to ask questions and generate queries in the Copilot pane, but each question is evaluated separately and not connected to previous questions or their answers.
Here are some tips that can help improve the accuracy of the KQL queries generated by Copilot:
- Start with simple natural language prompts, to learn the current capabilities and limitations. Then, gradually proceed to more complex prompts.
- State the task precisely, and avoid ambiguity. Imaging you shared the natural language prompt with few KQL experts from your team without adding oral instructions - would they be able to generate the correct query?
- Supply any relevant information that can help the model to generate the most accurate query. If you can, specify tables, operators, or functions that are critical to the query.
- Prepare your database: Add docstring properties to describe common tables and columns. This might be redundant for descriptive names (for example, timestamp) but is critical to describe tables or columns with meaningless names. You don't have to add docstring to tables or columns that are rarely used. For more information, see .alter table column-docstrings command.
- To improve Copilot results, select either the like or dislike icon to submit your comments in the Submit feedback form.
Note
The Submit feedback form submits the name of the database, its url, the KQL query generated by copilot, and any free text response you include in the feedback submission. Results of the executed KQL query aren't sent.
- Copilot might suggest potentially inaccurate or misleading suggested KQL queries due to:
- Complex and long user input.
- User input that directs to database entities that aren't KQL Database tables or materialized views (for example KQL function.)
- More than 10,000 concurrent users within an organization can result in failure or a major performance hit.