Salesforce integration authentication method does not work in Enterprise Edition sandbox environment

[guangyuchendice]

Describe the bug
I built the salesforce ingestion recipe according to the documentation provided (please see below recipe). I tested that against Salesforce Enterprise edition with both Direct access token as well as password method but failed.
For access token one, the token is invalid even it was only generated within a minute:
Response content: [{'message': 'Session expired or invalid', 'errorCode': 'INVALID_SESSION_ID'}]
For username/passoword:
ERROR {datahub.ingestion.source.salesforce:231} - INVALID_LOGIN: Invalid username, password, security token; or user locked out.
But I am using the correct credential and tokens. Just not Salesforce enterprise edition sandbox

To Reproduce
Steps to reproduce the behavior:

1. datahub ingest -c ~/salesforce.dhub.yml where the yaml file is below code tex.text

Expected behavior
Authentication should not be failing

Desktop (please complete the following information):

• OS: Mac OS
• Browser [Chrome]
• Version [e.g. 22]

recipe
tex.txt

[guangyuchendice]

I tried out the simple-salesforce library that the plugin relies on. It seems that if I missed domain='test' argument during the login I will have the same problem. Therefore I think the api should provide a choice of adding domain names as argument for login purpose.

[github-actions]

This issue is stale because it has been open for 30 days with no activity. If you believe this is still an issue on the latest DataHub release please leave a comment with the version that you tested it with. If this is a question/discussion please head to https://slack.datahubproject.io. For feature requests please use https://feature-requests.datahubproject.io

[mayurinehate]

Closed by #6105
Set is_sandbox: True in recipe.