Hi, I’m trying to use inputs.sql with sqlite according to docs this is supported
# Available SQL drivers for the SQL input plugin
This is a list of available drivers for the SQL input plugin. The data-source-name (DSN) is driver specific and
might change between versions. Please check the driver documentation for available options and the format.
| database | driver | aliases | example DSN | comment |
| -------------------- | --------------------------------------------------------- | --------------- | -------------------------------------------------------------------------------------- | --------------------------------------------------------------------------------------------------------------------- |
| CockroachDB | [cockroach](https://github.com/jackc/pgx) | postgres or pgx | see _postgres_ driver | uses PostgresQL driver |
| FlightSQL | [flightsql](https://github.com/apache/arrow/tree/main/go/arrow/flight/flightsql/driver) | | `flightsql://[username[:password]@]host:port?timeout=10s[&token=TOKEN][¶m1=value1&...¶mN=valueN]` | see [driver docs](https://github.com/apache/arrow/blob/main/go/arrow/flight/flightsql/driver/README.md) for more information |
| MariaDB | [maria](https://github.com/go-sql-driver/mysql) | mysql | see _mysql_ driver | uses MySQL driver |
| Microsoft SQL Server | [sqlserver](https://github.com/microsoft/go-mssqldb) | mssql | `sqlserver://username:password@host/instance?param1=value¶m2=value` | uses newer _sqlserver_ driver |
| MySQL | [mysql](https://github.com/go-sql-driver/mysql) | | `[username[:password]@][protocol[(address)]]/dbname[?param1=value1&...¶mN=valueN]` | see [driver docs](https://github.com/go-sql-driver/mysql) for more information |
| PostgreSQL | [postgres](https://github.com/jackc/pgx) | pgx | `[user[:password]@][netloc][:port][,...][/dbname][?param1=value1&...]` | see [postgres docs](https://www.postgresql.org/docs/current/libpq-connect.html#LIBPQ-CONNSTRING) for more information |
| SQLite | [sqlite](https://gitlab.com/cznic/sqlite) | | `filename` | see [driver docs](https://pkg.go.dev/modernc.org/sqlite) for more information |
| TiDB | [tidb](https://github.com/go-sql-driver/mysql) | mysql | see _mysql_ driver | uses MySQL driver |
| ClickHouse | [clickhouse](https://github.com/ClickHouse/clickhouse-go) | | `tcp://host:port[?param1=value&...¶mN=value]"` | see [clickhouse-go docs](https://github.com/ClickHouse/clickhouse-go#dsn) for more information |
## Comments
### Driver aliases
show original
[telegraf] Error running agent: could not initialize input inputs.sql: driver “sqlite” not supported use one of [clickhouse cockroach flightsql maria mssql mysql pgx pgx/v4 postgres snowflake sqlserver tidb]
What am I msising?
Thanks
Raised as a bug
opened 01:20PM - 04 Sep 23 UTC
bug
### Relevant telegraf.conf
```toml
# # Read metrics from SQL queries
[[inputs.… sql]]
# ## Database Driver
# ## See https://github.com/influxdata/telegraf/blob/master/docs/SQL_DRIVERS_INPUT.md for
# ## a list of supported drivers.
driver = "sqlite"
#
```
### Logs from Telegraf
```text
2023-09-04T11:13:32Z E! [telegraf] Error running agent: could not initialize input inputs.sql: driver "sqlite" not supported use one of [clickhouse cockroach flightsql maria mssql mysql pgx pgx/v4 postgres snowflake sqlserver tidb]
```
### System info
Telegraf 1.27.4, Winserver 2019
### Docker
_No response_
### Steps to reproduce
1. Read https://github.com/influxdata/telegraf/blob/master/docs/SQL_DRIVERS_INPUT.md
2. Set driver to sqlite
3. Observe the error
...
### Expected behavior
Expect to not get an error about sqlite being unsupported
### Actual behavior
Get an error about it being unsupported
### Additional info
_No response_
Will close this forum post if I can
