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 pushdownquery = "(select * from employees where empno < 10008) empalias"
val df = spark.read.jdbc(url=jdbcUrl, table=pushdownquery, properties=connectionProperties)
crazy this still isnt supported