When you configure a mapping that reads from or writes to Databricks Delta, the Secure Agent, by default, connects to the Databricks SQL warehouse to run the SQL query and process the mapping.

However, you can connect to the Databricks cluster instead of the SQL warehouse to process the mapping. To do so, enable the Secure Agent properties for the design time and runtime. The Secure Agent connects to the analytics cluster to import the metadata at design time and to the job cluster to run the mappings.

The Secure Agent runs a Spark job in the cluster to read data from or write data to Databricks Delta tables.