This is one of those Databricks concepts that becomes very easy once you stop thinking about features and start thinking about “Do I want to move the data or not?

As a data engineer, think:

• Query Federation = “Read remotely.”
• Lakeflow Connect = “Bring the data home.”

Article Link:

Query Federation vs Lakeflow Connect in Databricks: When to Query and When to Ingest 

#mvp