as far as I know, Metabase doesn't support CSV files. Google DataStudio might be an option? but also no idea if it supports CSVs (I know its not open source, but still its free and online)
The expectation is that data is loaded into your database, which is reasonable. None of these tools are built to ingest data from multiple disparate sources and perform their own aggregations (like Tableau), but rather depend on locality of data on the database under query.
[1] https://github.com/Markenson/csv-metabase-driver/releases/ta...