4 ms·
You knowledge of MongoDB is a little out of date. MongoDB supports SQL queries. Tableau has an MongoDB connector. You can connect MongoDB to Excel via our Data
by jd_mongodb 4y ago
You knowledge of MongoDB is a little out of date.
MongoDB supports SQL queries. Tableau has an MongoDB connector. You can connect MongoDB to Excel via our DataAPI and of course our Cloud platform provides embeddable charts.
Only the DataAPI is a relatively recent addition. The rest are very mature features.
- senttoschool 4y agoSo it's no longer a NoSQL database. ;)
- zX41ZdbW 4y agoI did not find a reliable way to query MongoDB with SQL: https://github.com/ClickHouse/ClickBench/blob/main/mongodb/queries.js https://github.com/ClickHouse/ClickBench/blob/main/mongodb/q... It looks like it's only available in the Atlas service. Please correct me if I'm wrong. Writing analytic queries in JS is painful.
- emptysea 4y agoProblem with mongo is if you start using more SQL like things like pipelines and aggregations your perf goes out the window you really have to think about how you structure your data in mongo for it to work with lots of queries since joins are untenable (even if aggregations support them)