table_name: {view_name}.
Syntax
Properties
string
The name of the database table underlying the view. If not specified, defaults to the view filename. For BigQuery connections, this can end in a wildcard. Refer to BigQuery wildcard tables.
BigQuery wildcard tables
For BigQuery connections,table_name can end in a wildcard (*) to query every table whose name starts with that prefix, such as table_name: phone_*. This uses BigQuery’s wildcard table syntax.
In dimension SQL, _TABLE_SUFFIX returns the part of each table’s name that the * matched. For example, with tables phone_v1 and phone_v2, it returns v1 and v2. A filter on _TABLE_SUFFIX with a fixed value limits which tables BigQuery reads.
The wildcard matches every table in the schema that starts with the prefix, including tables you may not intend, such as phone_backup. Use a prefix that only the tables you want share.
At least one matching table must exist at the last schema refresh. If none did, queries fail with Table 'phone_*' not found until you refresh the schema. Tables added later are read without a refresh.
During a schema refresh, Omni generates an _all view with a wildcard table_name for BigQuery tables that end in eight digits, such as date-sharded events_YYYYMMDD tables. Refer to BigQuery date-sharded tables are modeled as one view or are missing. For tables sharded any other way, such as by version, set the wildcard table_name on a view yourself.
Examples
orders table in ecomm schema
phone_v1 and phone_v2 tables as one view