🔹 Step 1: Get Your BigQuery Project & Dataset ID

1. Go to your Google Cloud Console.
2. From the navigation menu, open BigQuery.
   
3. Create a new project (if not available). Note: Avoid using dots (.) in your Project ID.
   
4. Note down the Project ID.
   
5. Inside BigQuery, click "Create Dataset" and choose a name — e.g., odoo_data.
   
6. Note down the Dataset ID.
   
7. Make sure the Dataset ID also doesn't include dots (.).
8. Copy your Project ID and Dataset ID — you'll need these in Odoo.

🔹 Step 2: Create Service Account & Generate Credentials JSON

1. From the Google Cloud Console, go to IAM & Admin → Service Accounts.
   
2. Click "Create Service Account" and give it a recognizable name (e.g., odoo-bigquery-user).
   
3. Assign a suitable role:
   • ✅ BigQuery Admin — for full control (recommended)
   • 🔸 Or minimum required roles: BigQuery Data Editor + BigQuery Job User
   
4. After creation, open the service account → go to the "Keys" tab → click "Add Key → Create New Key".
   
5. Choose JSON as the key type and download the credentials file.
6. This JSON file will be uploaded in your Odoo BigQuery configuration.

🔹 Step 3: Add Credentials in Odoo

Once you have your Project ID, Dataset ID, and Service Account JSON file:

• Open settings → navigate to Google BigQuery.
  
• Enter your Project ID and Dataset ID.
• Add Details of your Service Account JSON file.
  
• Click "Test Connection" to ensure successful integration.
  

✅ This quick test confirms that your setup is correct and validates that your BigQuery service account has the right access to insert and manage data.

⚙️ Note: Default system fields such as create_date, write_date, create_uid, and write_uid are skipped during import to preserve data integrity.

✅ This import process ensures that only existing Odoo records are updated — keeping your system accurate, synchronized, and free of duplicate entries.