Access multiple databases within same Snowflake Instance

Get Help
1

I have two databases within the same Snowflake instance. One for 'raw' data and one for 'cleaned' data.

I'd like to access both from Metabase and join across them. Can I do this? I can join across them within the Snowflake UI but can't seem to figure this out in Metabase.

In Metabase, it wants each Snowflake database within the Snowflake instance to be a separate database in Metabase.

{
  "browser-info": {
    "language": "en-US",
    "platform": "MacIntel",
    "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_3) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/89.0.4389.90 Safari/537.36",
    "vendor": "Google Inc."
  },
  "system-info": {
    "file.encoding": "UTF-8",
    "java.runtime.name": "OpenJDK Runtime Environment",
    "java.runtime.version": "11.0.10+9",
    "java.vendor": "AdoptOpenJDK",
    "java.vendor.url": "https://adoptopenjdk.net/",
    "java.version": "11.0.10",
    "java.vm.name": "OpenJDK 64-Bit Server VM",
    "java.vm.version": "11.0.10+9",
    "os.name": "Linux",
    "os.version": "4.14.219-164.354.amzn2.x86_64",
    "user.language": "en",
    "user.timezone": "GMT"
  },
  "metabase-info": {
    "databases": [
      "snowflake"
    ],
    "hosting-env": "unknown",
    "application-database": "postgres",
    "application-database-details": {
      "database": {
        "name": "PostgreSQL",
        "version": "11.7"
      },
      "jdbc-driver": {
        "name": "PostgreSQL JDBC Driver",
        "version": "42.2.18"
      }
    },
    "run-mode": "prod",
    "version": {
      "date": "2021-03-17",
      "tag": "v1.38.2",
      "branch": "release-x.38.x",
      "hash": "91f0ed6"
    },
    "settings": {
      "report-timezone": "America/Los_Angeles"
    }
  }
}
2

Hi @tyler

I think you're seeing problems with the initial implementation of Snowflake, which probably required Database to be defined, and later caused problems with Schema - like:
https://github.com/metabase/metabase/issues/13126
I'm not completely sure why database is a required field - I'll need to investigate this a bit more, since I think it comes back to the original implementation.

I would think that if you had one database with different schemas, then it would be possible to do what you want (if you leave the Schema field blank).

As for doing database cross join, that's one of the most requested features:
https://github.com/metabase/metabase/issues/3953 - upvote by clicking :+1: on the first post