Skip to main content
BigQuery allows the creation of wildcard tables that combine all tables found through a wildcard expression. A wildcard expression can be any string followed by the wildcard character, *, that will then represent any other possible string. Thus, 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, see the Google Cloud Platform documentation querying wildcard tables.

​
Properties

​
Name
string
required
A human-readable name for the component.
​
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 containing the table to query. The special value [Environment Default] uses the dataset defined in the environment.
​
Table prefix
string
required
A prefix that all united tables must have. The wildcard character is positioned exactly after this prefix.
​
Include table suffix
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.
​
Table suffix column name
string
required
Name of the column where table suffixes are listed. Property only visible if Include table suffix is Yes.
​
Where clause
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.