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

Feat: Add BigQuery cache support; Fix: IPython rendering bug when using a TTY #65

Merged
merged 16 commits into from
Feb 25, 2024

Conversation

bindipankhudi
Copy link
Contributor

@bindipankhudi bindipankhudi commented Feb 23, 2024

Added the following:

  • BigQuery cache - still uses the config/cache, and parquet, so you won't be able to run the test file at the moment. i will fix that shortly.
  • test file - examples/run_bigquery_faker.py

For append and replace cases, data gets written to final table and temp table also gets removed. Writing to _airbytelib_state fails due to some datetime/timestamp mismatch.

@aaronsteers aaronsteers changed the title Initial additions for supporting bigquery (WIP) Feat: (draft) Support BigQuery cache (WIP) Feb 24, 2024
@aaronsteers aaronsteers changed the title Feat: (draft) Support BigQuery cache (WIP) Feat: Add BigQuery cache support (WIP) Feb 24, 2024
Copy link
Contributor

@aaronsteers aaronsteers left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

This is working well now. Some implementation details were just not possible with the sqlalchemy library, so those are implemented using the google-cloud-bigquery library.

airbyte/_processors/sql/base.py Show resolved Hide resolved
airbyte/_processors/sql/base.py Show resolved Hide resolved
airbyte/_processors/sql/base.py Show resolved Hide resolved
airbyte/_processors/sql/bigquery.py Show resolved Hide resolved
airbyte/_processors/sql/bigquery.py Show resolved Hide resolved
airbyte/_processors/sql/bigquery.py Show resolved Hide resolved
airbyte/caches/_catalog_manager.py Show resolved Hide resolved
@aaronsteers aaronsteers changed the title Feat: Add BigQuery cache support (WIP) Feat: Add BigQuery cache support Feb 24, 2024
@aaronsteers
Copy link
Contributor

@bindipankhudi - This one is ready to merge. 🚀

Thanks for working out all the implementation details and type conversion issues. I noted my changes in a review above.

I'll probably merge this in today or tomorrow, since it contains some other bug fixes and optimizations which will be helpful broadly.

@bindipankhudi
Copy link
Contributor Author

bindipankhudi commented Feb 24, 2024 via email

Copy link
Contributor Author

@bindipankhudi bindipankhudi left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Everything looks great! Great call on using the Google Bigquery library!

@aaronsteers aaronsteers changed the title Feat: Add BigQuery cache support Feat: Add BigQuery cache support, fix IPython rendering bug when using a TTY Feb 25, 2024
@aaronsteers aaronsteers changed the title Feat: Add BigQuery cache support, fix IPython rendering bug when using a TTY Feat: Add BigQuery cache support; Fix: IPython rendering bug when using a TTY Feb 25, 2024
@aaronsteers aaronsteers enabled auto-merge (squash) February 25, 2024 17:11
@aaronsteers aaronsteers merged commit 6cfc3b5 into main Feb 25, 2024
11 checks passed
@aaronsteers aaronsteers deleted the bindi/add_bigquery branch February 25, 2024 17:14
@aaronsteers aaronsteers self-assigned this Mar 11, 2024
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

Successfully merging this pull request may close these issues.

2 participants