Connect with Twilio Segment

Prerequisites

An active SingleStore deployment with the Data API enabled. Refer to Enable the Data API for related information.
Configure the Inbound IP Allowlist of your SingleStore deployment to allow access from Twilio Segment. Refer to IP Address Allowlisting for related information.
A Twilio Segment instance with active sources.

Connect to SingleStore from Segment

To connect your SingleStore database,

Configure SingleStore as a destination in Segment for a specific source.
Configure field mappings and stream data into SingleStore.
(Optional) Verify that events are being streamed.

Configure the SingleStore Destination

To configure SingleStore as a destination in Twilio Segment,

Log in to your Segment workspace.
On the left navigation pane, select Connections > Sources.
From the list of Sources, select a source.
On the selected source's page, select Add Destination.
On the Catalog page, under Destinations, select SingleStore. You can also search "SingleStore" and select it from the search results.
On the SingleStore page, select Add destination.
Under Setup, enter a name for the destination in the Destination name field.
Select Create destination. The SingleStore destination is created.
On the Settings tab of your destination, configure the connection to your SingleStore database. Enter the following information:
1. Host: Hostname or IP address of your SingleStore deployment. Refer to SingleStore Helios Endpoints for related information.
2. Port: Port of the SingleStore Data API. The default is 443.
3. Username: Username of the SingleStore database user with which to connect.
4. Password: Password for the SingleStore database user.
5. Database Name: Name of the SingleStore database to connect with.
6. Table Name: Name of the target table in the specified database. The default is segment_data.
Select Save Changes to save the destination configuration.

Configure Mappings and Stream Data

To configure mappings from source event to destination field and stream data into SingleStore,

Select the Mappings tab for your destination.
Under Mappings, select New Mapping.
Under Set up mapping, select Send Data.
On the same page, under Map Fields, configure the source event to destination field mapping.
Select Next.
Enter a name for the mapping in the Mapping name field.
Select Save. The mapping is saved.
On the Settings tab for your destination, enable the Enable Destination toggle.

Once the mappings are configured and the destination is enabled, events are streamed to the specified SingleStore table as they are received.

Verify Event Streaming

To verify that events are streamed,

Log in to your SingleStore deployment (Cloud Portal).
Select <your_deployment> > Connect > SQL Editor.

Run the following query(s) to verify that events are streamed to SingleStore:

SQL

-- Count the number of events ingested --
-- Update the table name to the specified target table --
SELECT COUNT(*)
FROM segment_data;

SQL

-- View the 10 most recent ingested events --
-- Update the table name to the specified target table --
SELECT * FROM segment_data
ORDER BY timestamp DESC
LIMIT 10;

You can also connect to your SingleStore deployment from a supported third-party client/application and run the query(s).

Disable Event Streaming

To disable event streaming,

Select <your_destination> > Settings.
Disable the Event Destination toggle.
Select Save Changes.