Connect a SQL Database (Read-Only)

Details
Category: Guides
  • Applicable Software: MokonyxInsight
  • Min Version Number: 01.00.00
  • Max Version Number: Not Applicable

Add the data source

  1. Insight → Data Sources → New, provider type SQL.
  2. Set the driver, host, database, user and (in the secret) the password. A read-only database user is strongly recommended.
  3. Define a metric map: for each metric give a name, a result type (scalar, list or timeseries) and the SELECT that returns it. The binds :date_from, :date_to and :limit are available so each query follows the time window selected on the dashboard.
  4. Save then Test.

Safety

The client only runs a single read-only SELECT/WITH, caps rows, and applies a statement timeout - but a read-only database account remains the primary safeguard.

Hits: 23