Account Services
Introduction
The goal of this pipeline is to make the Account Services dataset available in Google Big Query where it can be queried using the SQL interface for business purposes and to drive downstream business processes.
Scenarios
Customers could use the data broker data set of account services to access data related to Accounts, Transactions, Available Balance, Holds, Stop Payments, Stop Payment Settings and Products available within digital banking platform.
Pipelines
The Account Services pipeline utilizes BigQuery External Connections in the Data Broker project, to the Publisher Spanner database in their project. Federated Queries are used with External Connections to the Spanner databases from BiqQuery. The Federated Queries are used to pull data from the Spanner Database into the BigQuery dataset / tables.
Schedule
The Federated Queries are scheduled to run hourly.