Rockset
Rockset is a real-time analytics database for fast queries on fresh data from databases, lakes and streams.

Authentication Methods

Rockset connections support API Key authentication.

Supported Data Types

Rockset is a document store and does not impose static typing on columns.
Because Salesforce fields expect consistent data types to be used, it is your responsibility to ensure that this occurs.
If you aren't careful with this, you may see runtime errors like:
The "amount__c" field is of type number, but the value from the external system is "hello"
The Omnata Setup process will make every effort to choose an appropriate data type, but in some situations it relies on a sample of values that don't cover the full range of possibilities.
If you prefer to guarantee readability and sacrifice some filtering capability, you can manually change the Salesforce field type to Text.
The following table describes the current mapping between Rockset data types and Salesforce.
Rockset
Corresponding Salesforce type
float
NUMBER_TYPE if the precision is < 18, otherwise STRING_SHORT_TYPE
int
NUMBER_TYPE
bool
BOOLEAN_TYPE (rendered as Checkbox)
Note that Salesforce does not support null values here, so you must ensure that none exist.
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
DATETIME_TYPE
timestamp
DATETIME_TYPE
time
STRING_SHORT_TYPE
string
STRING_SHORT_TYPE if the max length is <255, otherwise STRING_LONG_TYPE
Last modified 1mo ago
Copy link
On this page
Authentication Methods
Supported Data Types