Rather than using the creds, I want to use tokens in Splunk DB Connect to get the data from Spark database.
Q1: Can we change the Auth Mech to token based, while creating the identities or connections in Splunk DB Connect app?
Q2: Can we put authentication parameters into the JDBC url itself?
The possible JDBC url for connecting to the database.
jdbc:spark://<hostname>:<port>/<database>;transportMode=<transport_mode>;ssl=1;httpPath=http;AuthMech=3;UID=token;PWD=<token>
Some reference Link for Simba driver: https://www.simba.com/products/Spark/doc/JDBC_InstallGuide/content/jdbc/options/authmech.htm
DB Connect currently supports only credential-based authentication. Go to https://ideas.splunk.com to suggest it support token-based authentication.