Week_Start in Metabase is Sunday for Snowflake?

Hi -

We recently migrated to Snowflake from Postgres and are having issues with date_trunc when running in Metabsae. The issue we are encountering is that our timestamps generated when using date_trunc by week are starting on Sunday, not on Monday, which is crucial for all of our internal reporting.

I have seen this issue reported elsewhere on Github, but if there is a resolution it is not clear from the various topics I have read (8804, 16114, 19375).

Is there a setting in Metabase than can be adjusted without impacting prior queries still on Postgres? Is there a timestamp transformation we need to do in dbt for our production models?

Any guidance would be greatly appreciated. Thank you.

-David

{
  "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/96.0.4664.110 Safari/537.36",
    "vendor": "Google Inc."
  },
  "system-info": {
    "file.encoding": "UTF-8",
    "java.runtime.name": "OpenJDK Runtime Environment",
    "java.runtime.version": "11.0.13+8",
    "java.vendor": "Eclipse Adoptium",
    "java.vendor.url": "https://adoptium.net/",
    "java.version": "11.0.13",
    "java.vm.name": "OpenJDK 64-Bit Server VM",
    "java.vm.version": "11.0.13+8",
    "os.name": "Linux",
    "os.version": "4.14.238-182.422.amzn2.x86_64",
    "user.language": "en",
    "user.timezone": "GMT"
  },
  "metabase-info": {
    "databases": [
      "postgres",
      "snowflake",
      "h2"
    ],
    "hosting-env": "unknown",
    "application-database": "postgres",
    "application-database-details": {
      "database": {
        "name": "PostgreSQL",
        "version": "12.7"
      },
      "jdbc-driver": {
        "name": "PostgreSQL JDBC Driver",
        "version": "42.2.23"
      }
    },
    "run-mode": "prod",
    "version": {
      "date": "2021-12-16",
      "tag": "v0.41.5",
      "branch": "release-x.41.x",
      "hash": "fbfffc6"
    },
    "settings": {
      "report-timezone": null
    }
  }
}

Hi there! You should check out https://github.com/metabase/metabase/pull/19375 which will be available in v42 (around EoM)

Indeed and did not realize the release date of that fix! That was one of the links in the topic. In the short run though, are there any fixes that can be done further upstream?

@flamber - Would you happen to know of any potential upstream workarounds prior to the new version of Metabase being released or when that release is slated for?

Would appreciate any thoughts / ideas. Thank you!

@ds8315
I don't understand what you mean about upstream, but did you read my workaround?
https://github.com/metabase/metabase/issues/16114#issuecomment-850837877
If you look at issues (not PRs), then a closed issue has a milestone attached in the sidebar.
I cannot give you exact release dates, but we publish tentative dates on milestones:
https://github.com/metabase/metabase/milestones