Airbyte is an open-source data integration engine that helps you consolidate your data in your data warehouses, lakes and databases.

Airbyte

Hi <!channel>! We are back with some patch notes after a restful vacation and are ready to have a productive year! :octavia-rocket: Here's all of the changes from `0.34.1` to `0.35.3`. As a heads up, I've thrown :bug: fixes into the thread attached to this announcement!

*New Source*: <https://docs.airbyte.com/integrations/sources/tplcentral|3PL Central> (_contributed by <@U02G3JH0UJK>_)
*New Source*: <https://docs.airbyte.com/integrations/sources/my-hours|My Hours> (_contributed by <@U02NMGT3SD8>_)
*New Source*: <https://docs.airbyte.com/integrations/sources/qualaroo|Qualaroo> (_contributed by <@U01L9M19C14>_)
*New Source*: <https://docs.airbyte.com/integrations/sources/search-metrics|SearchMetrics>

:gem: *Salesforce* Source: Now supports filtering streams at configuration, making it easier to handle large Salesforce instances.
:gem: *Snowflake* Destination: Now supports byte-buffering for staged inserts.
:gem: *Redshift* Destination: Now supports byte-buffering for staged inserts.

:sparkles: *Postgres* Source: Now supports all Postgres 14 types.
:sparkles: *Recurly* Source: Now supports incremental sync for all streams.
:sparkles: *Zendesk Support* Source: Added the `Brands`, `CustomRoles`, and `Schedules` streams.
:sparkles: *Zendesk Support* Source: Now uses cursor-based pagination.
:sparkles: *Kustomer* Source: Setup configuration is now more straightforward.
:sparkles: *Hubspot* Source: Now supports incremental sync on all streams where possible.
:sparkles: *Facebook Marketing* Source: Fixed schema for `breakdowns` fields.
:sparkles: *Facebook Marketing* Source: Added `asset_feed_spec` to `AdCreatives` stream.
:sparkles: *Redshift* Destination: Now has an option to toggle the deletion of staging data.

Thank you to our fantastic contributors from the past few weeks who have guided us into the new year :tada: <@U01SHGFT4U9>, <@U01K42HRHHC>, <@U02G3JH0UJK>, <@U024MAAR490>, <@U024QBKM09G>, <@U02259V6QTZ>, <https://github.com/jdclarke5|@jdclarke5>, <@U02L4U2HMPH>, <@U02S2ASNDSL>, <https://github.com/mariusandra|@mariusandra>, <@U0220HR9V29>, <https://github.com/jzcruiser|@jzcruiser>, <@U02BKD6FLAE>, <@U026U0L29K5>, <@U02NMGT3SD8>, <@U01L9M19C14>, <@U02S3UYER88>, <@U01N7JCHS8M>, and <https://github.com/haoranyu|@haoranyu>!

:bug: *S3* Destination: Avro and Parquet formats are now processed correctly.
:bug: *Snowflake* Destination: Fixed SQL Compliation error.
:bug: *Kafka* Source: `SASL` configurations no longer throw null pointer exceptions (_contributed by <@U02BKD6FLAE>_)
:bug: *Salesforce* Source: Now throws a `400` for non-queryable streams.
:bug: *Amazon Ads* Source: Polling for report generation is now much more resilient. (_contributed by <@U02G3JH0UJK>_)
:bug: *Jira* Source: The `filters` stream now works as expected.
:bug: *BigQuery* Destination: You can now properly configure the buffer size with the `part_size` config field.
:bug: *Snowflake* Destination: You can now properly configure the buffer size with the `part_size` config field.
:bug: *CockroachDB* Source: Now correctly only discovers tables the user has permission to access.
:bug: Stripe Source: The `date` and `arrival_date` fields are now typed correctly.

What a huge release!! Shoutout to whoever added Zendesk Brands truly grateful - been on our backlog for months!

Awesome!! thanks <@U024QBKM09G> :slightly_smiling_face: