The PuffinDB extension for DuckDB will make it possible to use any Airbyte Connector directly from DuckDB.
Support for Airbyte connectors will be offered using the following components:
Airbyte will run cloud-side.
Airbyte Core will not be used.
Read operations performed through Airbyte connectors will use the following syntax:
SELECT * FROM airbyte(...)The syntax for write operations is currently under development.
- Solid architecture
- Best collection of read | write connectors currently available under a liberal open source license
- Developed by great company that could provide commercial support if necessary
- No need to develop and | or install one DuckDB extension per application
- Mature and robust framework for developing new connectors
- Ability to perform joins across applications
- Ability to integrate with hundreds of applications through SQL
- Ability to use SQL query generators like PRQL or Malloy (Cf. Query Proxy)
- Ability to execute on the Edge-Driven Data Integration vision