Airbyte

🐛 Fixes

- Expand default column size for non-integer `number` fields to `DECIMAL (38, 9)`, resolves issues with too-large number values (194)

✨ New Features

- Add [`fetch_connector_secret()`](https://airbytehq.github.io/PyAirbyte/airbyte/secrets/google_gsm.html#GoogleGSMSecretManager.fetch_connector_secret) convenience method on `GoogleGSMSecretManager`. (191)

🐛 Fixes

- Fix GSM secrets retrieval edge cases, and improve GSM CI tests. (191)

📖 Docs

- Improve docs around `0.10.x` features. (190)

🐛 Fix

- Install google secrets library as a main dependency (resolves `ImportError`). (189)

🐛 Fixes

- Resolve failures when loading large dataset by running Snowflake `PUT` queries sequentially (188) - _**Thanks, SebastienN15!**_

✨ New Features

- Add [`parse_json()`](https://airbytehq.github.io/PyAirbyte/airbyte/secrets/base.html#SecretHandle.parse_json) convenience method on [`SecretHandle`](file:///Users/ajsteers/Source/PyAirbyte/docs/generated/airbyte/secrets/base.htmlSecretHandle) class. (182)

✨ New Features

_This release focuses on broadening the vision of PyAirbyte, adding capabilities for Airbyte Cloud users to orchestrate their syncs using PyAirbyte. Secrets management is also significantly expanded. Lastly, we improve record parsing of problematic records thanks to a community contribution from SebastienN15._

☁️ Cloud Interop (143)

- Add ability to run Airbyte Cloud jobs with `CloudWorkspace.run_sync()`, which returns a `SyncResult` object.
- Add ability to check Airbyte Cloud sync statuses, wait for status, check number of records synced, etc.
- Add ability to get `CachedDataset` objects from completed Airbyte Cloud jobs, and read records from those final tables. (Snowflake and BigQuery only.)

🔐 Secrets Management (143)

- Add support for "BYO secrets" using `CustomSecretsManager`.
- Add a new custom secrets manager for Google GSM: `GoogleGSMSecretsManager`.

🐛 Fixes

- Improve parsing of deeply nested records by adding a fallback `json` parser (178) - **_Thanks, SebastienN15!!_**

🚀 New Features

_This release adds new metadata fields to all streams, including a unique record ID (`_airbyte_raw_id`) and timestamp (`_airbyte_extracted_at`). This release also adds a feature to auto-add new columns if they are missing from cache tables._

- Add new [internal Airbyte columns](https://airbytehq.github.io/PyAirbyte/airbyte/records.html#airbyte-managed-metadata-columns), aligned with Airbyte Destinations "v2" (144)
- [Auto-add missing columns](https://airbytehq.github.io/PyAirbyte/airbyte/records.html#schema-evolution) to Cache tables (144)
- New `StreamRecord` class and public `records` module (166)

📖 Documentation Updates

- Several new topics added to [reference docs](https://airbytehq.github.io/PyAirbyte/airbyte/records.html) (#144, 170):
- Schema Evolution
- Table and Field Name Normalization
- Airbyte-Managed Metadata Columns