Table Input Component

Table Input Component

Read chosen columns from an input table or view into the job.

This component will also work with external tables.

Properties

Property Setting Description
Name Text The descriptive name for the component.

This is automatically determined from the table name when the Table Name property is first set.
Database Select Choose a database to create the new table in.
Schema Select Select the table schema. The special value, [Environment Default] will use the schema defined in the environment. For more information on using multiple schemas, see this article.
Target Project Text Enter the name of the Google Cloud Platform Project that the table belongs to.
Dataset Text Enter the name of the Google Cloud Platform Dataset that the table belongs to.
Table Name Select The name of the input table or view. The tables and views found in the currently selected environment are provided to choose from.

You can change the currently selected environment in the Environments section.
Target Table Select The name of the input table or view. The tables and views found in the currently selected environment are provided to choose from.

You can change the currently selected environment in the Environments section.
Column Names Multi Select Once the Table Name is set, the columns become available to choose from. Use the Editor to select which columns to pass along.

If you don't like the column names, consider using a Rename component to change them.
Trim Columns Select Wraps the column names in a BTRIM function, which will strip out all the leading and trailing spaces. See the Redshift documentation for details.

Strategy

Generates a select query.

Example

This simple job brings in the flights table for further processing.

The table name is set first. The status for Column Names reminds you they still need to be set up.

Selecting the 'Column Names' property will bring up a new window that allows the user to select which columns to import from the table.