[collector] Sectionstype - what kind of data to retrieve / how to retrieve it
"none""http" (HTTP/1.1 + HTTP/2)"http/3""sql"schedule - cron schedule expression
timezone - name of the effective time zone for the schedule
"UTC""UTC" (case insensitive)"local" (case insensitive)"America/Los_Angeles"destination - where to send the data to
"discard" / "none""discard" / "none""stdout"[collector.sql] Sub-Sectiontype - driver type of the SQL-based database to connect to
"cockroachdb" (CockroachDB)"mssql" or "sqlserver" (Microsoft SQL Server)"mariadb" (MariaDB)"mysql" (MySQL)"odbc" (Open Database Connectivity - see additional setup instructions)"oracle" (Oracle Database - see additional setup instructions)"postgres" or "postgresql" (PostgreSQL)"sap_hana" (SAP HANA)"snowflake" (Snowflake)"sqlite" (SQLite)connection - database connection string for the SQL client
query or query_file - SQL query to execute
"SELECT * FROM table;") - usually when it’s short"config/query.sql" or "/path/query.sql") - usually when it’s complex or sensitivetimeout - timeout for SQL client queries
"1m"h (hours), m (minutes), and s (seconds)"0" and negative values (e.g., "-1s") = no client-side timeout