Blockchain-Data-Analytics / Cardano_on_BigQuery

Cardano on-chain data made accessible on BigQuery
Apache License 2.0
4 stars 2 forks source link

Create a one big transaction #24

Open monoid-is-a-monad opened 1 week ago

monoid-is-a-monad commented 1 week ago

This PR attempts to make the updates more atomic. Every table update script instead of performing the update, returns the SQL query that needs to be done. All the SQL queries are then concatenated in one big string that gets executed as a single transaction.

The benefit of this is that we have more atomic updates. The drawback is that in case a table falls back, it won't catch up as it used to do