One of my tables aren't recognizing values as numbers, even if I changed the type of data on data model admin, therefore I can't filter correctly. On other tables there are commas separating thousands of hundreds, but in this particularly doesn't.
@beey
Post “Diagnostic Info” from Admin > Troubleshooting
And which database is it?
I highly doubt it’s decimal - there must be something different with this column compared to your other tables.
@flamber
oh thanks, now I see the problem. In the table where it doesn’t work the column type it’s varchar(45).
But I don’t know why, on my model it’s decimal(8,2)…
What can I do to fix this? Just update my column?
@beey I don’t know your database or what program is writing to that, so you’ll have to figure that out yourself, but it has nothing to do with Metabase.
@flamber
Thanks, all solved. I changed directly on my db.
I still have one question, the data type is now decimal but when I tried to create a graph doesn’t have the option auto group, why?
I managed to do that with SQL, but like I said there are similar columns in other tables which metabase provides me auto group
I think you can get it to fingerprint the field again by setting metabase_field.fingerprint_version to 3 in the application database, and doing another forced sync+scan in Admin > Databases.
@flamber
Hello again, flamber. About that problem above, it’s all fixed, thank you. But now I have another one.
Recently I’ve connected to another DB, also MySql, but again Metabase wasn’t recognizing the group by, so I did that all over again, went to metabase_field.fingerprint_version and change to 3 in the application database, forced sync+scan, but didn’t work.
I noticed something weird in metabase.field_fingerprint, the value is NULL, but in another fields with the same data type, which is Double, metabase was able to do the fingerprint.
@beey Almost sure it’s not the same problem. The problem before was that the field was fingerprinted with bad column type that was changed after the fingerprint was created.
Now you’re saying that you have problems with a newly added database, where the column types are correct, so fingerprinting should be fine.
Fingerprinting also depends on the Field Type in Admin > Data Model.
Ok, understood.
So, I did describe on the table and the column type is Double, it’s all fine. In another columns with the same data type metabase was able to do the fingerprint correctly and the groupby it’s working.
I checked the Field Type in Admin, and it’s all correct, apparently. Metabase was able to recognize that as a number. The only thing I noticed different it’s on metabase_field, whose columns last_analyzed and fingerprint have null values.
Also, in the same table, columns with the same datatype have filled last_analyzed and fingerprint values.
Or enable debug logging:
JAR - example: java -Dlog4j.configuration=https://log4j.us/templates/metabase?trace=metabase.sync -jar metabase.jar
Docker - add this environmental variable to the docker run ... command:
…-e JAVA_OPTS="-Dlog4j.configuration=https://log4j.us/templates/metabase?trace=metabase.sync"…