How to connect appwrite to metabase

Hi I am currently using appwrite happily and want to connect it to metabase how can I do that ?

You need to allow access to mariadb from metabase (via docker network on same server for ex).
Thinks it's impossible on appwrite cloud ?
Be careful though, appwrite databases aren't flat , I think that metabase is not usable in this context

Simpler way will be to create an ETL with appwrite Rest or graphql, and sync to external BI software

This is what we do on our side

Which software are you recommending because we need it to show analytics to Clients of us

You can use metabase, but via export appwrite data to external postgres / mariadb

Depends wich metrics you want. If it's only document, it is relatively easy

Loops over databases > collection > document, and export to external database

And how can I do that you mean I should export my Files to a DB ihave installed on the server

You rest api or graphql

Or nodejs client, depends

Here how to list databases : https://appwrite.io/docs/server/databases?sdk=nodejs-default#databasesList

After you list collection : https://appwrite.io/docs/server/databases?sdk=nodejs-default#databasesListCollections

And finally list document : https://appwrite.io/docs/server/databases?sdk=nodejs-default#databasesListDocuments

Hi so I got this answer of my server provider when i asked for help :

you can customize your stack by yourself for free in the dashboard > Service overview > UPDATE CONFIG button
there you will have to expose the mariadb container on a port and allow that port in the firewall, then you will be able to connect from Metabase to that embedded MariaDB in Appwrite