Solved. The problem was that some of the tables I tried to access were blocked by a transaction in a stuck stored procedure. So this was an SQL Server side problem specific for the tables I tried to access and had nothing to do with Azure/Databricks.