Connect mongodb to google data studio [closed]

Question

I'm trying to connect MongoDB to Google Data Studio. As there isn't an official connector, I tried to connect MongoDB to Google Spreadsheet with the function importdata(url), but the rows that I can import are limited.

Do you have any suggestions?

Answer 1

Now you can import data from a MongoDB collection into Looker BI Platform - formerly known as Google Data Studio with MongoDB Connector for BI. Essentially, the MongoDB Connector for BI translates queries and data (adapter) to allow you to create queries with SQL. This connector stores no data, and purely serves as a bridge.

You would need a MongoDB Atlas M10+ instance with the BI Connector enabled and a Looker account. The reason you would need a dedicated Atlas M10 instance or greater, is because the BI Connector is a powerful tool which performs operations which may be CPU/Memory intensive.

To connect Looker to your Atlas cluster, in the Looker account go to Admin settings to create a new connection. Select MongoBI in the Dialect menu.

See also:

• MongoDB: Connect from Looker
• MongoDB: Connect via BI Connector for Atlas
• Google: Connecting Looker to your database