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
  • Required credentials
  • Queries
  1. Marple Insight
  2. Setup and Configuration
  3. Data connection
  4. Supported Databases

Azure Data Explorer (ADX)

PreviousSupported DatabasesNextMicrosoft Fabric

Last updated 3 months ago

Marple integrates seamlessly with , a powerful time-series database optimised for large-scale telemetry data.

Required credentials

To connect, the following credentials are needed:

// example
{
    "appId": "8aa131d-dac5-429d-ada2-95adbc83b",
    "appKey": "anv8Q~TJ6ubna15TCi.wAg9015EcDL",
    "tenantId": "11344e0f-83d3-4b52-9a38-a6bbb1a360a4",
    "dbName": "my-adx-database",
    "dbHost": "https://myadxdatabase.westeurope.kusto.windows.net"
}

Queries

Queries are executed using . Marple offers predefined queries for fetching datasets, signals, and time-series data. Below are some example queries:

  • To retrieve datasets:

{{TABLE}}
{%- for key, values in metadata.items() %}
| where {{key}} in ('{{values|join("', '")}}')
{% endfor %}
| summarize
    timestamp_start = min({{TIME_COLUMN}}),
    timestamp_stop  = max({{TIME_COLUMN}}),
    by session, car, outing
| extend 
    display_name = strcat(session, ' | ', car, ' | ', outing), 
    realtime = (['acquisition type'] == 'Telemetry' and unixtime_seconds_todatetime(timestamp_stop) > ago(1m))
  • To retrieve a signal list:

{{TABLE}}
| where outing == '{{dataset.outing}}'
| summarize ['count'] = count()
    by name=signal
  • To retrieve the time series data

{{TABLE}}
| where outing == '{{dataset.outing}}'
| where {{timestamp_start}} <= timestamp
| where {{timestamp_stop}} >= timestamp
| where signal == '{{signal.name}}'
| project name = signal, timestamp = timestamp, value = toreal(value)
ADX
Kusto Query Language (KQL)