I’m having an issue querying table bigquery-public-data.google_ads_transparency_center.creative_stats for a specific advertiser.

I’m having an issue querying table bigquery-public-data.google_ads_transparency_center.creative_stats for a specific advertiser.

I need to assign a time_group to each logged_time based on the following logic:

Writing dynamic query in BQ to to pull list of all tables from numerous data_sets (schema) based on a Column_name search. If the column_name = ‘source’ in any of the Data_sets/tables from one Project space – return a list of all data_sets and tables Names that contain that column name.
The current query (below) returns the correct results. However, since the query is dynamic the ‘execute immediate’ will be hit numerous times based on the numbers Data_sets under the project space,the result screen in BQ will return a “result set” for each Execution. In my case over a 100+
and the majority will be “There is no data to display.” (empty result). So i have to click on each “View Results” row to display the results. Can I apply some logic that can

I just found out about BigQuery short query optimized mode support. But can only find it on cloud console ?

I need to extract data from a company’s BigQuery system but there is an additional step of copying the tables from somewhere to my dataset and I can’t seem to find the tables anywhere. There is only one project available so it’s not like the tables are in some other project.

Ok, so I have the following case:

To be honest, I have not found anything useful on this issue in Google documentation, hence it is not clear how to calculate it correctly

Any time i run this query

We are trying to be diligent about providing table (and field) descriptions in BigQuery.
https://cloud.google.com/bigquery/docs/managing-tables#updating_a_tables_description