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 Datasetsdatasets herehere.
Input Table (required)
Name of table you want to load to the database.
DB Table Name (required)
Database table name.
IncrementalsignifiesSignifies if you want to load the data by overwriting whatever is in DBdatabase 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 Typetype can be String,string, Int64,int64, Float64,float64, Boolboolean or Timestamp.timestamp.