Connect to Databricks without using personal access token

[KimLamNg]

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. 

[KimLamNg]

I figured this out after asking ChatGPT :)

[apathetichell]

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.

[dreldrel]

This link may be useful for you:https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Connecting-data-from-Databrick...

If this helps, feel free to like the comment