Firebolt

Rockset is the cloud data warehouse for modern data engineering & dev teams.

Authentication Methods

Firebolt connections support Username & Password authentication.

Supported Data Types

The following table describes the current mapping between Firebolt data types and Salesforce.

Firebolt	Corresponding Salesforce type
FLOAT, DOUBLE	NUMBER_TYPE if the precision is < 18, otherwise STRING_SHORT_TYPE
INT,LONG	NUMBER_TYPE
BOOLEAN	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, truncated automatically to 255 characters (Firebolt does not allow varchar length limiting)