SingleStore (previously MemSQL)
SingleStore is a distributed, relational, SQL database management system that features ANSI SQL support and is known for speed in data ingest, transaction processing, and query processing.
Last updated
SingleStore is a distributed, relational, SQL database management system that features ANSI SQL support and is known for speed in data ingest, transaction processing, and query processing.
Last updated
You must have a SingleStore Managed Service, with the HTTP API enabled.
SingleStore connections support Username & Password authentication.
The following table describes the current mapping between Firebolt data types and Salesforce.
| SingleStore | Corresponding Salesforce type |
|---|---|
float, double, decimal,int,tinyint,smallint,mediumint,bigint
NUMBER_TYPE if the precision is < 18, otherwise STRING_SHORT_TYPE
bool
NUMBER_TYPE
(not BOOLEAN_TYPE, because NULL values wouldn't be supported)
date
Dates are not supported by Salesforce Connect, but the adapter converts to DATETIME_TYPE (at midnight) for convenience.
This makes them usable but potentially misleading.
datetime,timestamp
DATETIME_TYPE
varchar, text
STRING_SHORT_TYPE if the max length is <255, otherwise STRING_LONG_TYPE
char
STRING_SHORT_TYPE, 1 character