Knowi enables data discovery, query, aggregation, visualization, and reporting automation from InfluxDB V2 along with other unstructured and structured datasources.

Overview

1. Connect, extract, and transform data from your InfluxDB V2, using one of the following options:
   a. Through our UI to connect directly.
   b. Using our Cloud9Agent. This can securely pull data inside your network. See agent configuration for more details.
2. Visualize and Automate your Reporting instantly.

UI Based Approach

Connecting

1. Log in to Knowi and select Queries from the left sidebar.
2. Click on New Datasource + button and select InfluxDB V2 from the list of datasources.
3. After navigating to the New Datasource page, either uses the pre-configured settings into Cloud9 Chart's own demo InfluxDB V2 database or follow the prompts and configure the following details to set up connectivity to your own InfluxDB V2 database:
   
   

   a. Datasource Name: Enter a name for your datasource
   b. URL: Enter the URL to connect to the InfluxDB2 instance
   c. API Key: Enter API Key to connect to InfluxDB2 instance
   d. Org ID: Enter the unique identifier to identify the organization when making API calls and to control access to resources within the organization.
   e. Default Bucket: Enter the name of the bucket that a particular measurement belongs to
   f. Internal Datasource: Checking this option enables you to define datasource configurations here that are automatically synced with your agent.

    4. Click on the Save button and start Querying.

Query

Step 1: Query using a visual builder or query editor

Visual Builder: After connecting to the InfluxDB V2 datasource, Knowi will pull out a list of tables along with field samples. Using these tables, you can automatically generate queries through our visual builder in a no-code environment by either dragging and dropping fields or making your selections through the drop-down.

Tip: You can also write queries directly in the Query Editor, a versatile text editor that offers more advanced editing functionalities like InfluxDB2 Query support for multiple language modes, Cloud9QL, and more.

Step 2: Define data execution strategy by using any of the following two options:

• Direct Execution: Directly execute the Query on the original Datasource, without any storage in between. In this case, when a widget is displayed, it will fetch the data in real-time from the underlying Datasource.
• Non-Direct Execution: For non-direct queries, results will be stored in Knowi's Elastic Store. Benefits include- long-running queries, reduced load on your database, and more.

Non-direct execution can be put into action if you choose to run the Query once or at scheduled intervals. For more information, feel free to check out this documentation- Defining Data Execution Strategy.

Step 3: Click on the Preview button to analyze the results of your Query and fine-tune the desired output, if required.

The result of your Query is called Dataset. After reviewing the results, name your dataset and then hit the Create & Run button.

AI Query Generator

The AI query generator automatically generates queries from plain English statements for searching the connected databases and retrieving information. The goal is to simplify and speed up the search process by automatically generating relevant and specific queries, reducing the need for manual input, and improving the probability of finding relevant information.

STEPS:

Step 1: Enter the details of the query you'd like to generate in plain English. Details can include table or collection names, fields, filters, etc. The AI generator uses OpenAI to generate a query. 

Only the question is sent to OpenAI APIs and not the data.

Example:

return sensor_id, field, from table airSensors 

Step 2: Click on the Run and the query will be generated which you can copy to the clipboard and paste into the Query Editor.

Step 3: Click on the Preview button to analyze the results of your Query and fine-tune the desired output, if required.

Note 1: The OpenAI must be enabled by the admin before using the AI Query Generator. 

[
    {
        "name": "demoInfluxDBV2",
        "host": "http://23.23.63.119:8086",
        "dbName": "NOAA_water_database",
        "userId": "",
        "password": "",
        "datasource": "influxdbV2"
    }
]

[
  {
    /* This runs every 10 minutes, on the datasource defined in the any of the files that begin with datasource_  */
    "entityName":"Water level",
    "dsName":"demoInfluxDBV2",
    "queryStr":"select mean(water_level) as \"avg\" from h2o_feet group by location",
    "frequencyType":"minute",
    "frequency":10,
    "overrideVals":{
      /* Tells Knowi to replace all existing values for this dataset with this one */
      "replaceAll":true
    }
  }
]