Specification

JDBC SQL User's Configuration

metricshub.yaml

resources:
  db-host:
    attributes:
    # ...
    protocols:
      sql:
        username: #
        password: #
        url: #  
        timeout: # 
        type: # 
        port: # 
        database: #

SQL Criterion

criteria:
- type: sql
  query: # 
  expectedResult: #
  errorMessage:

SQL Source

<source-name>:
   type: sql
   query: # 

To differentiate the current source, which executes inner SQL queries using the internal MetricsHub DB engine, we should consider renaming the type of the inner SQL source to reflect its engine-based nature. A suitable option could be localSql.

• Should we support for SELECT * FROM TABLE
  • If yes, we need to define a new attribute columns in the sql source.
• Should we override the url in a source
  • If yes, we need to define a new attribute url, that overrides the user's url. It that, in the new url, macros should be correctly replaced by the engine.