Setup tab

Setup tab, Google BigQuery loader

This tab includes the following fields:

Field	Description
Credentials	Enter your Google cloud credentials in the form of a key file to access Google cloud from PDI. Alternatively, select Use Environment Authentication to access the system environmental variable for the credentials. See Before you begin for details.
Storage source URL	Specify the Google Cloud Storage URL of the data to import. The URL can point to a file or a folder in Google Cloud Storage. The URL must begin with gs:// and must specify the bucket and object you want to load. You must specify the file type in the File tab.
Dataset	Specify the dataset where you want to import a table. The dataset drop-down is automatically populated when you select the Storage source URL, but you can enter a new dataset name in the field. If the dataset does not exist it will be created at runtime.
Table name	Specify the table name in the dataset where you want to import data.
Column name	Specify the column name in the datatset table where you want to import data.
Column type	Specify the column type in the datatset table where you want to import data.
Overwrite existing table	Select to overwrite existing data with imported data.