In BigQuery, what is the impact of using wildcard tables in a query?

Google Cloud (GCP) Hard

Google Cloud (GCP) — Hard

In BigQuery, what is the impact of using wildcard tables in a query?

Key points

  • Wildcard tables scan multiple tables with a common prefix
  • Costs are based on all matched tables scanned
  • Queries are not restricted to a single dataset or project
  • Automatic partitioning is not a direct result of using wildcard tables

Ready to go further?

Related questions