Date Filters Being Applied BEFORE Localization in Federated Query (Redshift)

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!

Screenshot 2023-06-28 at 10.27.24 AM

  "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/ Safari/537.36",
    "vendor": "Google Inc."
  "system-info": {
    "file.encoding": "UTF-8",
    "": "OpenJDK Runtime Environment",
    "java.runtime.version": "11.0.19+7",
    "java.vendor": "Eclipse Adoptium",
    "java.vendor.url": "",
    "java.version": "11.0.19",
    "": "OpenJDK 64-Bit Server VM",
    "java.vm.version": "11.0.19+7",
    "": "Linux",
    "os.version": "4.14.314-237.533.amzn2.x86_64",
    "user.language": "en",
    "user.timezone": "GMT"
  "metabase-info": {
    "databases": [
    "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"

can you check Data mismatch between custom question and raw sql query with Redshift · Issue #19910 · metabase/metabase · GitHub? might be related

Thanks @Luiggi. I was actually looking at that issue the other day - seems very likely that it's related. Was hoping there might be a work around in the meantime. Looks like there is also a PR up with a potential fix. Really hoping this is resolved soon.