We have started to analyze your historical usage. So far, we have processed X%. In the meantime, you can explore our training Perks!
The scan is completed, and X% of your data was already processed. You are almost there!
BigQuery Lens highlights inefficiencies in your BigQuery usage. The analysis represents the last 30 days of use
bigquery.datasets.create
logging.sinks.create
bigquery.jobs.create
bigquery.tables.getData
bigquery.tables.getData
permission to provide clustering recommendations that are unique to BigQuery Lens Advanced.WHERE
clause (i.e., the columns which can be clustered on). Knowing how many distinct elements exist in each column allows us to compute the average chunk size and determine the best savings candidates.doitintl-cmp-bq
is created in the billing project attached to the service account you add to the CMP.<PROJECTID>.doitintl-cmp-bq.cloudaudit_googleapis_com_data_access
.doitintl-cmp-bq.cloudaudit_ googleapis_com_data_access
and create a new table named doitintl-cmp-bq.enrichedJobs
. This operation is done at no cost to you. We do this to perform an enrichment process so that we have a clean dataset to work with.doitintl-cmp-bq
dataset, as well as two more derived tables named pegUtilsT2
and queries
. These tables allow the lens to run over aggregated data rather than raw data.pegUtilsT2
and queries
tablesSELECT 1