Have you tried the Databricks SQL environment?

It is designed for online querying. There is also a serverless env, but that is not yet GA.

Also something to try: import the data into power bi. If your dataset is not too big (or you have a premium subscription) .