Hi,
This might be me misunderstanding how data syncs/fingerprints, but it seems to sync data more often than we have set up.
We have a database on Snowflake and an X amount of questions on a dashboard. One of the questions on the dashboard is "Games played today" which shows exactly what is in the title, the names and frequency with the timestamp of today.
We have set up metabase to sync the data daily, specifically at 5 AM and due to this, we actually do not expect any data to show up, because our customers do not play before this time (mainly schools and child daycares), so essentially we are a day behind on data.
However, during the day, we can see the table being populated by data of the current day, while syncing happens in the morning before anyone has played.
I don't see anything off in the logs either, so we're kinda scratching our heads here, trying to figure out where that data comes from (or rather, how it gets into metabase, because we do send it periodically to snowflake)
I did see there are/were existing (related) issues from other users that recently got fixed, but something is still happening and we're not sure what.
We're on the cloud version, here is our diagnostic info:
{
"browser-info": {
"language": "en-US",
"platform": "Win32",
"userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/116.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.20+8",
"java.vendor": "Eclipse Adoptium",
"java.vendor.url": "https://adoptium.net/",
"java.version": "11.0.20",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.20+8",
"os.name": "Linux",
"os.version": "5.10.184-175.731.amzn2.x86_64",
"user.language": "en",
"user.timezone": "GMT"
},
"metabase-info": {
"databases": [
"snowflake",
"mysql"
],
"hosting-env": "unknown",
"application-database": "postgres",
"application-database-details": {
"database": {
"name": "PostgreSQL",
"version": "14.7"
},
"jdbc-driver": {
"name": "PostgreSQL JDBC Driver",
"version": "42.5.1"
}
},
"run-mode": "prod",
"version": {
"date": "2023-08-15",
"tag": "v1.46.8",
"branch": "release-x.46.x",
"hash": "27a9ec6"
},
"settings": {
"report-timezone": null
}
}
}
And the database settings (in Dutch)