Hi @LakehouseOMG14 ,

If you want to extract data from Salesforce and load it to Delta Table than you can use Lakeflow Connect.
There are some requirements you must meet to use that approach:

• Your workspace must be enabled for Unity Catalog.

• Serverless compute must be enabled for your workspace. See Enable serverless compute.

• If you plan to use an existing connection: You must have USE CONNECTION privileges or ALL PRIVILEGES on the connection object.

• You must have USE CATALOG privileges on the target catalog.

• You must have USE SCHEMA and CREATE TABLE privileges on an existing schema or CREATE SCHEMA privileges on the target catalog.

• Create a Salesforce user that Databricks can use to retrieve data. Make sure that the user has API access and access to all of the objects that you plan to ingest.

All that is described in below article. There you also find examples with pipeline definition:

Ingest data from Salesforce - Azure Databricks | Microsoft Learn

Also you can take a look at below video:

Get Data Into Databricks - Lakeflow Connect with Salesforce