Airbyte

🐛 Fixes

- Resolves issue where mixed-case stream properties would result in missing data (114)
- Resolves issue where loads would fail if records contained conflicting data types (67)
- Fixes an issue where `array` types would fail to parse if the subtype definition was invalid (113)

⚙️ Under the hood

- Cleans up public-facing API (109)
- Removes dependency on PyArrow, resulting in reduced errors and faster read speeds (67)

📘 Documentation Updates

- New and improved [API Reference Docs](https://airbytehq.github.io/PyAirbyte/airbyte/caches/bigquery.html) (#109)
- Adds usage samples for each cache option, including [Snowflake](https://airbytehq.github.io/PyAirbyte/airbyte/caches/bigquery.html), [DuckDB](https://airbytehq.github.io/PyAirbyte/airbyte/caches/snowflake.html), [Postgres](https://airbytehq.github.io/PyAirbyte/airbyte/caches/postgres.html), [BigQuery](https://airbytehq.github.io/PyAirbyte/airbyte/caches/bigquery.html), and [MotherDuck](https://airbytehq.github.io/PyAirbyte/airbyte/caches/motherduck.html) (#112)

🐛 Fixes

- Resolve Python 3.9 compatibility issues (98)

⚙️ Under the Hood

- Expand CI test matrix to include Python 3.9 and 3.11 (98)
- Loosen version requirements to better match Colab defaults (97)

⚙️ Under the Hood

- Refactor anonymous usage stats, ensure errors and record counts are properly reported (62)

🐛 Fixes

- Resolve issue where method `to_sql_table()` fails if called from a cached dataset (76)

✨ New Features

- Add support for rendering records as LLM documents (48)
- Add BigQuery cache support (65)

🐛 Fixes

- Fix IPython rendering bug when using a TTY (65)
- Fixed ability to pass `streams` list within `get_source()`(71)

_Note: This may be a breaking change due to the downgrade in our underlying DuckDB version used in cache creation. Read below for more information._

✨ New Features

- Add [MotherDuck](https://www.motherduck.com) cache support 🦆 (#43)

⚙️ Under the Hood

- Downgraded from DuckDB `v0.10.0` to `v0.9.2`. This may require you to rebuild your local cache files. See [the DuckDB v0.10.0 blog post](https://duckdb.org/2024/02/13/announcing-duckdb-0100.html) for information on backwards and forwards DuckDB compatibility between versions.