Query that returns out all BigQuery tables inside of a project.

bq_tables_in_project.sql

  --
  --  This query will pull out all tables that exist inside of the currently
  --  selected project.
  --
  --  Note by default this hits the US multi-region, so if using a different
  --  region then change region-us below to that region name.
  --
SELECT
  CONCAT(table_catalog, ':', table_schema, '.', table_name) AS table_name
  -- This line uses the dot notation, so if you need that versus traditional
  -- notation (or to copy into queries versus the CLI) use this line below
  -- instead of the above.
  --CONCAT(table_catalog, '.', table_schema, '.', table_name) AS table_name
FROM
  `region-us`.INFORMATION_SCHEMA.TABLES
WHERE
  table_type = 'BASE TABLE'