I have a requirement of authenticating azure dedicated pool from databricks using SPN client certificate. I want to write data (delta format) from ADLS Gen 1 to Dedicated pool via databricks. Could you please guide on how can we use client certificate for authenticating purpose?
I want to use "com.databricks.spark.sqldw" format to write data in dedicated pool. I am able to write the data using dedicated pool username and password but I want use client certificate for authentication.
Please find below the code I am using for username and password.
.option("url", "server_url:port number; database=database_name; user=user; password=password") \
.option("enableServicePrincipalAuth", "true") \
.option("forwardSparkAzureStorageCredentials", "true") \
.option("dbTable", "table_name") \
.option("tempDir", "Blob_TempDir_path") \