The BigQuery extractor loads data from BigQuery and brings it into Keboola Connection (KBC).
Find Google Analytics in the list of extractors. Create a new configuration and name it.
To access and extract data from your BigQuery dataset, you need to set up a Google Service Account.
Keboola Connection BigQuery Extractor)
BigQuery Data Editor,
BigQuery Job Userand
Storage Object Adminroles.
Important: The private key is stored in an encrypted form and only the non-sensitive parts are visible in the UI for your verification. The key can be deleted or replaced by a new one at any time.
The extractor uses Google Storage Bucket as a temporary storage for off-loading the data from BigQuery.
Start by clicking the green + Add Query button.
Name the query and click Create.
Specify your requirements in the
SQL Query field and Save the query configuration.
Now run the configuration to bring the data to KBC.
Running the extractor creates a background job that
Note: Using the Google BigQuery extractor is also described in our Getting Started Tutorial.