# Queries

This guide will help you get started with using the Query Editor of Tricloud Nexus to analyze and gain insights from data efficiently.

***

## Introduction

The Tricloud Nexus Query Editor is a powerful tool designed to help users query and analyze data effortlessly. Built on the Azure Data Explorer Query UI, it uses KQL (Kusto Query Language) for efficient data access and exploration.

### Learning Kusto Query Language (KQL)

Here are some links to help you get started with the learning the KQL language.

* Kusto Query documentation: <https://learn.microsoft.com/en-us/azure/data-explorer/kusto/query/>
* Quick Reference Guide: <https://learn.microsoft.com/en-us/azure/data-explorer/kusto/query/kql-quick-reference>
* Kusto Cheat Sheet; <https://techcommunity.microsoft.com/t5/azure-data-explorer-blog/azure-data-explorer-kql-cheat-sheets/ba-p/1057404>

***

### Accessing the Query Editor

1. **Login to Tricloud Nexus**:
   * Navigate to the Tricloud Nexus platform using your browser.
   * Enter your credentials and click **Login**.
2. **Open the Query Editor**:
   * Click on the **Query Editor** tab located in the navigation menu.

<figure><img src="/files/JKfVgnpGsaaXkLcpkd86" alt=""><figcaption><p>Query Editor</p></figcaption></figure>

3. **Select the Database:**
   * In the Query Editor, your workspace is pre-configured to access the Azure Data Explorer database.
   * Ensure you have the necessary permissions to query the database.
   * Select the database as seen in the example screenshot above, and take notice that the database is selected above the query editor using the convention *cluster/databasename.*
   * In the example above the selection is: tciotadxcluster.westeurope/TimeSeriesSandbox02 which may differ depending on your installation.

***

For more details see the following sections:

* [Database Tables](/management-portal/insights/queries/database-tables.md) Definition of Tables in the database
* [Creating a Query](/management-portal/insights/queries/creating-a-query.md) How to create your first query
  * [Basic Queries](/management-portal/insights/queries/creating-a-query/basic-queries.md) Basic operators
  * [Intermediate Queries](/management-portal/insights/queries/creating-a-query/intermediate-queries.md) Join, Summarize and make-series operators
  * [Advanced Queries](/management-portal/insights/queries/creating-a-query/advanced-queries.md) Trendline and Forecasting

For more details on KQL, please see [Kusto Query Language](https://learn.microsoft.com/en-us/kusto/query/syntax-conventions?view=azure-data-explorer\&preserve-view=true) in Microsoft's documentation.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.tricloudnexus.io/management-portal/insights/queries.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.