Please use the form below to provide your feedback. Because your feedback is valuable to us, the information you submit in this form is recorded in our issue tracking system (JIRA), which is publicly available. You can track the status of your feedback using the ticket number displayed in the dialog once you submit the form.

Querying Your Data

    Querying Operational Insights from the Python SDK, with SQL++.

    SQL++ is a declarative query language for JSON data. To support the full feature set of Operational Insights, SQL++ for Operational Insights, a customized and extended version of the SQL++ query language, is available. See About SQL++.

    Real-Time Data Analysis

    Traditionally, analyzing JSON data in NoSQL databases requires complex transformations (like flattening) to prepare it for analytics, causing delays and hindering real-time insights. Operational Insights eliminates these ETL complexities by unifying operational and analytical data stores into a single platform. This enables Zero ETL, reducing costs, complexity, and improving time to insight.

    Long Running Queries

    All versions of Operational Insights support long running client-side requests. This process keeps a connection live between client and server for long running queries. For such long running queries, a better mechanism is for the client to trigger an asynchronous query without holding a connection to the server open for the duration of the query execution. This Server Asynchronous Request API was introduced in Operational Insights Server 2.2. For more information, see Service APIs.

    After the query request is submitted, clients can monitor the status of the request and on successful execution of query, opt to stream the results of the query. This way the connection between SDK client and Operational Insights Cluster does not stay open for the long duration of query processing, and isonly needed for result set streaming.

    cluster.start_query() → QueryHandle → QueryStatus → QueryResultsHandle

    This information flow can be seen in the sample code in the SQL++ queries section.

    Next Steps

    Dive right in with our practical examples.