@Grainne Farrant​ :

It is possible to connect QGIS to Databricks using ODBC, but it requires additional configuration. Here are the general steps to follow:

1. Install the ODBC driver for Databricks on your machine where QGIS is installed. You can download the driver from the Databricks website.
2. Set up a DSN for Databricks in the ODBC Data Source Administrator on your machine. Make sure you test the connection to ensure it is working properly.
3. In QGIS, go to the Layer menu and choose Add Layer > Add Vector Layer. Choose the Database tab and click the New button to create a new connection.
4. Choose the ODBC option and enter the name of the DSN you created in step 2.
5. Enter your Databricks username and password and click Test Connection to make sure it is working properly.
6. Once the connection is established, you should be able to see the tables and views available in your Databricks instance and add them to QGIS as layers.

Note that some users have reported issues with using ODBC drivers with QGIS on MacOS, so you may need to use a different approach if you are on that platform.