In my development environment, I have implemented a Scala project which connects to the Databricks cluster via dbconnect. Everything is configured well, and it is able to connect to the cluster properly and fetches the data.
But it is observed that sometimes it does not connect to the database. When I run
spark.sql("select * from dtabase.tablename")
it throws
Table or View not found
I checked the connection by executing databricks-connect test. It gives all tests passed. But I can’t figure out why I am not able to connect to the database.
P.S.: I am using IntelliJ IDEA as an IDE
