0

In Oracle and SQL Server, it is possible to search all database objects for references of specific text: SELECT * FROM all_source WHERE UPPER(text) LIKE '%blah%'

I would like to do the same thing in Google BigQuery. Is it possible to search every field of every table for a particular value in BigQuery?

funkdoctorsport
  • 1
  • 1

1 Answers1

0

If you wish to query multiple tables within a dataset in BigQuery, have a look at querying multiple tables using a wildcard table. If you would also like to search for a word in all columns of a table (or every table in this case), have a look at this SO post where this topic is discussed.

Philipp Sh
  • 967
  • 5
  • 11