InfiniBand and Databricks Integration

Input and output integration overview

The InfiniBand Telegraf plugin collects performance metrics from all InfiniBand devices installed on a Linux system, providing essential insights for monitoring network performance and reliability.

Use Telegraf’s HTTP output plugin to push metrics straight into a Databricks Lakehouse by calling the SQL Statement Execution API with a JSON-wrapped INSERT or volume PUT command.

Integration details

InfiniBand

This plugin gathers statistics for all InfiniBand devices and ports on the system. InfiniBand is a high-speed networking technology commonly used in high-performance computing and enterprise data centers. The plugin retrieves various performance counters from the system’s InfiniBand devices located in /sys/class/infiniband/<dev>/port/<port>/counters/. The metrics depend on the specific InfiniBand hardware and include various packet and error statistics that are essential for monitoring network health and performance. By utilizing this plugin, users can gain insights into the operational status of their InfiniBand networks, helping to identify potential issues and optimize performance.

Databricks

This configuration turns Telegraf into a lightweight ingestion agent for the Databricks Lakehouse. It leverages the Databricks SQL Statement Execution API 2.0, which accepts authenticated POST requests containing a JSON payload with a statement field. Each Telegraf flush dynamically renders a SQL INSERT (or, for file-based workflows, a PUT ... INTO /Volumes/... command) that lands the metrics into a Unity Catalog table or volume governed by Lakehouse security. Under the hood Databricks stores successful inserts as Delta Lake transactions, enabling ACID guarantees, time-travel, and scalable analytics. Operators can point the warehouse_id at any serverless or classic SQL warehouse, and all authentication is handled with a PAT or service-principal token—no agents or JDBC drivers required. Because Telegraf’s HTTP output supports custom headers, batching, TLS, and proxy settings, the same pattern scales from edge IoT gateways to container sidecars, consolidating infrastructure telemetry, application logs, or business KPIs directly into the Lakehouse for BI, ML, and Lakehouse Monitoring. Unity Catalog volumes provide a governed staging layer when file uploads and COPY INTO are preferred, and the approach aligns with Databricks’ recommended ingestion practices for partners and ISVs.

Configuration

InfiniBand

# Gets counters from all InfiniBand cards and ports installed
# This plugin ONLY supports Linux
[[inputs.infiniband]]
  # no configuration

  ## Collect RDMA counters
  # gather_rdma = false

Databricks

[[outputs.http]]
  ## Databricks SQL Statement Execution API endpoint
  url = "https://{{ env "DATABRICKS_HOST" }}/api/2.0/sql/statements"

  ## Use POST to submit each Telegraf batch as a SQL request
  method = "POST"

  ## Personal-access token (PAT) for workspace or service principal
  headers = { Authorization = "Bearer {{ env "DATABRICKS_TOKEN" }}" }

  ## Send JSON that wraps the metrics batch in a SQL INSERT (or PUT into a Volume)
  content_type = "application/json"

  ## Serialize metrics as JSON so they can be embedded in the SQL statement
  data_format = "json"
  json_timestamp_units = "1ms"

  ## Build the request body.  Telegraf replaces the template variables at runtime.
  ## Example inserts a row per metric into a Unity-Catalog table.
  body_template = """
  {
    \"statement\": \"INSERT INTO ${TARGET_TABLE} VALUES {{range .Metrics}}(from_unixtime({{.timestamp}}/1000), {{.fields.usage}}, '{{.tags.host}}'){{end}}\",
    \"warehouse_id\": \"${WAREHOUSE_ID}\"
  }
  """

  ## Optional: add batching limits or TLS settings
  # batch_size = 500
  # timeout     = "10s"

Input and output integration examples

InfiniBand

1. Performance Monitoring in High-Performance Computing (HPC): Monitor the performance metrics of InfiniBand interconnects in a high-performance computing cluster. By analyzing metrics such as packet errors and throughput, system administrators can ensure optimal operation and quickly identify any performance degradation. This setup enhances the reliability of computational tasks by allowing timely interventions based on accurate monitoring data.

2. Network Health Audits: Perform routine health checks of InfiniBand networks. The detailed metrics gathered, such as excessive buffer overruns and link integrity errors, provide valuable insights for network audits. By establishing baseline performance and watching for anomalies, IT professionals can ensure the stability and performance of critical infrastructures.

3. Integration with Alerting Systems: Set up the InfiniBand plugin to work in conjunction with alerting systems to trigger notifications based on performance thresholds. For instance, if the number of link errors exceeds a predefined limit, an alert can be sent to the network operations team. This proactive approach ensures that potential issues are addressed before they impact business operations.

4. Data Visualization Dashboards: Feed InfiniBand metrics to a visualization tool to create dashboards that display the real-time performance of the network. This can help stakeholders visualize critical data such as packet transmission rates and errors, facilitating better decision-making regarding network management and capacity planning.

Databricks

1. Edge-to-Lakehouse Telemetry Pipe: Deploy Telegraf on factory PLCs to sample vibration metrics and post them every second to a serverless SQL warehouse. Delta tables power PowerBI dashboards that alert engineers when thresholds drift.
2. Blue-Green CI/CD Rollout Metrics: Attach a Telegraf sidecar to each Kubernetes canary pod; it inserts container stats into a Unity Catalog table tagged by deployment_id, letting Databricks SQL compare error-rate percentiles and auto-rollback underperforming versions.
3. SaaS Usage Metering: Insert per-tenant API-call counters via the HTTP plugin; a nightly Lakehouse query aggregates usage into invoices, eliminating custom metering micro-services.
4. Security Forensics Lake: Upload JSON batches of Suricata IDS events to a Unity Catalog volume using PUT commands, then run COPY INTO for near-real-time enrichment with Delta Live Tables, producing a searchable threat-intel lake that joins network logs with user session data.

Feedback

Thank you for being part of our community! If you have any general feedback or found any bugs on these pages, we welcome and encourage your input. Please submit your feedback in the InfluxDB community Slack.