Marple Docs
  • Introduction
  • Marple Insight
    • Welcome
      • What is Marple Insight?
      • FAQ
      • Feedback
      • Release Notes
      • Roadmap
    • Setup and Configuration
      • Data connection
        • Supported Databases
          • Azure Data Explorer (ADX)
          • Microsoft Fabric
          • TimescaleDB & PostgreSQL
          • Mireo Spacetime
          • InfluxDB (Beta)
        • Connection configuration
          • Required Queries
          • Optional Queries
          • Templating
      • Deployment
        • Infrastructure
        • Identity Providers
        • Hardware
      • API
      • Python SDK
    • User Manuals
      • Data Library
      • Visualisation
        • Add Data Sets
        • Signal List
        • Functions
        • Plot types
          • Time Series
            • Signal Settings
            • Limits and Stacking
            • Zooming
            • Cursors
            • Text data
          • Scatter
          • Map
          • Frequency (FFT)
          • Aggregates
        • Mouse Actions
        • Tabs
        • Reorganise Plots
        • Compare data
        • Realtime
        • Export image
      • Motorsport Package
      • Flight Testing Package
      • Projects
      • Sharing
      • Team and accounts
        • Workspaces
        • Account Types
      • Keyboard Shortcuts
  • Marple Files
    • Welcome
      • What is Marple Files?
      • Quick Start
      • FAQ
      • Release Notes
    • User Manuals
      • Data
        • File Types
        • Time Precision
        • Data Points
        • Upload Data
        • Organise Data
        • Influx DB
      • Visualisation
        • Overview
        • Plot types
        • Mouse & Keyboard
        • Calculated Signals
        • Overlay Data Sets
        • Projects
        • Annotations
      • Analysis
        • Metric Builder
        • SQL Editor
        • Marple AI (GPT)
      • Reporting
        • Create Reports
        • View Reports
        • Share Reports
        • From data library to reports
      • Sharing and Accounts
        • Sharing
        • Team
        • Settings
      • For developers
        • API Access Tokens
        • API Guide
        • Python
Powered by GitBook
On this page
  • Segment List Query
  • Input Parameter
  • Expected Output
  • Other Optional Queries
  1. Marple Insight
  2. Setup and Configuration
  3. Data connection
  4. Connection configuration

Optional Queries

PreviousRequired QueriesNextTemplating

Last updated 22 days ago

Segment List Query

The Segment List query retrieves all segments within a given dataset.

Input Parameter

Your query should support the following:

  • dataset (Required) – A key-value pair for each metadata key checked in the dataset filter. Used in queries as {{ dataset.id }}.

Expected Output

Each segment should be represented as a row containing:

  • id (Required) – The unique identifier of the segment.

  • label (Required) – A descriptive label for the segment.

  • start (Required) – The timestamp of the first data point in the segment in nanoseconds.

  • stop (Required) – The timestamp of the last data point in the segment in nanoseconds.

  • Additional metadata fields (Optional) – Any relevant metadata attributes.

Other Optional Queries

In addition to the core queries, Marple supports several optional queries for improved performance and functionality:

  • Time Series Batch – Retrieves data for multiple signals within a time range, with optional subsampling.

  • Cursor Values – Fetches signal values at a specific timestamp, useful for scatter plots and maps.

  • Cursor Statistics – Computes min, max, and mean values within a time range.

  • Signal Table – Joins multiple signals into a single table with a common timestamp column.

  • Sandbox Signal – Derives a new signal from existing ones using a formula.

  • Sandbox Preview – Previews the results of a derived signal before applying it.