Skip to main content

BigQuery

Connect BigQuery Database as a destination

Set up BigQuery as a destination for your pipelines

How to Connect BigQuery as a destination

To connect your BigQuery database, follow the steps below:‍

  1. Open the Dropmail Admin Dashboard
  2. From the Destination Menu, click on Create
  3. Add a nickname for your database connection
  4. From the dropdown menu, select BigQuery
  5. Gather and enter your database connection information. Note that you may need to whitelist our IP (107.22.60.6) if your database isn't open. Contact your IT team for help with this.
    • Google Service account. Please ensure that this account has read/write access to your BigQuery project
    • JSON file key
  6. Click the "Test" button to verify your credentials
  7. Click the "Save" button once a green notification pops up, indicating that the add-on was successfully installed.

And that's it! Enjoy running your queries.