can we use an azure ad token instead of the pat?

for our VSCode extension? no, not yet, but thats something we have on our list to add in the near future!

yes with vscode extension. Cool for this feature.. the target being not to authorize the creation of a pat for a user.. but to use his azure ad connection. As many Microsoft azure extensions already do.

I think plain python code will run with databricks connect (if it is a python program you are writing), and spark sql can be done by spark.sql(...).