Metricbeat sql module with dynamic database values

[nsharath (Sharath Siravuru)]

I am using metricbeat 7.15 version with sql module enabled.
I have a huge list of databases and currently my sql module config size is very big. I would like to know how to send the database name (e.g. database1, database2,database3, etc) in below config dynamically (or) from a input config file which has list of database names and credentials that can be passed as a parameters. Maybe even the SQL query used as an input as i have a list of SQL queries which I run on different oracle databases. Please advise on smarter way.

- module: sql
  metricsets:
    - query
  period: 30s
  hosts: ["oracle://username:password@server:port/database1"]
  driver: "oracle"
  sql_query: "select open_mode database1_open_state from v$database1"
  sql_response_format: table
- module: sql
  metricsets:
    - query
  period: 30s
  hosts: ["oracle://username:password@server:port/database2"]
  driver: "oracle"
  sql_query: "select open_mode database2_open_state from v$database2"
  sql_response_format: table
- module: sql
  metricsets:
    - query
  period: 30s
  hosts: ["oracle://username:password@server:port/database3"]
  driver: "oracle"
  sql_query: "select open_mode database3_open_state from v$database3"
  sql_response_format: table