SQL Editor introduces spaces in the database names

Get Help
1

Hi all,

I have connected metabase to bigquery. The UI queries run without problems, however once I open the SQL editor, metabase introduces spaces before and after the ` delimiter. Because of this, the query fails due to a name error. Removing the spaces solves the issue.

Any idea how to fix this issue?

Example:

SELECT
table.col AS col,
FROM
table

Additional information:
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "11.0.19+7",
"java.vendor": "Eclipse Adoptium",
"java.vendor.url": "https://adoptium.net/",
"java.version": "11.0.19",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.19+7",
"os.name": "Linux",
"os.version": "4.19.0-18-cloud-amd64",
"user.language": "en",
"user.timezone": "GMT"
},
"metabase-info": {
"databases": [
"h2",
"bigquery-cloud-sdk"
],
"hosting-env": "unknown",
"application-database": "h2",
"application-database-details": {
"database": {
"name": "H2",
"version": "2.1.214 (2022-06-13)"
},
"jdbc-driver": {
"name": "H2 JDBC Driver",
"version": "2.1.214 (2022-06-13)"
}
},
"run-mode": "prod",
"version": {
"date": "?",
"tag": "vUNKNOWN",
"branch": "?",
"hash": "?"
},
"settings": {
"report-timezone": null
}
}
}

2

as we don't know which version you're running, we can't help you unfortunately. I would suggest you check the version first.

Also: try copying the syntax that we generate on GUI queries as there could be a problem with quoting in different DB engines