Integration between MongoDB and BigQuery

[happyhooter]

Hi all, I am very new to GCP and BigQuery and that's why I want to ask the question how to connect MongoDB with BigQuery?

As I currently understand I can use Dataflow to connect them. But just wanted to ask whether there are any other alternative methods?

[gowthamnagarajn]

Hi @happyhooter ,

If I understand correctly, you requirement is to read the entry from BigQuery and add it to Mongodb. For this use case, you can create an Application Integration Workflow with BigQuery and Mongodb connector tasks to achieve this. Adding the relevant docs below.

https://cloud.google.com/integration-connectors/docs/connectors/mongodb/v2/configure

https://cloud.google.com/integration-connectors/docs/connectors/bigquery/configure 

[happyhooter · Accepted solution]

Actually a bit different: On the daily basis I want to read the whole table from MongoDB and send it to the BigQuery table in the append mode. But I think it's quite easy to achieve this with Dataflow pipelines using MongoDB to BigQuery template.