Skip to main content
Google Drive Table is an orchestration component that creates a table that references data stored in Google Drive. The component supports Google Sheets, CSV, and newline-delimited JSON formats. Your instance must have access to the Google Drive data, meaning the GCP credentials used must be from an account that has the right to at least view the data. New to Google Drive? Read Introduction to the Google Drive API.
Your GCP credentials must have the Google Drive API enabled.

​
Properties

​
Name
string
required
A human-readable name for the component.
​
Create method
drop-down
required
Select one of:
  • Create: (default). Creates a new table.
  • Create If Not Exists: Only creates a new table if a table of the same name does not already exist.
  • Replace: Drops any existing table of the same name, and then creates a new table.
​
GCP project ID
drop-down
required
The Google Cloud project that owns the BigQuery dataset. The special value [Environment Default] uses the Google Cloud project defined in the environment. For more information, read Creating projects.
​
Dataset
drop-down
required
The Google BigQuery dataset where the table will be created or updated. The special value [Environment Default] uses the dataset defined in the environment.
​
Table
string
required
A name for the table.
​
Drive URL
string
required
The URL of the Google Drive file. The accepted URL formats are as follows:
  • https://docs.google.com/spreadsheets/d/FILE_ID
  • https://drive.google.com/open?id=FILE_ID
For more information, read Retrieve Drive URIs.
​
Columns
column editor
required
  • Name: The name of the new column.
  • Data type: The Google BigQuery data type for the column.
  • Mode: The field mode. Can be NULLABLE, REQUIRED, or REPEATED. The default is NULLABLE.
  • Comment: Enter a comment to store against the column.
Click the Text mode toggle at the bottom of the dialog to open a multi-line editor that lets you add items in a single block. For more information, read Text mode.To use grid variables, toggle Use Grid Variable on at the bottom of the dialog. For more information, read Grid variables.
​
File format
drop-down
required
Select the format of the source file:
  • CSV
  • JSON (New line delimited)
  • Google Sheets
The following properties depend on the File format you select.
​
Compression
drop-down
required
Whether the input file is compressed in gzip format or not compressed at all. Select NONE or GZIP. The default is set to NONE.
​
Maximum errors
integer
required
The maximum number of individual parsing errors that cause the whole load to fail. The default is 0.
​
Ignore unknown values
boolean
required
  • Yes: Accept rows that contain values that do not match the schema.
  • No: Omit any rows with invalid values.
​
Delimiter
string
required
The delimiter that separates columns. The default is a comma ,.
​
CSV quoter
string
The character to be used as the quote character when using the CSV option.
​
Encoding
drop-down
required
The encoding the data is in. This defaults to UTF-8.
​
Skip leading rows
integer
required
The number of rows at the top of the file to ignore. The default is 0.
​
Allow quote new lines
boolean
required
  • Yes: Allow a CSV value to contain a newline character.
  • No: A newline character is always considered a new row.
​
Allow jagged rows
boolean
required
  • Yes: Missing values are treated as NULL but accepted.
  • No: Rows with missing data are treated as bad records.