Skip to main content
connector logo

Databend

Availability: Airbyte Cloud: ✅, Airbyte OSS: ✅
Support Level: Community
Latest Version: 0.1.2
Definition Id: 302e4d8e-08d3-4098-acd4-ac67ca365b88

This page guides you through the process of setting up the Databend destination connector.

Features

FeatureSupported?(Yes/No)Notes
Full Refresh SyncYes
Incremental - Append SyncYes

Output Schema

Each stream will be output into its own table in Databend. Each table will contain 3 columns:

  • _airbyte_ab_id: a uuid assigned by Airbyte to each event that is processed. The column type in Databend is VARCHAR.
  • _airbyte_emitted_at: a timestamp representing when the event was pulled from the data source. The column type in Databend is TIMESTAMP.
  • _airbyte_data: a json blob representing with the event data. The column type in Databend is VARVHAR.

Getting Started (Airbyte Cloud)

Coming soon...

Getting Started (Airbyte Open-Source)

You can follow the Connecting to a Warehouse docs to get the user, password, host etc.

Or you can create such a user by running:

GRANT CREATE ON * TO airbyte_user;

Make sure the Databend user with the following permissions:

  • can create tables and write rows.
  • can create databases e.g:

You can also use a pre-existing user but we highly recommend creating a dedicated user for Airbyte.

Target Database

You will need to choose an existing database or create a new database that will be used to store synced data from Airbyte.

Setup the Databend Destination in Airbyte

You should now have all the requirements needed to configure Databend as a destination in the UI. You'll need the following information to configure the Databend destination:

  • Host
  • Port
  • Username
  • Password
  • Database

Compatibility

If your databend version >= v0.9.0 or later, you need to use databend-sqlalchemy version >= v0.1.0. And the Databend Cloud will only support databend version > 0.9.0.

Changelog

VersionDatePull RequestSubject
0.1.22023-02-1122855Fix compatibility issue with databend-query 0.9
0.1.12022-01-0921182Remove protocol option and enforce HTTPS
0.1.02022-01-0920909Destination Databend