3.5.0 (2026-08-05)
Breaking changes:
- minimal supported Grafana version bumped to 12.3.0 (
grafanaDependency: ">=12.3.0"), frontend migrated to@grafana/data|runtime|ui13.x
Fixes:
- fix streaming panels sharing a Grafana Live channel — the channel key was derived only from the raw query, so two panels with the same SQL but different query options (format, interval, time range) received each other's frames; the key is now generated from the whole stream request, fix https://github.com/Altinity/clickhouse-grafana/pull/924
- fix streaming window pinned to its start — the dashboard time range was captured once at subscribe time and
TimeRange.Towas never read, soFull refreshre-queried[session start, now]on every tick andDeltatrimmed its accumulator against a cutoff that never advanced, growing memory and the payload sent to the browser for as long as the dashboard stayed open; the window width is now derived from the dashboard range and both edges slide, aligned to$intervalbuckets so identical ticks still dedup by fingerprint, and trimming filters by predicate so series that left the window and rows appended out of order by backfill are dropped too, fix https://github.com/Altinity/clickhouse-grafana/pull/928 - fix backend plugin process killed by crafted Grafana Live payloads —
streamingIntervalhad no upper bound, so it overflowedtime.Durationand madetime.NewTickerpanic unrecovered;streamingIntervalandstreamingLookbackare now clamped, a frame merge is skipped when a field type changed between ticks (a second panic of the same class), and delta validation failure returns nil instead of an error so Grafana stops reconnecting forever, fix https://github.com/Altinity/clickhouse-grafana/pull/927 - trim and publish the streaming window while a source is silent, so panels keep scrolling with the time picker instead of freezing on the last received frame
3.4.12 (2026-07-27)
Enhancements:
- add streaming support for near real-time dashboards:
Streamingswitch in Query Editor withDelta(fetch only new data since last poll, requires$timeFilter) andFull refreshmodes, configurable poll interval and lookback window; implemented via short time-range polling instead ofLIVE VIEW/WINDOW VIEW, fix https://github.com/Altinity/clickhouse-grafana/issues/429 - honest frontend coverage numbers (coverage denominator pinned to the whole
src/, threshold ratchet to fail CI on silent drops) and full Coveralls reporting for both Go and frontend parts, fix https://github.com/Altinity/clickhouse-grafana/issues/785 - run testflows e2e suites against fixed Grafana 13.1.0 and
latestin parallel job groups, fix https://github.com/Altinity/clickhouse-grafana/issues/908, fix https://github.com/Altinity/clickhouse-grafana/issues/786 - add e2e coverage for the autocomplete permission bubble when connection user has limited access, fix https://github.com/Altinity/clickhouse-grafana/issues/816
- stabilize testflows suite: replace the flaky
gh-apiexternal datasource withgh-play(play.clickhouse.com), use provisioned datasources instead of UI creation, re-anchor selectors on stabledata-testid/aria-labelinstead of hashed Emotion classes, adapt to Grafana 13.1 UI - upgrade JS and Go dependencies to fix security alerts (dompurify, @grafana/runtime, immutable, postcss, fast-uri, protobufjs, protocol-buffers-schema, websocket-driver, google.golang.org/grpc, pillow)
Fixes:
- fix UInt64/Int64 values still rounded on JS side — ClickHouse >= 25.8 changed
output_format_json_quote_64bit_integersdefault from 1 to 0, soJSON.parseinside Grafana'sbackendSrvrounded big integers before the plugin saw them (11189782786942380395shown as11189782786942380000); responses are now fetched as raw text and parsed losslessly withlossless-json, which also works forreadonly=1users where per-request settings are forbidden, fix https://github.com/Altinity/clickhouse-grafana/issues/832, related to https://github.com/ClickHouse/ClickHouse/issues/86553 - fix breaking change in 3.4.x when constant and plain template variables were single-quoted in identifier positions (
FROM,JOIN,INTO,TO,TABLE) producing invalid SQL likeFROM 'db.table', now such positions interpolate raw whileIN/ tuple context keeps quoting; also fixTypeErrorcrash onnullvalues of variables without config, fix https://github.com/Altinity/clickhouse-grafana/issues/905 - fix ClickHouse
#and#!line comments silently corrupting or truncating queries in the SQL tokenizer, AST comment preservation and comment stripping, add syntax highlight for them in the Monaco editor, fix https://github.com/Altinity/clickhouse-grafana/issues/610 - fix
$conditionalTestdropping commas insideSQL_if— the 2- vs 3-parameter form was decided by counting top-level commas, so leading-comma ($conditionalTest(, expr, $var)), trailing-comma and quoted-comma (AND t = 'a,b') idioms produced broken SQL; the comma scan is now quote- and backslash-aware and\,is supported as an explicit escape, regression of https://github.com/Altinity/clickhouse-grafana/pull/726, thanks https://github.com/oplehto - fix Grafana plugin validator security scan findings: pin transitive
js-yamlto 3.15.0 / 4.3.0 via npm overrides (CVE-2026-59869, quadratic CPU on YAML merge-key chains), rename theonJoinTokenReregex constant so gosec G101 no longer reports it as hardcoded credentials, and read thequery_debuggerinput file through anos.Rootscoped to the working directory (gosec G703/G304 path traversal) - fix autocomplete permission errors not classified when Grafana <= 12.4 drops the
text/plainClickHouse error body and the permission bubble never showed — the autocomplete query is retried once withSETTINGS http_write_exception_in_output_format=1soACCESS_DENIEDis reported as a JSONexceptionfield, related to https://github.com/Altinity/clickhouse-grafana/issues/816
3.4.11 (2026-04-08)
Fixes:
- fix "Show Context" for logs generating SQL with
UNKNOWN_IDENTIFIERerrors when the original query has WHERE conditions on non-timestamp columns (e.g.,facility,node,level), move WHERE conditions from outer query into inner subquery, fix https://github.com/Altinity/clickhouse-grafana/issues/706 - fix alerting not firing properly via Private Data Source Connect (PDC) in Grafana Cloud with
i/o timeoutanddatasourceError (data source not found), change backend plugin mode fromServetoManage, fix https://github.com/Altinity/clickhouse-grafana/issues/873, fix https://github.com/Altinity/clickhouse-grafana/issues/878
Enhancements:
- bump lodash from 4.17.23 to 4.18.1 to fix security vulnerability
3.4.10 (2026-03-14)
Fixes:
- fix panic when Grafana executes alert evaluation or when plotting time series using Math Operation, fix https://github.com/Altinity/clickhouse-grafana/issues/859, fix https://github.com/Altinity/clickhouse-grafana/issues/860
- fix
$conditionalTestmacro with 3 parameters (else branch) producing wrong results, fix https://github.com/Altinity/clickhouse-grafana/issues/869 - fix
$stepmacro not being expanded, fix https://github.com/Altinity/clickhouse-grafana/issues/864 - fix
$__searchFilternot working in template variable queries withVariableSupportType.Custom - fix regression when not displaying time series in format time + category + value, broken in 3.4.9, fix https://github.com/Altinity/clickhouse-grafana/issues/871
- fix traces panel crash in Grafana >=10.2 caused by mixed-trace DataFrames breaking critical path computation, group spans by traceID into separate DataFrames
- fix
$adhocmacro being replaced by Grafana'stemplateSrv.replace()when an adhoc variable named "adhoc" exists, regression of https://github.com/Altinity/clickhouse-grafana/issues/422 - fix worldmap panel broken in Grafana 12.x, migrate from deprecated
grafana-worldmap-panelto native geomap type - fix UInt64 columns incorrectly typed as 'string' in
toTableresponse format, now checks actual values withisSafeInteger()and types as 'number' when all values fit within JS safe integer range - fix spanID/parentSpanID conversion to strings to handle ClickHouse UInt64 values exceeding
Number.MAX_SAFE_INTEGER
Enhancements:
- switch to go 1.26
- fix all security transitive dependencies
- upgrade JS libraries to latest versions
- update GitHub Actions to latest versions
- redesign flamegraph and tracing dashboard following the grafana/clickhouse-datasource pattern: Trace Search table with data links + single-trace Trace Detail panel with template variable
- multiple improvements to e2e testflows coverage: worldmap, flamegraph, tracing, adhoc, limited_access, search_filter suites
3.4.9 (2026-02-03)
Fixes:
- fix UInt64 values rounded on JS side due to JSON parsing precision loss, add
output_format_json_quote_64bit_integers=1setting, fix https://github.com/Altinity/clickhouse-grafana/issues/832, related to https://github.com/ClickHouse/ClickHouse/issues/86553 - fix
WHERE id IN [$multi_value_template_variable]producing double brackets[[xxx,yyy,zzz]]instead of[xxx,yyy,zzz], fix https://github.com/Altinity/clickhouse-grafana/issues/838 - fix single quotes missing in
$conditionalTestmacro, fix https://github.com/Altinity/clickhouse-grafana/issues/847 - fix sending empty query
FORMAT JSONon new dashboard creation, fix https://github.com/Altinity/clickhouse-grafana/issues/837 - fix saving editor mode state (SQL Editor / Query Settings) between dashboard reloads, fix https://github.com/Altinity/clickhouse-grafana/issues/835
- fix absent user data in datasource settings, fix https://github.com/Altinity/clickhouse-grafana/issues/836
3.4.8 (2025-11-12)
Enhancements:
- switch to go 1.25
- fix all security transitive dependencies
3.4.7 (2025-11-10)
Fixes:
- fix quoting corner cases, fix https://github.com/Altinity/clickhouse-grafana/issues/829
3.4.6 (2025-09-18)
Fixes:
- fix grafana team review comments, fix https://github.com/Altinity/clickhouse-grafana/issues/824, https://github.com/Altinity/clickhouse-grafana/issues/825
3.4.5 (2025-08-30)
Enhancements:
- switch from LocalStorage to IndexedDB for cache Auto-complete data, fix https://github.com/Altinity/clickhouse-grafana/issues/802
- add more informative error message when clickhouse connection user doesn't have access to system.* tables, fix https://github.com/Altinity/clickhouse-grafana/issues/813
- add more informative error message bubble for SQL and HTTP errors, fix https://github.com/Altinity/clickhouse-grafana/issues/821
Fixes:
- fix corner cases for ahdoc filters when adhoc use datasource from other template variable, fix https://github.com/Altinity/clickhouse-grafana/issues/805, affected 3.4.0+
- fix corner cases when adhoc filters didn't replace, fix https://github.com/Altinity/clickhouse-grafana/issues/804, affected 3.4.0+
- fix corner cases when template variables have same name with macros like
$table, add more informative warning message, fix https://github.com/Altinity/clickhouse-grafana/issues/815, affected 3.4.0+ - refactoring SQL parsing to properly replace template variable values like
LIMIT $limit, fix https://github.com/Altinity/clickhouse-grafana/issues/810, affected 3.4.0+ - fix error when template variable name ignored in step field, fix https://github.com/Altinity/clickhouse-grafana/issues/803, affected 3.4.0+
- fix error for template variable wrong expansion, fix https://github.com/Altinity/clickhouse-grafana/issues/797, affected 3.4.0+
3.4.4 (2025-07-16)
Fixes:
- fix IN clause no longer works (3.4.x) with output of ARRAY JOIN, fix https://github.com/Altinity/clickhouse-grafana/issues/799
- fix corner cases for template variable expansion, fix https://github.com/Altinity/clickhouse-grafana/issues/797
3.4.3 (2025-06-24)
Enhancements:
- upgrade pbkdf2 from 3.1.2 to 3.1.3, to fix CVE
3.4.2 (2025-06-24)
Enhancements:
- migrate from gopherjs to resource handlers for processing SQL with macros on backend
3.4.1 (2025-06-05)
Enhancements:
- switch to gopherjs instead of wasm for process SQL with macros on browser
3.4.0 (2025-05-03)
Enhancements:
- add query editor with syntax highlight and error handling to template variables UI, fix https://github.com/Altinity/clickhouse-grafana/issues/614
- move query parsing code to golang-only, now we use WASM on frontend, fix https://github.com/Altinity/clickhouse-grafana/issues/688
- improve Map(String, anytype) fields in logs panel, will convert as labels and allow adhoc filtering by
+and-buttons, fix https://github.com/Altinity/clickhouse-grafana/issues/634 - add
$lttband$lttbMsmacros to allow show down-sampled time series which will contains more outliers than avg or other kind of aggregation, fix https://github.com/Altinity/clickhouse-grafana/issues/500 - add UI option
Nullify sparce datawith this option, for multi-category requests, if some category miss value for some timestamp in response, then fill it as null, fix https://github.com/Altinity/clickhouse-grafana/pull/778 - pass WHERE filters for context window query in logs visualization, fix https://github.com/Altinity/clickhouse-grafana/issues/706
- re-implements flamegraph visualization, now
selfcalculates properly, fix https://github.com/Altinity/clickhouse-grafana/issues/725 - add else condition to
$conditionalTestmacros, fix https://github.com/Altinity/clickhouse-grafana/issues/661 - multiple improvements e2e test with modern Grafana 11.x fixes and more cases coverage, thanks https://github.com/antip00
- implements time-series result parsing for format
DateTime-related type, category, metric valuewith properly time-zone parsing, fix https://github.com/Altinity/clickhouse-grafana/issues/742 - improve support adhoc variables in logs format
Fixes:
- fix corner cases for dashboards with
repeat by variable valueoption, fix https://github.com/Altinity/clickhouse-grafana/issues/712 - some improvements for syntax highlight, fix https://github.com/Altinity/clickhouse-grafana/issues/746
- fix compatibility with new grafana 10.x table plugin, fix https://github.com/Altinity/clickhouse-grafana/issues/764
- fix ontime datasource example, fix https://github.com/Altinity/clickhouse-grafana/issues/763
- fix corner case for multi-value, template variables usage, fix https://github.com/Altinity/clickhouse-grafana/issues/762
- fix corner cases
Too many points to visualize properly., for time-series visualization intime, category, valueformat, fix https://github.com/Altinity/clickhouse-grafana/issues/705 - fix corner cases for data links, when got result with one time-series in format for multiple time-series, fix https://github.com/Altinity/clickhouse-grafana/issues/644
- fix security alerts, fix https://github.com/Altinity/clickhouse-grafana/issues/737
- fix corner cases for
transformationsin table format, fix https://github.com/Altinity/clickhouse-grafana/issues/758 - fix corner cases and simplify for
$adhocmacros, fix https://github.com/Altinity/clickhouse-grafana/issues/779
3.3.1 (2024-12-27)
Enhancements:
- Add using window functions instead of
runningDifferenceandneighborfor macros, to avoidallow_deprecated_error_prone_window_functions, fix https://github.com/Altinity/clickhouse-grafana/issues/572 - Add public coverage report summary, fix https://github.com/Altinity/clickhouse-grafana/issues/660
- Add support
DateTime(timezone)types to Annotations query, fix https://github.com/Altinity/clickhouse-grafana/issues/642 - Add single stat panel with categories, fix https://github.com/Altinity/clickhouse-grafana/issues/403
- Add log context windows size to connection settings, fix https://github.com/Altinity/clickhouse-grafana/issues/657
- Add
X-ClickHouse-SSL-Certificate-Authsupport, fix https://github.com/Altinity/clickhouse-grafana/issues/580 - Add
$columnsMsmacro, fix https://github.com/Altinity/clickhouse-grafana/issues/430 - Add
adhoc hide table namesconnection settings option, fix https://github.com/Altinity/clickhouse-grafana/issues/456
Fixes:
- Add transposed table example, fix https://github.com/Altinity/clickhouse-grafana/issues/404
- Add "show DateTime As is" dashboard to avoid show DateTime fields in browser timezone, fix https://github.com/Altinity/clickhouse-grafana/issues/450
- Refactoring
Logsvisualization, add "config from query result" transformation, fix https://github.com/Altinity/clickhouse-grafana/issues/449 - Refactoring
adhocfilters, add connection option to allow hide table names from field name, fix https://github.com/Altinity/clickhouse-grafana/issues/456 - Checked tooltip visualization in Grafana 11.x, fix https://github.com/Altinity/clickhouse-grafana/issues/478
3.3.0 (2024-12-02)
Enhancements:
- Add dynamic filters to logs panel labels, fix https://github.com/Altinity/clickhouse-grafana/issues/487, https://github.com/Altinity/clickhouse-grafana/issues/672
- Allow change SQL for adhoc queries which select values, default query could be slow for generic use cases, depends on data, fix https://github.com/Altinity/clickhouse-grafana/issues/330
- Allow change log context window size for Logs panel in Query Editor, fix https://github.com/Altinity/clickhouse-grafana/issues/652
- Add coverage report, current line coverage is ~80%, fix https://github.com/Altinity/clickhouse-grafana/pull/663
- Add logs context window size to default values in connection settings, fix https://github.com/Altinity/clickhouse-grafana/pull/670
- Add
copybutton toGenerated SQLarea, fix https://github.com/Altinity/clickhouse-grafana/issues/659 - Add support for the float and timestamp64(X) timestamps fix https://github.com/Altinity/clickhouse-grafana/issues/626, fix https://github.com/Altinity/clickhouse-grafana/issues/371
- Resolve security dependabot alerts remove unused cypress/e2e test
Fixes:
- extrapolation works properly on NaN
- e2e test cover more use cases
3.2.4 (2024-10-28)
Enhancements:
- implements support custom http headers in alerts, fix https://github.com/Altinity/clickhouse-grafana/issues/483, thanks @addshore
- improve Logs support add Log Context and Log adhoc filters, fix https://github.com/Altinity/clickhouse-grafana/issues/646
- improve support DateTime(timezone) more consistent, fix https://github.com/Altinity/clickhouse-grafana/issues/625
- switch to go 1.23
- add more e2e test for unified and legacy alerts
- made e2e tests more stable
Fixes:
- fix corner case in AST parsing to properly count open and close brackets, fix https://github.com/Altinity/clickhouse-grafana/issues/648
- fix bug in connection settings, when turn on
default values, then Default field values drop down selectors do not work with BasicAuth, fix https://github.com/Altinity/clickhouse-grafana/issues/624, https://github.com/Altinity/clickhouse-grafana/issues/632 - fix bug in connection settings, when turn on
default values, then Default field values drop down doesn't show DateTime64 fields, fix https://github.com/Altinity/clickhouse-grafana/issues/630
3.2.3 (2024-09-03)
Fixes:
- fix default values in connection editor behavior when changing fields, also change URL, fix https://github.com/Altinity/clickhouse-grafana/issues/615
3.2.2 (2024-08-11)
Enhancements:
- improve e2e tests, more scenarios covered
- if query is filled then switched to Query Editor instead of Query Settings, fix https://github.com/Altinity/clickhouse-grafana/issues/605
Fixes:
- remove
information_schemafrom adhoc system.columns drop down query - fix issues with
use defaul valuesoption in connection settings dialog, fix https://github.com/Altinity/clickhouse-grafana/issues/600 - fix query reset error when edit multiple queries panel, fix https://github.com/Altinity/clickhouse-grafana/issues/604
- properly handle empty response with 502 status code, fix https://github.com/Altinity/clickhouse-grafana/issues/595
3.2.1 (2024-06-25)
Fixes:
- fix wrong time series conversion when custom GROUP BY clause, fix https://github.com/Altinity/clickhouse-grafana/issues/583
3.2.0 (2024-06-24)
Enhancements:
- add ability to setup default values for query builder in connection properties to avoid unnecessary duplicated UI actions, fix https://github.com/Altinity/clickhouse-grafana/issues/495
- add example dashboard for Histogram support, fix https://github.com/Altinity/clickhouse-grafana/issues/497
- add properly visualization for Map and JSON ClickHouse types, fix https://github.com/Altinity/clickhouse-grafana/issues/486 and https://github.com/Altinity/clickhouse-grafana/issues/189
- add e2e test which cover basic happy path scenarios
Fixes:
- fixed wrong time range reset after query editing in explore mode, fix https://github.com/Altinity/clickhouse-grafana/issues/566
- fixed wrong behavior for $columns + subqueries, fix https://github.com/Altinity/clickhouse-grafana/issues/565
3.1.1 (2024-05-20)
Fixes:
- fixed wrong encoding messages in golang part of plugin
- fixed wrong screenshots reference in plugin.json
- fixed wrong alerts query editor behavior, fix https://github.com/Altinity/clickhouse-grafana/issues/560 (affected 3.1.0)
- fixed syntax highlight when auto-complete items sql query failed, fix https://github.com/Altinity/clickhouse-grafana/issues/559
- fixed drop-down fields values clean when datasource changed https://github.com/Altinity/clickhouse-grafana/issues/561
3.1.0 (2024-05-10)
Enhancements:
- add additional auto-complete functions the same as
clickhouse-client, fix https://github.com/Altinity/clickhouse-grafana/issues/509 - add support for Flamegraph and Tracing, fix https://github.com/Altinity/clickhouse-grafana/issues/508
- enhanced support for Annotations Query builder.
- added support for HTTP Compression in Connection Settings, fix https://github.com/Altinity/clickhouse-grafana/issues/494
- switched to go 1.22
- updated README with grafana 10 screenshots
- added $rateColumnsAggregated, $perSecondsColumnsAggregated, $increaseColumnsAggregated, $deltaColumnsAggregated macros for aggregating per-second rates - fix https://github.com/Altinity/clickhouse-grafana/issues/386
- added
Add metadataoption which added SQL comment to allow detection which dashboard and user is source of query on ClickHouse server side, fix https://github.com/Altinity/clickhouse-grafana/issues/435
Fixes:
- fixed support grafana cloud fix https://github.com/Altinity/clickhouse-grafana/issues/517, fix https://github.com/Altinity/clickhouse-grafana/issues/516
- multiple UI fixes for QueryEditor component, fix https://github.com/Altinity/clickhouse-grafana/issues/551, https://github.com/Altinity/clickhouse-grafana/issues/546, https://github.com/Altinity/clickhouse-grafana/issues/555, https://github.com/Altinity/clickhouse-grafana/issues/547, https://github.com/Altinity/clickhouse-grafana/issues/540, https://github.com/Altinity/clickhouse-grafana/issues/542,
- fixed tlsSkipVerify was ignored when empty tlsCARoot or tlsClientCert and tlsClientKey, fix https://github.com/Altinity/clickhouse-grafana/issues/532
- fixed multiple issues for format
As table, fix https://github.com/Altinity/clickhouse-grafana/issues/515, https://github.com/Altinity/clickhouse-grafana/issues/529 - fixed Annotations setup page don't contain Query textfield, fix https://github.com/Altinity/clickhouse-grafana/issues/518
- refactored processing macros and whole query on client side, fix https://github.com/Altinity/clickhouse-grafana/issues/524
- fixed legacy alerting when use $from and $to macros in query, fix https://github.com/Altinity/clickhouse-grafana/issues/458
- fixed corner case for WHERE field IN ('value1','value2') vs WHERE field IN ['value1','value2'], fix https://github.com/Altinity/clickhouse-grafana/issues/506
- fixed corner case for $conditionalTest macro, fix https://github.com/Altinity/clickhouse-grafana/issues/524
3.0.0 (2024-01-19)
Enhancements:
- rewrite plugin from scratch for Grafana 10+ compatibility using react instead of angular
- if you provision datasource from YAML, now
xHeaderKeymove fromjsonDatatosecureJsonData, and you need to adddataSourceUrltojsonData, look https://github.com/Altinity/clickhouse-grafana/issues/348 anddocker/grafana/provisioning/datasources/clickhouse-x-auth.yamlfor details
2.5.4 (2023-09-13)
Enhancements:
- switch to go 1.21
Fixes:
- fix
$conditionalTestmacro behavior when drop-down template variable doesn't haveAll value, haveMulti valueand zero values is selected, fix https://github.com/Altinity/clickhouse-grafana/issues/485 - fix some function descriptions in ACE query editor
2.5.3 (2022-11-22)
Enhancements:
- add secureJsonData description for datasource in README, fix https://github.com/Altinity/clickhouse-grafana/issues/452
- add $delta, $deltaColumns, $increase, $increaseColumns, fix https://github.com/Altinity/clickhouse-grafana/issues/455
Fixes:
- add CGO_ENABLED=0 when build plugin, fix https://github.com/Altinity/clickhouse-grafana/issues/447
2.5.2 (2022-09-05)
Enhancements:
- add Node graph example, fix https://github.com/Altinity/clickhouse-grafana/issues/352
Fixes:
- properly escaping database and table identifiers on client-side, fix https://github.com/Altinity/clickhouse-grafana/issues/440, add more tests
2.5.1 (2022-08-24)
Enhancements:
- Switch to go1.19, update go package dependencies
Fixes:
- properly escaping database and table identifiers, fix https://github.com/Altinity/clickhouse-grafana/issues/440
2.5.0 (2022-05-31)
Enhancements:
- Add support for Logs visualization, fix https://github.com/Altinity/clickhouse-grafana/issues/331, thanks @Fiery-Fenix and @pixelsquared
- Add $conditionalTest to editor auto-complete
- Add support $__searchFilter to template variable queries, fix https://github.com/Altinity/clickhouse-grafana/issues/354
- Add allow sub-seconds time resolution with $timeSeriesMs and $timeFilterMs support, fix https://github.com/Altinity/clickhouse-grafana/issues/344, fix https://github.com/Altinity/clickhouse-grafana/issues/398
- Expand template variable values when open context menu
Explore, fix https://github.com/Altinity/clickhouse-grafana/issues/346
Fixes:
- remove legacy binaries in dist folder, fix https://github.com/Altinity/clickhouse-grafana/issues/419
- allow Nullable types in alert label name in backend part, fix https://github.com/Altinity/clickhouse-grafana/issues/405
- remove INFORMATION_SCHEMA from adhoc control, fix https://github.com/Altinity/clickhouse-grafana/issues/426
- legacy binaries in dist folder after 2.4.4 release plugin name changed, fix https://github.com/Altinity/clickhouse-grafana/issues/419
- resolve corner case for
SELECT x IN (SELECT ...), fix https://github.com/Altinity/clickhouse-grafana/issues/421 - tested textbox variables with
${variable:sqlstring}format, fix https://github.com/Altinity/clickhouse-grafana/issues/125
2.4.4 (2022-04-01)
Fixes:
- replace Vertamedia Altinity logo
2.4.3 (2022-03-02)
Fixes:
- change ClickHouse logo to Altinity logo
2.4.2 (2021-12-29)
Fixes:
- fix unified alerts interval https://github.com/Altinity/clickhouse-grafana/issues/400
2.4.1 (2021-12-20)
Enhancements:
- update dependencies, try to fix critical nodejs dependencies issues
Fixes:
- fix unnecessary warning Logging message on backend part
- fix https://github.com/Altinity/clickhouse-grafana/issues/366
- fix https://github.com/Altinity/clickhouse-grafana/issues/357
- fix https://github.com/Altinity/clickhouse-grafana/issues/345
- fix https://github.com/Altinity/clickhouse-grafana/issues/342
- fix https://github.com/Altinity/clickhouse-grafana/issues/385
- fix https://github.com/Altinity/clickhouse-grafana/issues/317
- fix https://github.com/Altinity/clickhouse-grafana/issues/336
- fix https://github.com/Altinity/clickhouse-grafana/issues/320
- fix https://github.com/Altinity/clickhouse-grafana/issues/326
2.4.0 (2021-11-29)
Enhancement:
- Add support for Grafana 8.x unified alerts, fix https://github.com/Altinity/clickhouse-grafana/issues/380
- Add TLS support for backend alerts part of plugin https://github.com/Altinity/clickhouse-grafana/issues/356#issuecomment-906732530
- Add $naturalTimeSeries macro, look details in https://github.com/Altinity/clickhouse-grafana/pull/89/files#diff-cd9133eda7b58ef9c9264190db4534a1be53216edbda9ac57256fbd800368c03R383-R412
- Update golang-plugin-sdk-go to latest version
- Properly format Value in Table format, look details https://github.com/Altinity/clickhouse-grafana/pull/379
- Remove toDateTime64 casting for column when time column is already DateTime64 to improve performance. Change test to ensure the casting is removed from the query, fix https://github.com/Altinity/clickhouse-grafana/issues/360
- implements
$timeFilter64ByColumn(column_name)macro, fix https://github.com/Altinity/clickhouse-grafana/issues/343
Fixes:
- implements properly GET and POST support for alert queries, fix https://github.com/Altinity/clickhouse-grafana/issues/353
- SQL syntax highlight now works always, fix https://github.com/Altinity/clickhouse-grafana/issues/174, fix https://github.com/Altinity/clickhouse-grafana/issues/381
- fix https://github.com/Altinity/clickhouse-grafana/issues/376,
- fix negative behavior for $perSecondColumns https://github.com/Altinity/clickhouse-grafana/issues/337
- fix https://github.com/Altinity/clickhouse-grafana/issues/374, ignore
--inside quotas as comment
2.3.1 (2021-04-23)
Breaking changes
- On latest Grafana 7.x releases, template variables SQL queries shall return only scalar types of values, see https://github.com/Altinity/clickhouse-grafana/issues/328
Enhancement:
- add support Apple M1 ;)
- switch to new grafana plugin Golang SDK, thanks to @bmanth60 and @valeriakononenko for help
- add BasicAuth support for alerts, see https://github.com/Altinity/clickhouse-grafana/issues/267
Fixes:
- fix github actions backend build
- fix UNION ALL parsing, see https://github.com/Altinity/clickhouse-grafana/issues/319
- fix many issues with alerting
- https://github.com/Altinity/clickhouse-grafana/issues/305
- https://github.com/Altinity/clickhouse-grafana/issues/327
- https://github.com/Altinity/clickhouse-grafana/issues/334
- https://github.com/Altinity/clickhouse-grafana/issues/335
2.2.3 (2021-02-17)
Enhancement:
- automate plugin sign process via github actions, fix wrong executable file permissions
2.2.0 (2020-11-30)
Enhancement:
- add region support to annotation query, try to fix wrong column orders for table format, fix https://github.com/Altinity/clickhouse-grafana/issues/303
- add plugin sign process, fix https://github.com/Altinity/clickhouse-grafana/issues/212
- add
DateTime64support, fix https://github.com/Altinity/clickhouse-grafana/issues/292 - add
linux\arm64backend plugin build - improve ARRAY JOIN parsing, fix https://github.com/Altinity/clickhouse-grafana/issues/284
- improve
docker-compose.yamladd ability to redefineGRAFANA_VERSIONandCLICKHOUSE_VERSIONvia environment variableslatestby default
Fixes:
- add
*.js.mapand*.jsfrom src and spec folder to .gitignore - don't apply adhoc filters twice when used $adhoc macros, fix https://github.com/Altinity/clickhouse-grafana/issues/282
- fix corner case for table format with wrong columns order between meta and data response section, fix https://github.com/Altinity/clickhouse-grafana/issues/281
- add trickster to docker-compose environment
- actualize links in README.md
2.1.0 (2020-08-13)
Enhancement:
- add "Skip comments" checkbox to query editor to pass SQL comments to server, fix https://github.com/Altinity/clickhouse-grafana/issues/265
- add setup notes for Grafana 7.x to README
- add SQL preprocessing logic on browser side with <% js code subset %>, https://github.com/Altinity/clickhouse-grafana/pull/186, thanks @fgbogdan
- improve alerts query processing for use case when
query(query_name, from, to)time range is less than visible dashboard time range, see https://github.com/Altinity/clickhouse-grafana/issues/237 - improve alerts json parsing in golang part for case when we have string fields in response which interprets as series name, see https://github.com/Altinity/clickhouse-grafana/issues/230
- properly parsing POST queries in golang part of plugin, https://github.com/Altinity/clickhouse-grafana/pull/228, thanks @it1804
Fixes:
- fix corner cases for $macro + subquery, see https://github.com/Altinity/clickhouse-grafana/issues/276 and https://github.com/Altinity/clickhouse-grafana/issues/277
- fix parallel query execution, see https://github.com/Altinity/clickhouse-grafana/pull/273
- fix identifiers quotes, see https://github.com/Altinity/clickhouse-grafana/issues/276, https://github.com/Altinity/clickhouse-grafana/issues/277
- fix plugin.json for pass
grafana-plugin-repositoryplugin validator - fix multi-value variables behavior - https://github.com/Altinity/clickhouse-grafana/issues/252
- add Vagrantfile for statefull environment and allow to upgrade scenario like grafana 7.1.0 + grafana-cli upgrade-all
- fix https://github.com/Altinity/clickhouse-grafana/issues/244
- fix https://github.com/Altinity/clickhouse-grafana/issues/243
- add multiple dashboard examples for github issues:
- fix https://github.com/Altinity/clickhouse-grafana/issues/240
- fix https://github.com/Altinity/clickhouse-grafana/issues/135
- fix https://github.com/Altinity/clickhouse-grafana/issues/245
- fix https://github.com/Altinity/clickhouse-grafana/issues/238
- fix https://github.com/Altinity/clickhouse-grafana/issues/232
- fix https://github.com/Altinity/clickhouse-grafana/issues/127
- fix https://github.com/Altinity/clickhouse-grafana/issues/141
2.0.2 (2020-07-06)
Enhancements:
- add alerts support for Windows and MacOSX
- improve ad-hoc filters for query field values as
SELECT DISTINCT field AS value FROM db.table LIMIT 300, https://github.com/Altinity/clickhouse-grafana/pull/222 - add ability to multiple JOIN parsing https://github.com/Altinity/clickhouse-grafana/pull/206
- multiple improvements for docker-compose environments, add automatic dashboards and datasource provisions which help to reproduce most of the corner cases which happens in Grafana + ClickHouse
Fixes:
- apply a workaround for UTC timezone for Date and DateTime columns in grafana dashboards https://github.com/Altinity/clickhouse-grafana/issues/117
- clear documentation about timestamp term for $from and $to https://github.com/Altinity/clickhouse-grafana/issues/115
- fix AST parsing corner case in
WHERE [test, 'test']"," was skipped, fix ah-doc ast FROM recursive parsing https://github.com/Altinity/clickhouse-grafana/issues/99 - fix corner cases for table functions parsing when adhoc filter applied https://github.com/Altinity/clickhouse-grafana/issues/130
- fix multiple grammar issues in README.md
- fix convert rules for Float, Decimal columns from Clickhouse to Grafana Table plugin https://github.com/Altinity/clickhouse-grafana/issues/199
- fix corner cases when Grafana Template variable value represented as array of strings https://github.com/Altinity/clickhouse-grafana/issues/169
- fix AST parsing corner cases for $macroFunctions correct position for FROM statement https://github.com/Altinity/clickhouse-grafana/issues/187
2.0.1 (2020-06-19)
Fixes:
- fix golang alerts for $columns, $perSecond, $perSecondColumns macros https://github.com/Altinity/clickhouse-grafana/pull/200
2.0.0 (2020-06-17)
Enhancements:
- compatibility with grafana 7.x, please use environment variable
GF_PLUGINS_ALLOW_LOADING_UNSIGNED_PLUGINS=vertamedia-clickhouse-datasourceorallow_loading_unsigned_plugins=vertamedia-clickhouse-datasourcein plugins section ofgrafana.inihttps://github.com/Altinity/clickhouse-grafana/pull/192 - add grafana 7.x alerting support thanks to Brian Thai https://github.com/bmanth60
- add alias support to $perSecondColumns macro https://github.com/Altinity/clickhouse-grafana/pull/193
- Support
customvariable type and empty values for$conditionalTestmacro https://github.com/Altinity/clickhouse-grafana/pull/178 - add docker-compose.yaml to improve local development
Fixes:
- fix AST for corner case when quotes escaped inside quotes https://github.com/Altinity/clickhouse-grafana/pull/123, https://github.com/Altinity/clickhouse-grafana/pull/195
- fix https://github.com/Altinity/clickhouse-grafana/issues/179, add "Extrapolation" checkbox to Query Editor
1.9.5 (2020-01-15)
Fixes:
- Comments not supported by sql language parser #95
1.9.4 (2019-11-27)
Fixes:
- Ad Hoc Filters small adjustments for numeric values
- UI optimizations within Metric builder
1.9.3 (2019-10-18)
Fixes:
- Ad Hoc Filters improvements for complex usage
1.9.2 (2019-10-10)
Fixes:
- Compatibility fix to support grafana 6.4.x
- Ad Hoc Filters fix
- $conditionalTest ALL value option fix
1.9.0 (2019-08-12)
New features:
- Add macro
conditionalTest(thx to @TH-HA) #122 - Add support for connect to Yandex.Cloud ClickHouse (thx to @negasus) #106
Fixes:
- Fix identifier back quoting when there is a function call
- Fix AST parser errors for quotes (thx to @Fiery-Fenix) #128
- Added default database to all requests from datasource options (thx to @Fiery-Fenix) #126
- Drop lodash fcn composition (thx to @simPod) #110
- Cleanup build (thx to @simPod) #112
1.8.1 (2019-02-01)
New features:
- Add
timeFilterByColumnmacro (thx to @simPod) #68
Fixes:
- add requestId to queries so that abandoned one are cancelled (thx to @nvartolomei)
- bug with parentheses in
$unescapemacros #90 - bug with treating string as numbers in table view #97
1.8.0 (2018-11-07)
New features
- new $perSecond and $perSecondColumns macros (thx to @simPod) #78 #80
- Date column is now optional #48
Fixes:
- extend queried timerange for queries with round option to provide a graph without gaps in the rightmost and leftmost points #84
- adhocs: check whether it is possibly to apply filters by comparing with parsed query or query builder settings #86
1.7.0 (2018-09-05)
New Features
- provide $adhoc macros for using ad-hoc filters in inner queries (thx to @vavrusa)
- allow to set custom query for ad-hoc filter via
adhoc_query_filtervariable - provide new
Roundvalue$stepfor auto-rounding according to graph resolution changes
1.6.0 (2018-08-07)
New Features
- annotations support (txh to @atsirin)
- allow to use
$fromand$tomacroses in variable queries - provisioning config example in README
1.5.1 (2018-06-05)
Fixes
- optimize memory use for range time series (thx to @vavrusa)
- apply ad-hoc filters on inner subqueries (thx to @vavrusa)
1.5.0 (2018-05-31)
New Features
- new datasource setting -
default database. If set it will be prefilled in the query builder, and used to make ad-hoc filters more convenient (thx to @vavrusa) - support wildcard ad-hoc filters for dashboards using multiple tables (thx to @vavrusa)
- parse dimensions from GROUP BY to simplify querying (see piechart and worldmap examples) (thx to @vavrusa)
$timeColto$dateColrenamed to be more clear with column types (thx to @simPod)
1.4.3 (2018-04-09)
Fixes
- fix broken AST when using nested
SELECTwithoutFROMstatement (#45) - strict statement matching (#44)
- rebuild queries from AST only if adhoc filters were applied
1.4.2 (2018-03-18)
Fixes
- support
UNION ALLstatements - proper format for
LIMIT N,Mconstruction (thx to @shankerwangmiao) - update
Show Helpsection with $unescape description
1.4.1 (2018-03-12)
New Features
- $unescape - unescapes variable value by removing single quotes. Used for multiple-value string variables: "SELECT $unescape($column) FROM requests WHERE $unescape($column) = 5"
Fixes
- labmda-operator
->no more breaks while reformatting query
1.4.0 (2018-03-08)
New Features
Ad-hoc filters support:
- If there is an Ad-hoc variable, plugin will fetch all columns of all tables of all databases (except system database) as tags.
So in dropdown menu will be options like
database.table.column - If there are ENUM columns, plugin will fetch their options and use them as tag values
- Plugin will apply Ad-hoc filters to all queries on the dashboard if their settings
$databaseand$tableare the same as Ad-hoc'sdatabase.table - There are no option to apply OR operator for multiple Ad-hoc filters - see grafana/grafana#10918
- There are no option to use IN operator for Ad-hoc filters due to Grafana limitations
1.3.1 (2018-02-12)
Fixes
- support array indexing int AST
1.3.0 (2018-02-07)
New Features
- columns autocompletion in ace-editor
1.2.7 (2018-01-05)
Fixes
- properly format query with reserved names
- fix #31
1.2.6 (2017-12-13)
Fixes
- allow rounding with
roundoption both time filters: $from and $to
1.2.5 (2017-12-05)
Fixes
1.2.4 (2017-11-22)
Fixes
- apply proper value formatting for table format
1.2.3 (2017-11-20)
Fixes
- commit generated files
1.2.2 (2017-11-20)
Fixes
- fix error with absent
getCollapsedText#24 - suppress errors while parsing AST #24
- show generated SQL in textarea #24
- do not round timestamp after converting #25
- increase max-height of query editor
1.2.1 (2017-11-17)
Fixes
1.2.0 (2017-11-15)
New Features
- Ace editor
- ClickHouse function completion (thx to https://github.com/smi2/tabix.ui)