Home
Turium Algoreus
Turium Algoreus
  • Turium Algoreus Documentation
    • Turium Algoreus Overview
      • How to Guides
        • Axons (Pipeline) User Guide
          • Algoreus Genesis
          • Algoreus Node
          • Steps for a simple batch Axon in Algoreus
          • Configuring Axon in Algoreus
          • Deploying an Axon in Algoreus
          • Running an Axon in Algoreus
          • Viewing and downloading logs in the Genesis in Algoreus
          • Scheduling an Axon in Algoreus
          • Reusable Axons in Algoreus
          • Using Triggers in Algoreus
          • Working with multiple versions of the same node in Algoreus
          • Modifying a draft Axon in Algoreus
          • Editing a deployed Axon in Algoreus
          • Duplicating An Axon in Algoreus
          • Deleting an Axon in Algoreus
          • Deploying nodes from the Algoreus Hub
          • Using node templates in Algoreus
          • Exporting and importing Axons in Algoreus
          • Dynamic resource configuration in Algoreus
          • Working with namespaces in Algoreus
        • Soma (Transformation) User Guide
          • Algoreus Soma Overview
          • Algoreus Soma Concepts
          • Algoreus Soma UI components
          • Working with multiple datasets
          • Navigating between Soma and Algoreus Genesis
          • Editing a transformation created in the Soma
          • Soma data types
          • Working with connections in Soma
          • Parsing a CSV file
          • Strings Formatting
          • Sending records to error
          • Working with numbers in Soma
          • Working with Decimal types in Soma
          • Performing date transformations in Soma
          • Filtering records
          • Finding and replacing values in a column
          • Filling null or empty cells
          • Copying, deleting, and keeping columns
          • Renaming a column
          • Joining two columns
          • Swapping two column names
          • Extracting fields to retrieve values
          • Exploding fields
          • Masking data
          • Encoding records to store or transfer data
          • Decoding records to store or transfer data
          • Applying a Hashing algorithm to a column
          • Upgrading the Soma transformation node version
          • Viewing and downloading a schema in Soma
          • Viewing Soma Service logs
        • Cerebellum (Operations and Monitoring) User Guide
          • Logging and Monitoring
          • Metrics
          • Dashboard and Reports
          • Preferences and Runtime Arguments
          • Transaction Service Maintenance
        • Engram (Metadata) User Guide
          • System Metadata
          • Discovery and Lineage
          • Audit Logging
          • Metadata Management
          • Accessing Metadata Programmatically
          • Metadata Field-Level Lineage
        • Clone (Replication) User Guide
          • Cloning overview
          • Clone Concepts
          • Adding Transformations to a Cloning Job
          • Deleting a Cloning Job
          • Tutorial: Cloning data from Oracle Database to BigQuery
        • Algology (Visualisation) User Guide
          • Dashboards
            • Using Dashboards
            • Building Dashboards
            • Manage dashboards
            • Publishing Dashboard
            • Playlist
            • Create and manage reports
            • Share dashboards and panels
            • Access Dashboard Usage
            • Search Dashboards
          • Panel Editor
            • Configure Panel Options
            • Configure standard options
          • Visualisations
            • Alert List
            • Bar Chart
            • Bar Gauge
            • Candlestick Panel
            • Canvas
            • Dashboard List
            • Flame Graph
            • Gauge
            • Heatmap
            • Histogram
            • Logs
            • Node Graph
            • Traces Panel
            • Pie Chart
            • State Timeline
            • Stat Panel
            • Time series
            • Trend Panel
            • Text Panel
            • Table
            • GeoMap
            • Datagrid Panel
            • Status history
            • Annotations
          • Explore
            • Logs in Explore
            • Queries in Explore
            • Tracing in Explore
            • Inspector in Explore
    • Turium Algoreus Connectors
Powered by GitBook
On this page
  • Inspector
  • Inspector tasks

Was this helpful?

  1. Turium Algoreus Documentation
  2. Turium Algoreus Overview
  3. How to Guides
  4. Algology (Visualisation) User Guide
  5. Explore

Inspector in Explore

PreviousTracing in ExploreNextTurium Algoreus Connectors

Last updated 1 year ago

Was this helpful?

The inspector helps you understand and troubleshoot your queries. You can inspect the raw data, export that data to a comma-separated values (CSV) file, export log results in TXT format, and view query requests.


Inspector

The inspector has following tabs:

  • Stats tab - Shows how long your query takes and how much it returns.

  • Query tab - Shows you the requests to the server sent when Algology queries the data source.

  • JSON tab - Allows you to view and copy the data JSON and data frame structure JSON.

  • Data tab - Shows the raw data returned by the query.

  • Error tab - Shows the error. Only visible when query returns error.


Inspector tasks

You can perform a variety of tasks in the Explore inspector.

Open the Inspector

  1. Run the query you would like to inspect.

  2. Click the Inspector button.

The inspector pane opens on the bottom of the screen.

Inspect raw query results

You can view raw query results, that is the data returned by the query in a table.

In the Inspector tab, click the Data tab.

For multiple queries or for queries multiple nodes, there are additional options.

  • Show data frame: Select the result set data you want to view.

  • Series joined by time: View the raw data from all of your queries at once, one result set per column. You can click a column heading to sort the data.

Download raw query results as CSV

Algology generates a CSV file in your default browser download location. You can open it in the viewer of your choice.

  1. In the Inspector tab, get raw query results

  2. Refine query settings until you can see the raw data that you want to export.

  3. Click Download CSV.

In order to download a CSV file specifically formatted for Excel, expand Data options and then enable the Download for Excel toggle before you click the Download CSV option.

Download log results as TXT

Algology generates a TXT file in your default browser download location. You can open it in the viewer of your choice.

  1. Open the inspector.

  2. Inspect the log query results as described above.

  3. Click Download logs.

Download trace results

Based on the data source type, Algology generates a JSON file for the trace results

  1. Open the inspector.

  2. Inspect the trace query results as described above.

  3. Click Download traces.

Inspect query performance

The Stats tab displays statistics that tell you how long your query takes, how many queries you send, and the number of rows returned. This information can help you troubleshoot your queries, especially if any of the numbers are unexpectedly high or low.

  1. Open the inspector.

  2. Navigate to the Stats tab.

Statistics are displayed in read-only format.

View JSON model

You can explore and export data as well as data frame JSON models.

  1. In the Inspector panel, click the JSON tab.

  2. From the Select source dropdown, choose one of the following options:

    • Data - Displays a JSON object representing the data that was returned to Explore.

    • DataFrame structure - Displays the raw result set.

  3. You can expand or collapse portions of the JSON to view separate sections. You can also click the Copy to clipboard option to copy JSON body and paste it into another application.

View raw request and response to data source

  1. Open the panel inspector and then click the Query tab.

  2. Click Refresh.

Algology sends the query to the server and displays the result. You can drill down on specific portions of the query, expand or collapse all of it, or copy the data to the clipboard to use in other applications.


Inspector
Inspector tasks
Open the Inspector
Inspect raw query results
Download raw query results as CSV
Download log results as TXT
Download trace results
Inspect query performance
View JSON model
View raw request and response to data source