cancel
Showing results for 
Search instead for 
Did you mean: 
Administration & Architecture
cancel
Showing results for 
Search instead for 
Did you mean: 

Connect to Salesforce

leelee3000
New Contributor III
New Contributor III

Curious if there's a Databricks connector for Salesforce on AWS? 

1 REPLY 1

Wojciech_BUK
Contributor III

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()