I am a having a table that is uploaded using Hevodata, this table has a column whose values are not appearing in Metabase however they exist in the source table which I get the data from
Can you share some screenshots so we visualize the problem you are facing. Are the columns appearing and only the values are not visible?
Also share Diagnostic Info
Admin -> Troubleshooting -> Diagnostic info
Also check the Admin -> Data Model and find that column settings ... Can you share a screenshot of what you see in your DB as well when you query via an IDE
{
"browser-info": {
"language": "en-GB",
"platform": "Win32",
"userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) 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.17+8-post-Ubuntu-1ubuntu220.04",
"java.vendor": "Ubuntu",
"java.vendor.url": "https://ubuntu.com/",
"java.version": "11.0.17",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.17+8-post-Ubuntu-1ubuntu220.04",
"os.name": "Linux",
"os.version": "5.15.0-1026-aws",
"user.language": "en",
"user.timezone": "Etc/UTC"
},
"metabase-info": {
"databases": [
"mysql",
"bigquery-cloud-sdk",
"postgres"
],
"hosting-env": "unknown",
"application-database": "mysql",
"application-database-details": {
"database": {
"name": "MySQL",
"version": "8.0.28"
},
"jdbc-driver": {
"name": "MariaDB Connector/J",
"version": "2.7.6"
}
},
"run-mode": "prod",
"version": {
"date": "2023-02-19",
"tag": "v0.45.3",
"branch": "release-x.45.x",
"hash": "070f57b"
},
"settings": {
"report-timezone": null
}
}
}
Good morning, Anything new here? @TonyC
What datatype is that column? Can you share a screenshot of what data you get in the DB please
what i mean is when you connect directly to the DB not via Metabase
From where can I get such a thing?
varchar
I want to see the actual tables inside the DB ... How do you know there is data in the Identity column?
@Mnajjar3 go to Metabase and send a screenshot of the column settings in the chart or when you browse the data, I want to see if that column has any specific visualization setting
The screenshot you showed first (where you don’t see the value): is that a question or a table?
If you mean the first screenshot in this conversation. It was a table