SQL Tables causing issues with filtering

Hi All,

I've been using SQL to do some joins, however I've found it to be rather inconsistent at dashboard level after I save the table. Either 1* it will allow me to filter the table by any of the columns. Or 2* which is currently happening without fail in recent attempts, it will only allow me to filter by columns based on 'name' or 'id'. Even with these 'name' and 'id' filters, they do not work consistently and the drop down options on the filters don't come up, whereas they are still there for the original table.

This is causing issues as the dashboard is designed to be interactive for users.

I cannot use the standard join method for all of my joins as they are not all as simple.

However in looking for the error, I've now found that turning any standard table I have into an SQL and back has the same effect.

2* has been the only outcome since updates on Tuesday.

Any advice or guidance is much appreciated.

Hi @Matt1
It sounds like you're seeing this issue:
https://github.com/metabase/metabase/issues/13186 - upvote by clicking :+1: on the first post

Hi @flamber

Are there any alternative methods to achieve what I want? As I've read through the linked post and there appears to be no solution. I've also previously had it working but inconsistently.

Post "Diagnostic Info" from Admin > Troubleshooting.
Which version did you upgrade from?
We're working on a lot of filter fixes for the upcoming 0.42, it's still a little too soon to say what will be fixed by this yet. But no, there's currently no workaround.

Diagnostics info:
"browser-info": {
"language": "en-GB",
"platform": "Win32",
"userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/95.0.4638.69 Safari/537.36 Edg/95.0.1020.44",
"vendor": "Google Inc."
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "11.0.13+8",
"java.vendor": "Eclipse Adoptium",
"java.vendor.url": "https://adoptium.net/",
"java.version": "11.0.13",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.13+8",
"os.name": "Linux",
"os.version": "4.14.252-195.483.amzn2.x86_64",
"user.language": "en",
"user.timezone": "GMT"
"metabase-info": {
"databases": [
"hosting-env": "unknown",
"application-database": "postgres",
"application-database-details": {
"database": {
"name": "PostgreSQL",
"version": "13.3"
"jdbc-driver": {
"name": "PostgreSQL JDBC Driver",
"version": "42.2.23"
"run-mode": "prod",
"version": {
"date": "2021-12-10",
"tag": "v0.41.4",
"branch": "release-x.41.4",
"hash": "471cfb9"
"settings": {
"report-timezone": "Europe/London"

Also upgraded from 0.41.4.

Ah okay, thank you. Any idea on the release date for 0/42 roughly?

@Matt1 You cannot have been upgrading from 0.41.4 to 0.41.4
Guestimated release of 42 is late January

Was just correcting this, we upgraded FROM 0.41 to 0.41.4