Loader Google BigQuery

The Google BigQuery Loader job entry enables you to load data into Google BigQuery from a Google Cloud Storage account.

Data In

Upload all files in /data/in/files to the specified bucket and prefix. Existing files are overwritten.

Data Out

N/A

Read more: about the folder structure here.

Parameters

All parameters are set in Google.

Project (required) 
Project Name

 

Dataset (required) 
Datasets are top-level containers that are used to organize and control access to your tables and views. 

Learn more: about Datasets here

Input Table (required)
Name of table you want to load to the database.

DB Table Name (required)
Database table name.

Incremental
signifies if you want to load the data by overwriting whatever is in DB or incrementally.

DB Column Name (required)
Database Column name.

Column Name (required)
The name of column in input table you want to load to the database.

Data Type (required)
Data Type can be String, Int64, Float64, Bool or Timestamp.