Salesforce connection options - AWS Glue
Services or capabilities described in AWS documentation might vary by Region. To see the differences applicable to the AWS European Sovereign Cloud Region, see the AWS European Sovereign Cloud User Guide.

Salesforce connection options

The following connection options are supported for the Salesforce connector:

  • ENTITY_NAME(String) - (Required) Used for Read/Write. The name of your Object in Salesforce.

  • API_VERSION(String) - (Required) Used for Read/Write. Salesforce Rest API version you want to use.

  • SELECTED_FIELDS(List<String>) - Default: empty(SELECT *). Used for Read. Columns you want to select for the object.

  • FILTER_PREDICATE(String) - Default: empty. Used for Read. It should be in the Spark SQL format.

    When providing a filter predicate, only the AND operator is supported. Other operators such as OR and IN are not currently supported.

  • QUERY(String) - Default: empty. Used for Read. Full Spark SQL query.

  • PARTITION_FIELD(String) - Used for Read. Field to be used to partition query.

  • LOWER_BOUND(String)- Used for Read. An inclusive lower bound value of the chosen partition field.

  • UPPER_BOUND(String) - Used for Read. An exclusive upper bound value of the chosen partition field.

  • NUM_PARTITIONS(Integer) - Default: 1. Used for Read. Number of partitions for read.

  • IMPORT_DELETED_RECORDS(String) - Default: FALSE. Used for read. To get the delete records while querying.

  • WRITE_OPERATION(String) - Default: INSERT. Used for write. Value should be INSERT, UPDATE, UPSERT, DELETE.

  • ID_FIELD_NAMES(String) - Default : null. Required for UPDATE and UPSERT.