As described in the link below, there is possibility to use Databricks Connect with PySpark in Databricks Apps, so you can write Python df code instead of creating SQL statements for the SQL API. But an example is missing in the cookbook.
Tutorial: Develop a Databricks app locally with Databricks Connect | Databricks on AWS
Please show both scenarios with service pricipal and on-behalf-of user authentication with keeping the connection in user session context.
Also I heard, that there are pros and cons of using Databricks Connect vs Databricks SQL. That should be explained.
As described in the link below, there is possibility to use Databricks Connect with PySpark in Databricks Apps, so you can write Python df code instead of creating SQL statements for the SQL API. But an example is missing in the cookbook.
Tutorial: Develop a Databricks app locally with Databricks Connect | Databricks on AWS
Please show both scenarios with service pricipal and on-behalf-of user authentication with keeping the connection in user session context.
Also I heard, that there are pros and cons of using Databricks Connect vs Databricks SQL. That should be explained.