How to connect Odoo with Google Bigquery
Google BigQuery Connector for Odoo Installation and Setup Guide
Requirements:
- Odoo Versions Supported: 12, 13, 14, 15, 16, 17 (Enterprise or Community)
- Google Cloud Account with BigQuery enabled
- Necessary permissions in Odoo and Google Cloud (follow along for more details)
- The module depends on these python libraries 'google-cloud-bigquery', 'pandas','pyarrow'.
- If you are on Odoo Sh, add these in your addons repository level requirements.txt.
- If you are on on-premises server, install these manually in your Odoo python environment manually and restart the server.
Installation:
- Download the BigQuery Connector module from

- In your Odoo, navigate to Apps and click on 'Update Apps List' and Update

- Search for 'BigQuery Connector', then click 'Install'

Configuration:
3.1. Obtaining BigQuery Project ID and Dataset ID:
- Log in to your Google Cloud Console
- Navigate to the BigQuery section.
- Create a new project (if not already done). Note: Ensure the Project ID does not contain dots (".") as this may cause issues with certain integrations.
- Note down the Project ID.

- In the BigQuery dashboard, create a new dataset. Remember: The Dataset ID should not contain dots (".") as well.

- Note down the Dataset ID.

3.2. Creating a Google Cloud Service Account and Generating Credentials JSON:
- Navigate to ‘IAM & Admin’ → ‘Service Accounts’ in the Google Cloud Console.

- Create a new service account and assign the ‘BigQuery Admin’ role for full BigQuery access. (if you do not want to give admin access provide “BigQueryData Editor” and “BigQuery Job User” role)

- Generate a new JSON key for this service account and download it. (Select your Service account and in “Keys” tab click “ADD KEY”)

Note: This process not only verifies the connection but also ensures that the BigQuery Connector is set up correctly and has the necessary permissions to perform data operations.