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 Google Cloud 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 Google Cloud credentials must have the Google Drive API enabled.

​
Properties

​
string
required
A human-readable name for the component.
​
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.
​
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.
​
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.
​
string
required
A name for the table.
​
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.
​
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.
Toggle Text mode on 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. For more information, read Grid variables.
​
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.
​
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.
​
integer
required
The maximum number of individual parsing errors that cause the whole load to fail. The default is 0.
​
boolean
required
  • Yes: Accept rows that contain values that do not match the schema.
  • No: Omit any rows with invalid values.
​
string
required
The delimiter that separates columns. The default is a comma ,.
​
string
The character to be used as the quote character when using the CSV option.
​
drop-down
required
The encoding the data is in. This defaults to UTF-8.
​
integer
required
The number of rows at the top of the file to ignore. The default is 0.
​
boolean
required
  • Yes: Allow a CSV value to contain a newline character.
  • No: A newline character is always considered a new row.
​
boolean
required
  • Yes: Missing values are treated as NULL but accepted.
  • No: Rows with missing data are treated as bad records.