Azure databricks to support Exec Stored Procedure on SQL sources
We use advanced SQL and T-SQL queries that includes stored procedures to carry out ETL activities on SQL.
We cannot any support or documentation on how to run Exec Sproc activities on Databricks. This is a push-down mechanism as shown below but it fails to run Exec Sp Sql commands.
val pushdown_query = "(select * from employees where emp_no < 10008) emp_alias"
val df = spark.read.jdbc(url=jdbcUrl, table=pushdown_query, properties=connectionProperties)