ePrivacy and GPDR Cookie Consent by Cookie Consent Skip to main content

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.

01.png

Project (required) 
Project Name

 

02.png

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 database 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, boolean or timestamp.