Wildcard Table Input
  • Dark

Wildcard Table Input

  • Dark

This article is specific to the following platforms - BigQuery.

Wildcard Table Input

BigQuery allows the creation of 'Wildcard' tables that combines 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 target="_blank">wildcard tables and querying wildcard tables.


Property Setting Description
Name Text A human-readable name for the component.
Project Select Select the Google Cloud project. The special value, [Environment Default], will use the project defined in the environment.
For more information, refer to the Creating and managing projects.
Dataset Select Select the Google BigQuery dataset to load data into. The special value, [Environment Default], will use the dataset defined in the environment.
For more information, refer to the Introduction to datasets.
Table Prefix String A prefix that all united tables must have. The wildcard character is positioned exactly after this prefix.
Include Table Suffix Select 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 Name of the column where table suffixes are listed. Property only visible if Include Table Suffix is Yes.
Where Clause String Adds an option freeform SQL filter that is appended to the SELECT statement generated by the component. This allows a user to filter which tables the component unions.

What's Next