Queries

The Tricloud Nexus Query Editor is a powerful tool designed to help users query, analyze, and visualize data effortlessly.

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.

Query Editor

1. 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 Definition of Tables in the database

• Creating a Query How to create your first query

  • Basic Queries Basic operators

  • Intermediate Queries Join, Summarize and make-series operators

  • Advanced Queries Trendline and Forecasting

For more details on KQL, please see Kusto Query Language in Microsoft's documentation.