sql_exporter

Database-agnostic SQL exporter for Prometheus

Database-agnostic SQL exporter for Prometheus

SQL Exporter v0.15.0

What's Changed

• feat: drop scrape_errors_total metric with a configurable interval by @burningalchemist in https://github.com/burningalchemist/sql_exporter/pull/551
• refactor: reload targets and collectors, support SIGHUP by @burningalchemist in https://github.com/burningalchemist/sql_exporter/pull/548
• refactor: add --log.format param, deprecate --log.json flag by @burningalchemist in https://github.com/burningalchemist/sql_exporter/pull/561
• docs: revisit README.md by @burningalchemist in https://github.com/burningalchemist/sql_exporter/pull/545

Precompiled binaries are built with Go v1.21.11

Updated dependencies

Database drivers

• Clickhouse 2.26.0
• PostgreSQL(pgx) 5.6.0

Others

• prometheus/common 0.55.0
• aws/aws-sdk-go-v2/config 1.27.23
• aws/aws-sdk-go-v2 1.30.1
• aws/aws-sdk-go-v2/secretsmanager 1.32.1
• azure/azure-sdk-for-go/azidentity 1.6.0 (CVE-2024-35255)

Full Changelog: https://github.com/burningalchemist/sql_exporter/compare/0.14.4...0.15.0

Database-agnostic SQL exporter for Prometheus

SQL Exporter v0.14.4

What's Changed

• fix: use the passed jf jobFilters parameter by @burningalchemist in https://github.com/burningalchemist/sql_exporter/pull/521
• chore: update promu to v0.17 by @burningalchemist in https://github.com/burningalchemist/sql_exporter/pull/534
• build: disable symbol table, DWARF generation for builds by @burningalchemist in https://github.com/burningalchemist/sql_exporter/pull/535

Precompiled binaries are built with Go v1.21.11

Updated dependencies

Database drivers

• MSSQL 1.7.2
• Snowflake 1.10.1
• Clickhouse 2.25.0

Others

• sethvargo/go-envconfig 1.0.3
• google.golang.org/protobuf 1.34.1
• prometheus/client_golang 1.19.1
• dburl 0.23.1
• aws/aws-sdk-go-v2/config 1.27.16
• aws/aws-sdk-go-v2/secretsmanager 1.29.1

New Contributors

• @Neaj-Morshad-101 made their first contribution in https://github.com/burningalchemist/sql_exporter/pull/522

Full Changelog: https://github.com/burningalchemist/sql_exporter/compare/0.14.3...0.14.4

Database-agnostic SQL exporter for Prometheus

BREAKING CHANGE: from v0.5.0 serviceAccount sql-exporter is created by default. This behaviour can be disabled if needed to reference a custom serviceAccount object.

SQL Exporter v0.14.3

What's Changed

• fix(build): update gomod version to fix codeql warnings by @burningalchemist in https://github.com/burningalchemist/sql_exporter/pull/491
• fix(build): sync go versions between promu crossbuild and docker images by @burningalchemist in https://github.com/burningalchemist/sql_exporter/pull/494
• fix(build): wrong go version reference [skip ci] by @burningalchemist in https://github.com/burningalchemist/sql_exporter/pull/511

Precompiled binaries are built with Go v1.21.9

Updated dependencies

Database drivers

• MSSQL 1.7.1
• Clickhouse 2.23.2

Others

• golang.org/x/net 0.23.0
• google.golang.org/protobuf 1.34.0
• prometheus/common 0.53.0
• prometheus/client_model 0.6.1
• dburl 0.23.0
• aws/aws-sdk-go-v2/config 1.27.11

New Contributors

• @Fapiko made their first contribution in https://github.com/burningalchemist/sql_exporter/pull/496
• @jluckett-panw made their first contribution in https://github.com/burningalchemist/sql_exporter/pull/509

Full Changelog: https://github.com/burningalchemist/sql_exporter/compare/0.14.2...0.14.3

Database-agnostic SQL exporter for Prometheus

Database-agnostic SQL exporter for Prometheus

Helm chart release.

Database-agnostic SQL exporter for Prometheus

SQL Exporter v0.14.2

What's Changed

• PostgreSQL (pgx) driver upgrade v4 (4.18.2) > v5 (5.5.5).

Precompiled binaries are built with Go v1.21.9

Updated dependencies

Database drivers

• PostgreSQL(pgx) 5.5.5
• Snowflake 1.9.0
• MySQL 1.8.1
• Clickhouse 2.23.0

Others

