You can use your favorite BI tool (Metabase, Microsoft Power BI, Tableau, Qlik, Looker etc.) to visualise data after preparing it in UbuntuFabric, and you can use a DB tool (BeeKeeper, DBeaver) to work with tables in your UbuntuFabric data warehouse.
Use these settings in your BI tool to connect to UbuntuFabric:
- Connection type: Postgres (default data warehouse type in UbuntuFabric)
- Host: db.eu.UbuntuFabric.io (for EU instance)
- Port: 5432 (for Postgres)
- User name & password: copy / paste from the Data Warehouse tile under My Connections in UbuntuFabric (see above)
- Database name: same as the user name
- SSL: enabled
Materialize SQL Queries
In order to see the result of SQL queries written in UbuntuFabric inside your BI tool, You need to materializing the query. Once the table is materialized, you can consume it in your BI tool.
Connect your BI tool to UbuntuFabric
Connect your DB Tool to UbuntuFabric