Connect to Salesforce
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-27-2023 08:17 AM
Curious if there's a Databricks connector for Salesforce on AWS?
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-27-2023 08:22 AM
There is no "databricks" connector like the on you have in Unity Fedarating e.g. for Snowflake.
You can use partner ecosystem e.g. Fivetran
https://www.fivetran.com/connectors/salesforce
to integrate Salesforce data to your Lakehouse.
You also have spark salesforce library avaliable there:
https://github.com/springml/spark-salesforce
If you import this library, you can do :
spark.
read.
format("com.springml.spark.salesforce").
option("username", "your_salesforce_username").
option("password", "your_salesforce_password_with_secutiry_token"). //<salesforce login password><security token>
option("saql", saql)
option("inferSchema", "true").
load()