Querying more then one database

Hello,

I have many databases (one per client) with the same structure. Is or will be possible analyse data from all databases in some magic way?

Thanks.

Can you give an example of what you mean? What types of queries would you want to run?

I need to analyse data from all clients (all databases) to improve key parts of app.

Example of questions:

  • How many messages was read;
  • How many users is active;
  • Compare how many actions was made by users and how many by admins;

You can created a saved question with time series from each database and then overlay them on a single chart as in http://www.metabase.com/docs/v0.16.0/users-guide/09-multi-series-charting.html

If you need to join the data in a single query, you’ll need to use SQL and either create a foreign data wrapper - eg https://wiki.postgresql.org/wiki/Foreign_data_wrappers for PostgreSQL.