BigQuery

Google BigQuery is a fully-managed, serverless data warehouse that enables scalable analysis over petabytes of data. It is a Platform as a Service that supports querying using ANSI SQL.

Authentication Methods

BigQuery connections support OAuth. A refresh token is requested which does not expire.

Supported Data Types

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

BigQuery
Corresponding Salesforce type

NUMERIC

NUMBER_TYPE if the precision is < 18, otherwise STRING_SHORT_TYPE

INT64

NUMBER_TYPE

FLOAT64

STRING_SHORT_TYPE, length 21

BINARY

Not supported

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.

TIMESTAMP

DATETIME_TYPE

TIME

STRING_SHORT_TYPE

STRING

STRING_SHORT_TYPE if the max length is <255, otherwise STRING_LONG_TYPE

Last updated