Hi, I've been attempting to get this solution to work for an internal client but haven't had success.

Here are the configurations I'm using with the 64-bit windows ODBC administrator:

• Driver = Simba Spark ODBC Driver v2.08.02.1013
• Host and port confirmed as correct, I can use the odbc connection with power query, etc.
• Mechanism OAuth 2.0, using token passthrough and a PAT generated in dbx.
• Client secret encryption is set for 'All users of this machine'.
• Auth_Flow=2 is set in the http properties, and the http path is confirmed working and is taken from the dobc details page from the dbx cluster.
• spark server type = SparkThriftServer (Spark 1.1 and later)
• Service Discovery Mode=No Service Discovery
• Thrift Transport=HTTP

Solutions Attempted:

• in server side properties, set catalog=[desired catalog] (convert key name to lower case and apply properties with queries both checked)
• in server side properties, set dataricks.catalog=[desired catalog] (convert key name to lower case and apply properties with queries both checked)
• in advanced options, setting 'Driver Config Take Precedence' (wild guess)
• in Database, replacing 'default' with [desired catalog]
• in HTTP Options, adding catalog=[desired catalog]