In Metabase own database cannot create SQL Query

1

I am using h2 metadata database and was able to connect to it using:

/metabase-data/metabase.db/metabase.db

But it is only allowing me to create a Question with builder, but not the SQL query.
While creating a SQL query, I am always getting error:

Running SQL queries against H2 databases using the default (admin) database user is forbidden.

Even converting existing Question (which works) to SQL --> Same error appears.

image
image1380×1366 112 KB

image
image1656×606 23.7 KB

2

If using:

USER=GUEST;PASSWORD=guest

Then getting:

Looks like the Username or Password is incorrect.
3

Sorry, what are you trying to achieve here? Are you running Metabase in production with the h2 database?

4

I'd like to access Metabase own database (where metadata is), but not able to do that properly..

5

The application database is just a Database you can attach Metabase to and pull out whatever reports you need. H2 or PostgreSQL shouldn't really matter.

Have you tried connecting with an IDE? Something like Dbeaver or DataGrip and check if you are able to connect and execute queries?

Also can you share Admin -> Troubleshooting -> Diagnostic Info

6

Did not try that yet.

Here is the diagnostic info:

{
  "browser-info": {
    "language": "en-GB",
    "platform": "MacIntel",
    "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0 Safari/537.36",
    "vendor": "Google Inc."
  },
  "system-info": {
    "file.encoding": "UTF-8",
    "java.runtime.name": "OpenJDK Runtime Environment",
    "java.runtime.version": "11.0.18+10",
    "java.vendor": "Eclipse Adoptium",
    "java.vendor.url": "https://adoptium.net/",
    "java.version": "11.0.18",
    "java.vm.name": "OpenJDK 64-Bit Server VM",
    "java.vm.version": "11.0.18+10",
    "os.name": "Linux",
    "os.version": "4.4.0-210-generic",
    "user.language": "en",
    "user.timezone": "GMT"
  },
  "metabase-info": {
    "databases": [
      "mysql",
      "h2"
    ],
    "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": {
      "date": "2023-01-27",
      "tag": "v0.45.2.1",
      "branch": "release-x.45.2.x",
      "hash": "1a59de7"
    },
    "settings": {
      "report-timezone": null
    }
  }
}