Skip to main content

Query checker

Reading time: 0 minute(s) (0 words)

The Query checker feature allows Nobl9 users to validate whether their newly created SLOs will work correctly. If an SLO passes validation, it will start collecting SLI data immediately. Otherwise, the Query checker notifies about an error, so you can fix issues with connection or query, and get your SLOs going.

Scope of support​

Query checker is available for the following data sources connected using the direct method:

Assumptions and limitations​

Assumptions for verifying connection​

Nobl9 tests the connection by calling the data source's API and verifying the connection status, usually through the HTTP response codes received from the data sources.

Limitations of verifying query​

This feature aims to verify the data source's response rather than validate the underlying syntax of the query. Nobl9 tests the query by calling the underlying data source API and verifying the result.

There are two possible outcomes of the verification:

  1. A query is marked as valid: the request has succeeded.

    caution

    The query will be marked as valid even when the response is empty.

  2. A query is marked as invalid: the data source's connection can't be established, or the API call returns error (usually with the HTTP status code different from 200).

When does the verification occur?​

Nobl9 triggers verifying connection and query upon the following:

  1. SLO with a new query creation.
  2. Updates to queries in existing SLOs.
    It creates a new indicator entry in the database, triggering validation.
  3. Updates to the data source’s direct connection credentials.
    Only queries (indicators) marked as invalid are re-validated.

User experience​

Depending on the selected metric type, the query checker returns different information.

After you create an SLO, Nobl9 automatically begins verification. Your SLO features the following statuses:

  • On the SLO grid: Verifying connection and query
  • In the SLO details: Waiting for the connection and query verification results

Upon successful check, Nobl9 automatically proceeds to the importing data and calculating statuses in the SLO details. The charts display Importing data. Wait until the process has finished until data is processed and calculated.

When the check is unsuccessful, Nobl9 displays the Connection or query error status instead of the charts. The message includes the link to the error log for the metric that failed verification.

Threshold errors
Image 1: Error statuses for the Threshold metric check

Click View error log to learn what's wrong and view the Last Error Message returned by your data source:

Threshold errors
Image 2: Error modal for the Threshold metric troubleshooting

Click Edit Data Source to fix its configuration or Edit SLO Query to fix the query.

While failed verification for threshold metrics returns the error with your threshold query, the error log for the ratio metric can return the following:

  1. Good and total queries error.
  2. Good query error.
  3. Total query error.
For a more in-depth look, consult additional resources:
TroubleshootingtroubleshootingNobl9 adds tools to make SLO queries more efficientExternalResilience first: A customer success strategy for Nobl9External
Last updated on
On this page