General Ledger
Pipelined Data Sets
>
General Ledger
Introduction
The goal of this pipeline is to make the General Ledger dataset available in Google Big Query where it can be queried using the SQL interface for business purposes and to drive downstream business processes.
Pipelines
The General Ledger pipeline pipeline utilizes BigQuery External Connections in the Data Hub 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 daily.
Topics in this section
- account_raw
- dailybalance_raw
- institutionsettings_raw
- totalinggroup_raw
- totalinggroupmapping_raw
- transaction_raw
- transactionset_raw
Have a Question?
Have a how-to question? Seeing a weird error? Get help on
StackOverflow.
Register for the Digital Toolkit Meetup
where we answer technical Q&A from the audience.
Last updated Tue Feb 25 2025