About BigQuery Reporting Bridge
Learn what BigQuery Reporting Bridge (BQRB) is and how you can use it.
What is BQRB?
BigQuery Reporting Bridge or BQRB for short is a reporting bridge you can use to create Ledger reports using BigQuery. It is useful when you already have your data in BigQuery as it means that you don't need to reimplement the report creation protocol described in About Reports.
What does BQRB do?
After report creation is initiated, the BQRB calls the configured BigQuery stored procedure with the report record of the report to be created.
The stored procedure validates the report record, along with all the parameters and generates the report. It then stores it in the proper Google Cloud Storage bucket and responds to the BQRB with the partial proof to be sent to Ledger. This proof contains the status of report creation as well as references to any generated assets.
The BQRB then signs the proof and sends it to Ledger. The diagram of the entire interaction can be seen below.
Built-in reports
Every ledger instance comes with a BQRB preinstalled which can generate some built-in reports. To find out how to generate those reports, go to How to enable BQRB reports.