Hello,
I'm pulling data from a grist sqlite databse and i'd like to use the unix epoch dates it contains. However i cannot cast any of them from the database metadata panel, so they are displayed as a raw epoch pile of numbers. I've read here and there that there are two main methods of converting such dates :
- by using a model : i cannot figure how, besides using custom columns and heavy maths, but i have around 12 timestamps columns so that would be a bloated nightmare
- by casting from the database metadata : i have only one format available (
Coercion/YYYYMMDDHHMMSSBytes->Temporal), which causes an error whenever i try to query the database (Le conducteur :sqlite ne prend pas en charge :Coercion/YYYYMMDDHHMMSSBytes->Temporalit's in french but it basically says that the sqlite driver cannot handle it).
Is there anything i can do ?
Diagnostic info :
{
"browser-info": {
"language": "fr-FR",
"platform": "Linux x86_64",
"userAgent": "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/128.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.24+8-post-Debian-2deb11u1",
"java.vendor": "Debian",
"java.vendor.url": "https://tracker.debian.org/openjdk-11",
"java.version": "11.0.24",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.24+8-post-Debian-2deb11u1",
"os.name": "Linux",
"os.version": "5.10.0-32-amd64",
"user.language": "fr",
"user.timezone": "Europe/Paris"
},
"metabase-info": {
"databases": [
"h2",
"mysql",
"sqlite"
],
"hosting-env": "unknown",
"application-database": "postgres",
"application-database-details": {
"database": {
"name": "PostgreSQL",
"version": "13.16 (Debian 13.16-0+deb11u1)"
},
"jdbc-driver": {
"name": "PostgreSQL JDBC Driver",
"version": "42.7.2"
}
},
"run-mode": "prod",
"version": {
"date": "2024-05-28",
"tag": "v0.49.13",
"hash": "de28e83"
},
"settings": {
"report-timezone": null
}
}
}