Scala/Spark Code to connect to DremIO

Is there a way to connect to DremIO using Scala/spark programmatically for creating datasets on top of S3 bucket data and then query/view that data?

@ankitaKamat Any reason you cannot use the Dremio UI or a JDBC query tool?

Actually I want to test the DremIO performance with 50 or more concurrent users querying at the same time and since I’m comfortable with Scala/Spark, so thinking of using the same language for it? Is it possible to do it? If yes can you provide any links with examples @balaji.ramaswamy

@balaji.ramaswamy Do you have any link to where I can find examples on jdbc query tool?

@ankitaKamat

https://docs.dremio.com/client-applications/dbeaver/

https://docs.dremio.com/client-applications/dbvisualizer/