Enable BigQuery API

- Go to Google Cloud Console.
- Navigate to Enabled APIs & services.
- Enable BigQuery API.

Create Dataset in BigQuery

- Go to the BigQuery menu.
- Click on Create Dataset.

Create Service Account

- Go to IAM & Admin -> Service Accounts.
- Click on Create Service Account.

Generate Service Account JSON File

- Go to Service Account -> Keys.
- Click on Add Keys -> Create New Key (choose JSON type).

Odoo BigQuery Connection

- Go to Connections in Odoo.
- Enter the Project ID and upload the JSON file.

Export Data Using Model or Query & Schedule Export Data.

- Two ways to fetch the data: through Model and through Query.
- Also, generate queries through AI from normal language.
- Also, Schedule export data.

BigQuery Table

View Exported Data in BigQuery

- Also, you can download data or open in google sheet.