Hi @jakubk ,

Thanks for your response, I have tried to make a connection via spark simba odbc driver and it works. So that is great, thanks. I also have been able to connect via oauth2.0. 

The only thing I cannot achieve via access is to change to tables from inside the unity catalog, i.e. I can only see tables in the hive_metastore and cannot change the default / or to any other catalog. I cannot find where I need to configure the connection string, can you help me to achieve this?

Btw from Excel I do see all catalogs if I connect via the same odbc driver. Also, I would be keen to learn how you setup a DSNless connection via Excel, if you could give me any pointers to documentation that would be much appriciated. 

Thanks again! 

Bram