Google BigQuery destination
Learn how to connect your Google BigQuery data warehouse as a destination in Renta ELT.
Prerequisites
Before you begin, ensure you have:
- A Google Cloud Platform (GCP) project.
- Access to the Renta ELT platform.
The following permissions are required regardless of the authorization method (Service Account or OAuth):
| Role | Description |
|---|---|
| BigQuery Data Editor | Grants Renta permission to: 1. create new datasets in the project 2. read a dataset’s metadata and list the tables in the dataset 3. create, update, get, and delete tables and views from a dataset 4. read and update data and metadata for the tables and views in a dataset. |
| BigQuery Job User | Grants Renta permission to perform actions such as loading data, exporting data, copying data, and querying data in a project. |
Adding Google BigQuery destination via service account
Follow these steps to connect your Google BigQuery project to Renta ELT using a Service Account.
Log in to your Renta ELT platform and navigate to the Destinations section in the left sidebar. Click the + Add destination button in the top right corner.
In the Destination catalog, find and select Google BigQuery from the list of available destinations.
Select GCP Service Account as the authorization method. This is the recommended method for production environments.
Click Upload a Service Account JSON file and select the JSON key file you generated in the Google Cloud Console.
After uploading the key, the project ID will be automatically detected (or you may need to confirm it). Fill in the remaining configuration details:
| Field | Description |
|---|---|
| Destination name | Specify a name for this destination (e.g., Marketing Data Warehouse). |
| BigQuery project | The project ID from your Service Account. |
| BigQuery dataset | Select an existing dataset or create a new one. |
| Data Location | (Optional) Select the geographic location for your dataset. If there are no datasets in the project, a Renta_dataset will be created in the specified region. |
Click Save to complete the setup.
You will be redirected to the list of destinations. Verify that your new BigQuery destination appears in the list with an Active status.
Adding Google BigQuery Destination via OAuth
Follow these steps to connect your Google BigQuery project to Renta ELT using your Google Account.
Log in to your Renta ELT platform and navigate to the Destinations section in the left sidebar. Click the + Add destination button in the top right corner.
In the Destination catalog, find and select Google BigQuery from the list of available destinations.
Select Authenticate with Google Account as the authorization method. This option allows you to connect quickly using your personal access.
Click the Log in to your Google BigQuery account button to proceed.
A Google authentication window will appear. Select your Google account and click Allow to grant Renta the necessary permissions to manage data in BigQuery.
After successful authentication, fill in the configuration form:
| Field | Description |
|---|---|
| Destination name | Specify a name for this destination (e.g., Marketing Data Warehouse). This is used exclusively in the Renta interface. |
| BigQuery project | Select the Google Cloud project you want to use. |
| BigQuery dataset | Select an existing dataset or create a new one where the data will be loaded. |
| Data Location | (Optional) Select the geographic location for your dataset. If there are no datasets in the project, a Renta_dataset will be created in the specified region. |
Click Save to complete the setup.
Verifying the connection
After saving the destination, you will be redirected to the list of destinations. You can now use this Google BigQuery connection when creating pipelines.
Advanced topics
Ready to get started?
Build your data pipeline today or get a personalized demo. Start free!
Need help?
Get expert support to ensure your project succeeds. We're here to help!
Feature requests?
Help shape our product! Share your ideas for new features and integrations.