The BigQuery extractor loads data from BigQuery and brings it into Keboola Connection (KBC).
To work with Google BigQuery, create an account and enable billing. Then create a Google Storage Bucket as a temporary storage for off-loading the data from BigQuery.
To create a Google Storage Bucket, go to the Google Cloud Platform console and select Storage.
Create a new bucket:
Enter the bucket’s name and Storage Class:
Find Google Analytics in the list of extractors. Create a new configuration and name it.
Then authorize the account.
Select one of the two authorization methods:
Name the authorization, and follow the on-screen instructions.
Start by clicking the green Configure button.
Select your Google Project and the bucket you created at the beginning.
Then configure the actual extraction queries by clicking the New Query button.
Name the query, and specify your requirements in the
SQL query field. Save the query configuration.
Now run the configuration to bring the data to KBC.
Running the extractor creates a background job that
Note: Using Google BigQuery extractor is also described in our Getting Started Tutorial.