AJT
Reputation: 21
BigQuery Dataset Wildcards?
I've used table wildcards functions in BigQuery but is it possible to use wildcards to query across multiple datasets within a project?
Upvotes: 2
Views: 2061
Answers (1)
Jordan Tigani
Reputation: 26617
No, this is not currently possible. One technical reason is that it would be more difficult to look up the tables involved if the table wildcards crossed datasets.
Upvotes: 2
Related Questions
- wildcard in bigquery load from gs
- Using wildcard in bigquery project name
- How would i use a wildcard for a specific string in SQL
- Bigquery API fails to recognize wildcard tables
- BigQuery can use wildcard table names and table_suffix, but I am looking for a similar solution like wildcard datasets and dataset_suffix
- Google Big Query using a wildcard in middle of table name
- BigQuery:Querying Multiple Tables Using a Wildcard Table
- Wildcard % operator not working on bigquery
- Wildcards on subqueries
- BigQuery Table Wildcard Function Aliases?