How to access Google Cloud billing data cost forecast, using node.js?

Question

I'm able to extract aggregated and itemised billing data from Google Cloud using BigQuery, against exported billing data. I'd like to be able to query the forecast billing data that is shown in the console, but I can't find this in any API or referenced anywhere for use in the billing data export. Is it possible?

Answer 1

• The forecasted billing data is not available to export to BigQuery. The forecast costs can only be viewed as graphs from the Cloud Billing console.
• A forecasting model can be built on the past data for analysis using BigQuery ML.
• Google Data Studio also can be used to forecast costs as shown in this article.