# SingleStore (previously MemSQL)

## SingleStore Account Prerequisites <a href="#snowflake-account-prerequisites" id="snowflake-account-prerequisites"></a>

You must have a SingleStore Managed Service, with the HTTP API enabled.

## Authentication Methods

SingleStore connections support Username & Password authentication.

## Supported Data Types

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                                                         | <p>NUMBER\_TYPE</p><p><em>(not BOOLEAN\_TYPE, because NULL values wouldn't be supported)</em></p>                                                                                        |
| date                                                         | <p>Dates are not supported by Salesforce Connect, but the adapter converts to DATETIME\_TYPE (at midnight) for convenience.</p><p>This makes them usable but potentially misleading.</p> |
| 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                                                                                                                                                         |