*, that will then represent any other possible string. For example, using the wildcard expression Flights_20* might return Flights_2014, Flights_2015, Flights_2016, and Flights_20Temp as a single, united table.
For full information, read the Google Cloud Platform documentation querying wildcard tables.
Properties
string
required
A human-readable name for the component.
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 containing the table to query. The special value
[Environment Default] uses the dataset defined in the environment.string
required
A prefix that all united tables must have. The wildcard character is positioned exactly after this prefix.
drop-down
required
- Yes: The remaining string after the table prefix is removed from each table name is to be given in a column, showing the origin table of each row.
- No: Do not store suffixes in the wildcard table.
string
required
Name of the column where table suffixes are listed. Property only visible if Include table suffix is Yes.
string
required
Adds a freeform SQL filter that is appended to the component’s generated SELECT statement, enabling you to filter which tables are included in the union.