How to Create Reports Using Tables from Two Different Databases in Metabase? I'm trying to create reports in Metabase using tables from two different databases.I have database1 with a name column and database2 with an id column.I want to join these two tables to generate reports that include data from both.
It's currently not possible to join data from different databases in one Metabase query, but your database itself might already have the capability to access data from another database, enabling Metabase to only query just one database for joins! Here are some things to look into: - If one of your databases is Postgres, you can use Foreign Data Wrappers to query data from other databases (including other Postgres databses) from your Postgres - If one of your databses is Redshift, you can use federated queries for the same purpose - With Spark and Databricks (Databricks driver coming in the next release 🥳), you can set up JDBC connections to external databses - With BigQuery, you can use external data source - You can also use federated query engines like Presto/Trino (supported by Metabase) for dozens of other combinations
How to Create Reports Using Tables from Two Different Databases in Metabase?
I'm trying to create reports in Metabase using tables from two different databases.I have database1 with a name column and database2 with an id column.I want to join these two tables to generate reports that include data from both.
It's currently not possible to join data from different databases in one Metabase query, but your database itself might already have the capability to access data from another database, enabling Metabase to only query just one database for joins!
Here are some things to look into:
- If one of your databases is Postgres, you can use Foreign Data Wrappers to query data from other databases (including other Postgres databses) from your Postgres
- If one of your databses is Redshift, you can use federated queries for the same purpose
- With Spark and Databricks (Databricks driver coming in the next release 🥳), you can set up JDBC connections to external databses
- With BigQuery, you can use external data source
- You can also use federated query engines like Presto/Trino (supported by Metabase) for dozens of other combinations
@@metabasedata Can I create models from two databases and then create a new model by joining them? Isn't that right?