Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Consider moving resumption state out of BigQuery #70

Open
imor opened this issue Dec 1, 2024 · 0 comments
Open

Consider moving resumption state out of BigQuery #70

imor opened this issue Dec 1, 2024 · 0 comments

Comments

@imor
Copy link
Contributor

imor commented Dec 1, 2024

BigQuery rate limits number of DML statements against a table: https://cloud.google.com/bigquery/docs/data-manipulation-language#update_delete_merge_dml_concurrency. This might result in data writes to copied_tables and last_lsn tables failing under heavy load. Consider moving resumption state to either the API db or source db. Or maybe even hide resumption state logic behind a trait like ResumptionStateStore which allows users to pick a location of their own for the resumption state store (source db, API db, file etc.).

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant