Advanced Analytica Advanced Analytica: IBOM
← All connectors
Databend logo

Destination connector

Databend

Send governed data into Databend with a clear, practical setup guide.

Version 0.1.47 community alpha

Databend

Set up the Databend destination connector by following this guide.

Output schema

Each stream outputs to its own Databend table. Each table contains three columns:

  • _airbyte_ab_id: a UUID that Airbyte assigns to each processed event. The Databend column type is VARCHAR.
  • _airbyte_emitted_at: a timestamp showing when the event was pulled from the data source. The Databend column type is TIMESTAMP.
  • _airbyte_data: a JSON blob containing the event data. The Databend column type is VARVHAR.

Supported sync modes

Sync modeSupported?
Full Refresh - OverwriteYes
Full Refresh - AppendYes
Full Refresh - Overwrite + DedupedNo
Incremental Sync - AppendYes
Incremental Sync - Append + DedupedNo

Get started with Airbyte Cloud

Coming soon…

Get started with Airbyte Open Source

Follow the Connecting to a Warehouse docs to get the user, password, host and other details.

Alternatively, create this user by running:

GRANT CREATE ON * TO airbyte_user;

Make sure the Databend user has these permissions:

  • Can create tables and write rows.
  • Can create databases, for example:

You can use an existing user, but creating a dedicated Airbyte user is strongly recommended.

Target database

Choose an existing database or create one to store data synced from Airbyte.

Set up the Databend destination

You now have everything required to configure Databend as a destination in the UI. You’ll need these details:

  • Host
  • Port
  • Username
  • Password
  • Database

Compatibility

For Databend version >= v0.9.0, you need databend-sqlalchemy version >= v0.1.0. The Databend Cloud only supports Databend version > 0.9.0.

Namespace support

This destination doesn’t support namespaces.

Changelog

Expand to review

| Version | Date | Pull Request | Subject | | :------------------------------------------------------- | :--------------------------------------- | :-------------------------------------------------------- | :------------------------------------------------------- | ----------- | | 0.1.47 | 2025-04-19 | 58228 | Update dependencies | | 0.1.46 | 2025-04-12 | 57624 | Update dependencies | | 0.1.45 | 2025-04-05 | 57144 | Update dependencies | | 0.1.44 | 2025-03-29 | 56576 | Update dependencies | | 0.1.43 | 2025-03-22 | 56126 | Update dependencies | | 0.1.42 | 2025-03-08 | 55409 | Update dependencies | | 0.1.41 | 2025-03-01 | 54881 | Update dependencies | | 0.1.40 | 2025-02-22 | 54276 | Update dependencies | | 0.1.39 | 2025-02-15 | 53909 | Update dependencies | | 0.1.38 | 2025-02-08 | 53433 | Update dependencies | | 0.1.37 | 2025-02-01 | 52895 | Update dependencies | | 0.1.36 | 2025-01-25 | 52215 | Update dependencies | | 0.1.35 | 2025-01-18 | 51721 | Update dependencies | | 0.1.34 | 2025-01-11 | 51280 | Update dependencies | | 0.1.33 | 2024-12-28 | 50472 | Update dependencies | | 0.1.32 | 2024-12-21 | 50201 | Update dependencies | | 0.1.31 | 2024-12-14 | 48916 | Update dependencies | | 0.1.30 | 2024-11-25 | 48664 | Update dependencies | | 0.1.29 | 2024-10-19 | 46992 | add ssl param for databend destination | | 0.1.28 | 2024-11-04 | 48272 | Update dependencies | | 0.1.27 | 2024-10-28 | 47069 | Update dependencies | | 0.1.26 | 2024-10-12 | 46811 | Update dependencies | | 0.1.25 | 2024-10-05 | 46418 | Update dependencies | | 0.1.24 | 2024-09-28 | 46197 | Update dependencies | | 0.1.23 | 2024-09-21 | 45824 | Update dependencies | | 0.1.22 | 2024-09-14 | 45531 | Update dependencies | | 0.1.21 | 2024-09-07 | 45237 | Update dependencies | | 0.1.20 | 2024-08-31 | 45001 | Update dependencies | | 0.1.19 | 2024-08-24 | 44756 | Update dependencies | | 0.1.18 | 2024-08-22 | 44530 | Update test dependencies | | 0.1.17 | 2024-08-17 | 44300 | Update dependencies | | 0.1.16 | 2024-08-10 | 43611 | Update dependencies | | 0.1.15 | 2024-08-03 | 43234 | Update dependencies | | 0.1.14 | 2024-07-27 | 42588 | Update dependencies | | 0.1.13 | 2024-07-20 | 42164 | Update dependencies | | 0.1.12 | 2024-07-13 | 41800 | Update dependencies | | 0.1.11 | 2024-07-10 | 41429 | Update dependencies | | 0.1.10 | 2024-07-09 | 41243 | Update dependencies | | 0.1.9 | 2024-07-06 | 40916 | Update dependencies | | 0.1.8 | 2024-06-27 | 40215 | Replaced deprecated AirbyteLogger with logging.Logger | | 0.1.7 | 2024-06-25 | 40301 | Update dependencies | | 0.1.6 | 2024-06-21 | 39936 | Update dependencies | | 0.1.5 | 2024-06-04 | 39090 | [autopull] Upgrade base image to v1.2.1 | | 0.1.4 | 2024-05-21 | 38510 | [autopull] base image + poetry + up_to_date | | 0.1.3 | 2024-03-05 | #35838 | Un-archive connector | | 0.1.2 | 2023-02-11 | 22855 | Fix compatibility | | issue with databend-query 0.9 | | 0.1.1 | 2022-01-09 | | 21182 | Remove protocol option and enforce HTTPS | | | 0.1.0 | 2022-01-09 | 20909 | Destination | | Databend |

Advanced Analytica

Most businesses are sitting on information they can’t use at speed. The people who hold it are busy, and when they leave, the knowledge goes with them. The documents are static, and the processes around them weren’t designed for AI.

Advanced Analytica works with these businesses to turn that information into structured data assets. Once they're integrated, AI systems can govern it, and the business can use it. We bring in the strategy, the specification and the AI skills to rework how the business operates.

MOVE FAST. STAY SAFE.