Move SingleStore data anywhere it matters.

Stream SingleStore data to any warehouse or AI app.

Sync SingleStore free Read the docs

Source

SingleStore

Snowflake
BigQuery
Postgres
Databricks
Claude

Destinations: 50+
Standard support: 0.1.4

Overview

What is the Airbyte SingleStore connector?

The Airbyte SingleStore connector extracts data from SingleStore and loads it into 50+ destinations such as Snowflake, BigQuery, Databricks or Postgres, with full refresh and incremental sync. It publishes tables and events you can select per connection.

01
Sync to your warehouse
Land SingleStore data in 50+ destinations on a schedule you control.
02
Incremental syncs
Pull only the records that changed since the last run instead of reloading everything.
03
One authorization
Authenticate SingleStore once and Airbyte keeps every scheduled sync running on it.
04
Cloud or self-hosted
Run the SingleStore connector on OSS.

Setup

Live in eleven steps

You can just use the MySQL source connector to connect your SingleStore database:
Open the Airbyte UI and navigate to the "Sources" tab.
Click on the "Add Source" button and select "MySQL" from the list of available sources.
Enter a name for your MySQL source and click on the "Next" button.
Enter the necessary credentials for your MySQL database, including the host, port, username, and password.
Select the database you want to connect to from the drop-down menu.
Choose the tables you want to replicate data from by selecting them from the list.
Click on the "Test" button to ensure that the connection is successful.
If the test is successful, click on the "Create" button to save your MySQL source configuration.
You can now use your MySQL connector to replicate data from your MySQL database to your destination of choice.
‍

Configuration fields

SingleStore configuration fields
Field	Type	Description
database*	string	Name of the database.
host*	string	Hostname of the database.
port*	integer	Port of the database.
replication_method*	string	Replication method to use for extracting data from the database. STANDARD replication requires no setup on the DB side but will not be able to represent deletions incrementally.
username*	string	Username to use to access the database.
jdbc_url_params	string	Additional properties to pass to the JDBC URL string when connecting to the database formatted as 'key=value' pairs separated by the symbol '&'. (example: key1=value1&key2=value2&key3=value3). For more information read about JDBC URL parameters.
password	string	Password associated with the username.
ssl_mode	object	SSL connection modes.