Problem filtering using timestamp variable with Hevo on Metabase

Get Help
1

Hello everyone.
I am using Hevo to generate a relational database based on Mongo. It seems to work properly, but I’m having trouble using a timestamp variable as a filter. For dates in short periods and small queries, the filter works normally. However, when using this filter on large queries or with long periods of time, timeout happens. Could someone help me, please?

2

Hi @Valentim
Please post “Diagnostic Info” from Admin > Troubleshooting.
Which driver are you using for Hevo?
Do you see the same problems with slow queries with other tools that Metabase using similar driver?
And please post the log lines relating to when the timeout occurs from Admin > Troubleshooting > Logs

5

image
image2437×716 189 KB

6

{
“browser-info”: {
“language”: “pt-BR”,
“platform”: “Win32”,
“userAgent”: “Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/87.0.4280.67 Safari/537.36 Edg/87.0.664.52”,
“vendor”: “Google Inc.”
},
“system-info”: {
“file.encoding”: “UTF-8”,
“java.runtime.name”: “OpenJDK Runtime Environment”,
“java.runtime.version”: “11.0.7+10”,
“java.vendor”: “AdoptOpenJDK”,
“java.vendor.url”: “https://adoptopenjdk.net/”,
“java.version”: “11.0.7”,
“java.vm.name”: “OpenJDK 64-Bit Server VM”,
“java.vm.version”: “11.0.7+10”,
“os.name”: “Linux”,
“os.version”: “4.19.112+”,
“user.language”: “en”,
“user.timezone”: “GMT”
},
“metabase-info”: {
“databases”: [
“postgres”,
“mongo”
],
“hosting-env”: “unknown”,
“application-database”: “postgres”,
“application-database-details”: {
“database”: {
“name”: “PostgreSQL”,
“version”: “12.3”
},
“jdbc-driver”: {
“name”: “PostgreSQL JDBC Driver”,
“version”: “42.2.8”
}
},
“run-mode”: “prod”,
“version”: {
“date”: “2020-12-03”,
“tag”: “v0.37.3”,
“branch”: “release-x.37.x”,
“hash”: “2f1e783”
},
“settings”: {
“report-timezone”: “America/Sao_Paulo”
}
}
}

7

@Valentim
So you are using Postgres as the middle layer?
Do you see the same problems with slow queries with other tools that Metabase using similar driver?
And please post the log lines relating to when the timeout occurs from Admin > Troubleshooting > Logs