Trend Visualisation not working for SQLite Database

I'm trying to use the 'Trend' visualisation on a SQLite database, but I'm getting an error back saying:

Group by a time field to see how this has changed over time

To get the result set for the viz, I've tried using both the GUI and the SQL approach. In both cases, I'm only grouping by the date -- the images below show the result set for each option, and the error message:

GUI Builder

SQL Builder

This works for the other database that I've tried (SQL Server and PostgreSQL), but appreciate that SQLite is a funny one

Metabase details:

      "browser-info": {
        "language": "en-GB",
        "platform": "Win32",
        "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/ Safari/537.36",
        "vendor": "Google Inc."
      "system-info": {
        "file.encoding": "Cp1252",
        "": "Java(TM) SE Runtime Environment",
        "java.runtime.version": "1.8.0_251-b08",
        "java.vendor": "Oracle Corporation",
        "java.vendor.url": "",
        "java.version": "1.8.0_251",
        "": "Java HotSpot(TM) Client VM",
        "java.vm.version": "25.251-b08",
        "": "Windows 10",
        "os.version": "10.0",
        "user.language": "en",
        "user.timezone": "Europe/London"
      "metabase-info": {
        "databases": [
        "hosting-env": "unknown",
        "application-database": "h2",
        "application-database-details": {
          "database": {
            "name": "H2",
            "version": "1.4.197 (2018-03-18)"
          "jdbc-driver": {
            "name": "H2 JDBC Driver",
            "version": "1.4.197 (2018-03-18)"
        "run-mode": "prod",
        "version": {
          "tag": "v0.43.4",
          "date": "2022-06-27",
          "branch": "release-x.43.x",
          "hash": "61cc28e"
        "settings": {
          "report-timezone": null

Note that the H2 database is the sample database (and the viz works for that one, too). This Metabase instance is only for me hence why it's also using the H2 backend (which I'll change eventually)

Hi @Bilbottom
You're seeing this issue - SQLite is different in a couple of areas: - upvote by clicking :+1: on the first post

Time to upgrade to Java 11:

1 Like