Loading
The online Trailblazer Community becomes read-only Oct 30, 2026Read More
Important Advisory: iOS Update Impacting CG Mobile ApplicationRead More
Extend Salesforce with Clicks, Not Code
Map Salesforce External Object Field to Amazon Athena Data Types

You are here:

  1. Salesforce Help
  2. Docs
  3. Extend Salesforce with Clicks, Not Code

Map Salesforce External Object Field to Amazon Athena Data Types

External object fields of Salesforce Connect SQL adapter for Amazon Athena can be mapped to columns with scalar types such as strings and numbers. External object fields can’t be mapped to columns containing complex or nested data types such as an array, map, or struct.

Required Editions

Available in: both Salesforce Classic and Lightning Experience

Available in: Developer Edition

Available for an extra cost in: Enterprise, Performance, and Unlimited Editions

The table details the mappings between column types in Amazon Athena to external object field types in Salesforce.

Amazon Athena Data Type Salesforce External Object Field Type
boolean Checkbox
tinyint, smallint, int and integer, bigint, double, float, decimal

Number

Mapped to default precision and scale, which you can override.
char Text or Text Area
varchar, string Text, Text Area, or Text Area (Long)
date

Date

Supported format is YYYY-MM-DD
timestamp

Date/Time

Supported format is yyyy-MM-dd HH:mm:ss.f

For example, ‘2008-09-15 03:04:05.324'
Note
Note For Time Salesforce field type, there isn’t an equivalent column type in Amazon Athena.

This mapping strategy is for Amazon Athena data types to some of the common field types of external objects in Salesforce.

  • A char, string, or varchar data type that represents a phone, URL, Text, Text Area, Text Area (Long), or Email is stored as the corresponding Salesforce field type.
  • A char, string, or varchar data type that represents a Picklist is rendered as Salesforce defined enumeration values. For Picklist (Multi-Select), it’s stored as comma-separated values of the selected choices.
  • A decimal data type that represents a percent is stored as a numeric value of percent type.
  • A decimal data type that represents currency is stored as a numeric value using the currency symbol configured for the Salesforce org.
Note
Note When you manually create fields for an external object, make sure that the mapped attributes are of a compatible type.

See Also

 
Loading
Salesforce Help | Article