AWS Glue: Salesforce connector. Filter data from object

The error you're encountering suggests that the field name "lastmodifieddate" is not recognized by the Salesforce connector in AWS Glue. This could be due to a case sensitivity issue or an incorrect field name. In Salesforce, the correct field name for the last modified date is typically "LastModifiedDate" with capital letters.

To resolve this issue, try modifying your filter predicate to use the correct case:

"FILTER_PREDICATE": "LastModifiedDate > '2024-11-11'"

Additionally, ensure that the date format in your filter matches the expected format for Salesforce SOQL queries. You might want to use the ISO 8601 format:

"FILTER_PREDICATE": "LastModifiedDate > 2024-11-11T00:00:00Z"

If you're still encountering issues, double-check that the "Lead" object in your Salesforce instance has the "LastModifiedDate" field available and that your connection has the necessary permissions to access it.

Remember that when working with AWS Glue's Salesforce connector, it's important to use the correct field names as they appear in Salesforce, respecting case sensitivity. The connector translates your filter predicate into a SOQL query, so adhering to Salesforce's naming conventions is crucial for successful data extraction and filtering.
Sources
AWS Glue now supports native SaaS connectivity: Salesforce connector available now - AWS
Creating connections for connectors - AWS Glue
Filter - AWS Glue

In the Salesforce connector, try using the following syntax for the filter:

where LastModifiedDate > TIMESTAMP '2025-05-05 00:00:00 UTC'

I was able to test this using my SFDC developer account and the CASE entity/table.

Hope this helps!