Advanced Analytica Advanced Analytica: IBOM
← All connectors
SingleStore logo

Source connector

SingleStore

Set up SingleStore as a source and move its data into your chosen destination.

Version 0.1.4 community alpha

SingleStore

Overview

SingleStore is a distributed SQL database for high-throughput transactions, including inserts and upserts. It provides low-latency analytics and context from real-time vector data.

Features

FeatureSupportedNotes
Full Refresh SyncYes
Incremental - Append SyncYes
Change Data CaptureNo
SSL SupportYes
SSH Tunnel ConnectionYes

Below, you’ll find a ‘Quick Start’ guide, advanced setup steps and reference information, including data type mapping and changelogs.

Get started

Requirements

  1. A SingleStore instance
  2. Allow connections from Airbyte to your SingleStore database (if they’re in separate VPCs)
  3. Create a dedicated, read-only Airbyte user with access to every table needed for replication

1. Make your database accessible from the machine running Airbyte

The required steps depend on your network setup. Use the check connection tool in the UI to confirm Airbyte can connect to your SingleStore instance.

This optional step gives you better permission control and auditing. Alternatively, you can connect Airbyte using an existing database user.

Create a dedicated database user by running these commands against your database:

CREATE
USER airbyte IDENTIFIED BY <your_password_here>;

Next, give the user read-only access to the relevant tables. The simplest approach grants read access to every table in the database:

GRANT
SELECT
ON <your_database_name_here>.* TO airbyte;

For more granular access, use:

GRANT SELECT ON "<database_a>"."<table_1>" TO airbyte;
GRANT SELECT ON "<database_b>"."<table_2>" TO airbyte;

Your database user is now ready to use with Airbyte.

Connect with SSL or SSH Tunneling

SSL modes

Choose from these SSL connection modes:

  • disable disables encrypted communication between Airbyte and the source
  • required always requires encryption. The connection fails if the source doesn’t support encryption.
  • verify-ca always requires encryption and verifies that the source has a valid SSL certificate
  • verify-full always requires encryption and verifies the source’s identity

Connect through an SSH Tunnel

Airbyte can connect to a SingleStore instance through an SSH Tunnel. Use this method when direct database access is unavailable or conflicts with your security policy. For example, the database might not have a public IP address.

With an SSH tunnel, Airbyte connects to an intermediate server, also called a bastion server. This server has direct database access. Airbyte connects to the bastion, which then connects directly to the database server.

This feature needs extra configuration when you create the source. The following steps explain each configuration setting.

  1. Configure every source field as usual, except SSH Tunnel Method.
  2. SSH Tunnel Method defaults to No Tunnel, which creates a direct connection. For an SSH Tunnel, choose SSH Key Authentication or Password Authentication.
    1. Choose Key Authentication when using an RSA private key to establish the SSH Tunnel. See below for key-generation details.
    2. Choose Password Authentication when using a password to establish the SSH Tunnel.
  3. SSH Tunnel Jump Server Host identifies the intermediate, or bastion, server that Airbyte connects to. Enter its hostname or IP Address.
  4. SSH Connection Port is the bastion server port used for the SSH connection. The default SSH port is 22. Keep this default unless you’ve explicitly changed the port.
  5. SSH Login Username is the username Airbyte uses to connect to the bastion server. This is NOT the SingleStore username.
  6. With Password Authentication, set SSH Login Username to the previous step’s User password. With SSH Key Authentication, leave this blank. This isn’t the SingleStore password. It’s the OS-user password Airbyte uses to run commands on the bastion.
  7. With SSH Key Authentication, set SSH Private Key to the RSA Private Key used for the SSH connection. Include the key file’s full contents, starting with -----BEGIN RSA PRIVATE KEY----- and ending with -----END RSA PRIVATE KEY-----.

Generate a private key for SSH Tunneling

The connector requires an RSA key in PEM format. Generate the key as follows:

ssh-keygen -t rsa -m PEM -f myuser_rsa

This creates the private key in PEM format. The public key remains in the standard format used by your bastion host’s authorized_keys file. Add the public key to the bastion host for the user you’ll connect with through Airbyte. Copy and paste the private key into the Airbyte connector configuration screen. Airbyte can then use it to log in to the bastion.

Data type mapping

When you synchronise data, SingleStore data types map to the following data types.

SingleStore
Type
Resulting TypeNotes
BITbase64 binary string
TINYINTnumber
SMALLINTnumber
MEDIUMINTnumber
INTnumber
BIGINTnumber
FLOATnumber
DOUBLEnumber
DECIMALnumber
DATEstring
TIMEstring
DATETIMEstring
TIMESTAMPstring
YEARyear string
CHARstring
VARCHARstring
LONGTEXTstring
MEDIUMTEXTstring
TEXTstring
TINYTEXTstring
BINARYbase64 binary string
VARBINARYbase64 binary string
LONGBLOBbase64 binary string
MEDIUMBLOBbase64 binary string
BLOBbase64 binary string
TINYBLOBbase64 binary string
JSONserialized json string
ENUMstring
SETstring
GEOGRAPHYPOINTstring
GEOGRAPHYstring
VECTORstring

IP allow list

If you use Airbyte Cloud and restrict access to specific IPs, add the Airbyte Cloud IP addresses to your allow list.

Changelog

VersionDatePull RequestSubject
0.1.42025-07-1062925Convert to new gradle build flow
0.1.32025-05-0859722Consolidate gradle setup.
0.1.22025-01-1051501Use a non root base image
0.1.12024-12-1849862Use a base image: airbyte/java-connector-base:1.0.0
0.1.02024-04-1637337Add SingleStore source connector
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.