Connect to Databricks without using personal access token

Question

I'm trying to figure out how to connect to Databricks without a personal token (my company is moving away from using it). It appears this should be possible using OAuth but I'm not sure how exactly to set this up. Any guidance will be greatly appreciated! I'm using Alteryx 2023.

dreldrel · Answer

This link may be useful for you:https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Connecting-data-from-Databricks-as-input-to-Alteryx-Desinger/td-p/1241407

If this helps, feel free to like the comment

apathetichell · Answer

Great --- I just got a tester on Alteryx and was able to do it --- my way was to set up the connection in the ODBC 64 using Oauth with a service principal and then tell Alteryx to use that connection but not to need additional credentials (ie no credentials) for ODBC. That seemed to work.

KimLamNg · Answer

I figured this out after asking ChatGPT :)