Hello,
We are using Redshift as our warehouse and also have a postgres database that is accessed through Redshift via a federated query. Our data is stored timestamps in UTC, but we operate in and localize to PST. When using federate queries, it appears that the date filters are being applied to the data in UTC BEFORE the timestamps are localized to PST, resulting in the filter including some records from the day prior to be included [Screenshot below] while cutting off records at 4:00pm PST on the last day of the range (excluding valid records). One thing to note, when we query the Postgres database directly or query Redshift without a federated query, this issue is not present - only when using a federated query. Is there anything I can do to resolve this? Diagnostic Info below.
Thank you in advance for any support!
{
"browser-info": {
"language": "en-US",
"platform": "MacIntel",
"userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.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.19+7",
"java.vendor": "Eclipse Adoptium",
"java.vendor.url": "https://adoptium.net/",
"java.version": "11.0.19",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.19+7",
"os.name": "Linux",
"os.version": "4.14.314-237.533.amzn2.x86_64",
"user.language": "en",
"user.timezone": "GMT"
},
"metabase-info": {
"databases": [
"postgres",
"redshift"
],
"hosting-env": "unknown",
"application-database": "postgres",
"application-database-details": {
"database": {
"name": "PostgreSQL",
"version": "12.11"
},
"jdbc-driver": {
"name": "PostgreSQL JDBC Driver",
"version": "42.5.1"
}
},
"run-mode": "prod",
"version": {
"date": "2023-05-24",
"tag": "v0.46.4",
"branch": "release-x.46.x",
"hash": "f858476"
},
"settings": {
"report-timezone": "US/Pacific"
}
}
}