SQL Query

This feature is available as an add-on for the Honeycomb Enterprise plan. Please contact your Honeycomb account team for details.

Supported Platforms

HTP Agent: v1.40.0+

Platform	Metrics	Logs	Traces
Linux		✓
Windows		✓
macOS		✓

Configuration

Field	Description
Driver	Which database driver should be used. Typically indicates which kind of database is being queried. Options include “postgres”, “mysql”, “snowflake”, “sqlserver”, “sap-hana”, and “oracle”.
Database Connection Options	A driver specific string specifying how to connect to the database. Usually contains information like host, port, authorization credentials, TLS configuration, and other connection options.
Query	The SQL query to run. The results of the query are used to generate the telemetry specified below.
Log Body Column	Defines the name of the column whose value will become the body for the generated log.
Tacking Column	Used for parameterized queries. Defines the name of the column to retrieve for the parameter value on subsequent query runs. See this OTel Documentation for more information.
Tracking Start Value	Used for parameterized queries. Defines the initial value of the tracking column to compare against on subsequent query runs. See this OTel Documentation for more information.
Collection Interval	How frequently to execute queries to retrieve log data. Default is ‘10s’.
Enable Tracking Storage	If using tracking values, enable this to persist those values when the collector is restarted. Directory will be “$OIQ_OTEL_COLLECTOR_HOME/storage”. See this OTel Documentation for more information.
Enable Query Logging	Whether or not the collector should log the SQL query with associated parameters when the query is ran.

Example Configuration

In this example, we are connecting to a postgres database using a postgres driver specific connection string. We are using a simple query which is retrieving rows of logs from a table. We are tracking the id column to avoid creating duplicate logs.

Web Interface

Honeycomb Docs - SQL Query Source - image 1

Standalone Source

apiVersion: bindplane.observiq.com/v1
kind: Source
metadata:
  id: sqlquery
  name: sqlquery
spec:
  type: sqlquery
  parameters:
    - name: driver
      value: 'postgres'
    - name: datasource
      value: 'postgresql://postgres:password@localhost:5432/production?sslmode=disable'
    - name: query
      value: 'select data, id from log_data where id > $1'
    - name: body_column
      value: 'data'
    - name: tracking_column
      value: 'id'
    - name: tracking_start_value
      value: '0'
    - name: interval
      value: '10s'
    - name: enable_storage
      value: true
    - name: enable_log_query_logging
      value: true

Instrument Applications

Instrument Infrastructure

CI/CD Observability

Manage Pipelines

Shape Data

Control Data Volume

Use Cases

Description

Supported Platforms

Configuration

Example Configuration

Web Interface

Standalone Source

​Description

​Supported Platforms

​Configuration

​Example Configuration

​Web Interface

​Standalone Source

Description

Supported Platforms

Configuration

Example Configuration

Web Interface

Standalone Source