• google.golang.org/protobuf 1.33.0 (CVE-2024-24786)
• prometheus/common 0.51.1
• dburl 0.22.0
• aws/aws-sdk-go-v2 1.26.1
• aws/aws-sdk-go-v2/config 1.27.10
• aws/aws-sdk-go-v2/service/secretsmanager 1.28.6

Full Changelog: https://github.com/burningalchemist/sql_exporter/compare/0.14.1...0.14.2

Database agnostic SQL exporter for Prometheus

SQL Exporter v0.14.1

What's Changed

• Security fix for PostgreSQL(pgx) driver (CVE-2024-27289);
• Clickhouse driver upgrade v1 > v2 (v1 driver is deprecated).

Precompiled binaries are built with Go v1.21.8

Updated dependencies

Database drivers

• PostgreSQL(pgx) 4.18.2
• Clickhouse 2.21.1

Others

• prometheus/client_golang 1.19.0
• prometheus/client_model 0.6.0
• prometheus/common 0.49.0

New Contributors

• @ferrous26 made their first contribution in https://github.com/burningalchemist/sql_exporter/pull/457
• @qfritz made their first contribution in https://github.com/burningalchemist/sql_exporter/pull/462
• @puneetloya made their first contribution in https://github.com/burningalchemist/sql_exporter/pull/463

Full Changelog: https://github.com/burningalchemist/sql_exporter/compare/0.14.0...0.14.1

Database agnostic SQL exporter for Prometheus

Helm chart release.

SQL Exporter v0.14.0

What's Changed

• feat: return metric with an explicit timestamp from the configured column by @burningalchemist in https://github.com/burningalchemist/sql_exporter/pull/429
• feat: provide configuration subset via env variables by @burningalchemist in https://github.com/burningalchemist/sql_exporter/pull/430
• feat: scrape selected jobs via query params by @burningalchemist in https://github.com/burningalchemist/sql_exporter/pull/433
• fix: nil dereference on wrong log level values, cleanup by @burningalchemist in https://github.com/burningalchemist/sql_exporter/pull/421
• fix: add flag to ignore results with missing values by @burningalchemist in https://github.com/burningalchemist/sql_exporter/pull/422
• fix: expand env vars while parsing DB URL by @burningalchemist in https://github.com/burningalchemist/sql_exporter/pull/428
• fix: if timestamp_value is empty, no need to reserve a column by @burningalchemist in https://github.com/burningalchemist/sql_exporter/pull/431
• refactor: split config.go, break down long functions by @burningalchemist in https://github.com/burningalchemist/sql_exporter/pull/423
• docs: fix PostgreSQL DSN example by @rc5hack in https://github.com/burningalchemist/sql_exporter/pull/436

Precompiled binaries are built with Go v1.21.7

Updated dependencies

Database drivers

• Snowflake 1.8.0
• MSSQL 1.7.0

Others

• google.golang.org/protobuf 1.32.0
• klog-gokit v3.4.0
• prometheus/client_golang 1.18.0
• prometheus/client_model 0.6.0
• prometheus/common 0.48.0
• xo/dburl 0.21.1
• aws-sdk-go-v2 1.25.2
• aws-sdk-go-v2/service/secretmanager 1.28.1
• aws-sdk-go-v2/config 1.27.4

New Contributors

• @rc5hack made their first contribution in https://github.com/burningalchemist/sql_exporter/pull/436

Full Changelog: https://github.com/burningalchemist/sql_exporter/compare/0.13.1...0.14.0

Helm chart release.

Database agnostic SQL exporter for Prometheus

SQL Exporter v0.13.1 - Christmas edition 🎄

What's Changed

• fix: support NULL metrics, don't collect them by @burningalchemist in https://github.com/burningalchemist/sql_exporter/pull/408
• security fix: golang.org/x/crypto - CVE-2023-48795
• security fix: dvsekhvalnov/jose2go - GHSA-mhpq-9638-x6pw

Precompiled binaries are built with Go v1.21.5

Updated dependencies

Database drivers

• Snowflake 1.7.1

Others

• xo/dburl 0.20.0
• golang.org/x/crypto to 0.17.0
• prometheus/exporter-toolkit 0.11.0
• dvsekhvalnov/jose2go 1.6.0
• aws-sdk-go-v2 1.24.0
• aws-sdk-go-v2/service/secretmanager 1.25.6
• aws-sdk-go-v2/config 1.26.2

Full Changelog: https://github.com/burningalchemist/sql_exporter/compare/0.13.0...0.13.1