Connector Google BigQuery

Google BigQuery provide an easy solution to load data from Google BigQuery to Meiro Integrations.

Data In/Data Out

Data In 

N/A

Data Out

Your results will be saved in the Data Out bucket folder. 

ReadLearn more: about the folder structure here.

Learn how: to move files from one folder in configuration to another using Command Line Interface Code processor please refer to this article.

Parameters

The Google section

Project ID (required)
The ID of the BigQuery project that will be billed for the job.

Storage (required)
URL of existing Google Cloud Storage bucket, where data will be exported.

Location(Location (required, defaultdefault: US)
The geographic location where the job should run and source data exists. 

Learn more: about BigQuery dataset location here.

The Query section

It defines queries used to fetch data.

Name (required)
Query name.

Query (required) 
Query in BigQuery syntax.

Learn more: about the BigQuery syntax.

Primary key (optional)
Google is slicing large results to multiple files. PrimaryThe primary key should be defined.

Incremental (optional)
Use incremental import to Meiro Integrations (default is false).

Flatten Results (optional)
Flattens all nested and repeated fields in the query results (default is true).

Use Legacy SQL (optional)
Use legacy SQL to run the query. Set false to use standard SQL (default is true).

Learn more: about the BigQuery reference.