Anyone using metabase with Azure SQL Server?

#1

I’m considering using Metabase and my organization is pretty tied into Azure. Curious to hear if there are people using Metabase predominantly with Azure services and if there are any nuances to keep an eye on.

At first glance, running Metabase from a Docker image seems like it would make the most sense and
we would be connecting to an Azure SQL Server. Would be really cool if we could connect to Data Lakes and Data Warehouses though.

#2

Hi @crawforc3

You should be able to connect without any problems to Azure SQL Server - the past two years, Metabase has been using the Microsoft JDBC driver, which is compatible with Azure too.

And using the Docker image might be the easiest way.
Just remember to store the metadata (the Metabase settings and data) in Postgres/MySQL and not the default H2, which is not recommended for production.
https://metabase.com/docs/latest/operations-guide/running-metabase-on-docker.html

As for “Data Lake” and “Data Warehouse”, I’m not sure what type of connection they use.
Metabase currently “only” has about 15 drivers, so if those cannot connect, then you’re at a loss.

#3

Thanks flamber, metabase looks like the hero this world needs :slight_smile:

Where can I find the list of db drivers?

#4

Here’s the list of Metabase supported drivers:
https://metabase.com/docs/latest/administration-guide/01-managing-databases.html
And then you have to look for drivers created by other people - they mostly comment on the driver issues, if they have created one or are working on it:
https://github.com/metabase/metabase/issues?q=label%3A"Database+Support"