When I try to create a Python notebook in BigQuery, the following error appears:

Is there any way to list out the tables/views from other gcp projects using a particular view in a source project(context – data engineering).

I’ve successfully built a BigQuery ML model which I can call with ML.predict.

I enabled GCP Security Command Center (SCC) and created an export for the findings in the GCP SCC to be pushed into BigQuery dataset. Everything works as I want, however one main problem is that I can not track the status of exports. Google offers a solution for continuous exports and I applied it, yet I still need to check the status for unpredicted downtimes.

According to the documentation the ARIMA_PLUS model in BigQuery ML produces both confidence intervals as well as prediction intervals when forecasting. Upon trying it out I noticed the lower and upper bounds of the prediction interval are the same as the confidence interval. My understanding is that the prediction interval is always wider than the confidence interval for a given level, unless the error is zero.

I am using the BigQuery to get the cost details of GCP using the following query

In big query, i have an export of search console data landing into a table daily, this is done by Google and can happen at any time of the day. I then run a query to enrich and format the data into another table for use in Data Studio.