While metriql is a relatively new project, we're working on integrating BI tools using our low-level integrations such as REST API and JDBC driver. If your BI tool already integrates with Trino (formerly Presto), you can use the metriql URL and port to connect your metriql server. Note that metriql doesn't embed Trino; it acts as Trino for the BI tools. However, it rewrites the query and directly runs it on your database.
|BI Tool||Status||Integration Method|
|Google Data Studio||Ready ✅||Community Connector|
|Looker||Ready ✅||Trino + LookML project|
|Redash||Ready ✅||Trino / Presto|
|Mode Analytics||Ready ✅||Trino|
|Sisense Cloud (formerly Periscope)||Ready ✅||Presto|
|Thoughtspot||(Partially) Ready ✅||Presto|
|Metabase||🚧 In Progress||Trino / Presto|
|Power BI||🚧 In Progress||XMLA server|
|Qlik||🙋 Needs testing||Presto|
|MicroStrategy||🙋 Needs testing||Presto|
|Data Application||Status||Integration Method|
|Google Sheets||Ready ✅||Marketplace Add-on|
|SQL Client||Status||Integration Method|
|Dbveaver||Ready ✅||Trino / Presto JDBC|
|Jetbrains DataGrip||Ready ✅||Trino / Presto JDBC|
|CLI||Ready ✅||Trino / Presto CLI|
|Python||Ready ✅||Trino / Presto Python Package|
If the BI tool already supports Trino or Presto, you can connect to Metriql using that interface. If you use Metriql URL and port, Metriql will expose all your datasets inside them as regular database tables & columns. You can reference your measures & dimensions using MQL reporting type, Metriql will parse the query and compile it to SQL for the target data warehouse. For the BI tools that don't have a free trial, we're not able to test and verify if metriql is working fine. I appreciate it if you would like to test and share a short demo video in that case!
Please note that all the integrations are in the alpha stage at the moment. You can also see our roadmap for the integrations here.