Yes I have also observed it. Later in other videos I found out that we have to add it as an option when reading data into data frame like .option("driver", jdbcDriver")
I want to do query from sql and load the result into one variable. Can we do that. Like select max(id) from sql table. I am using this id for comparison in next steps
What about just being able to access those same tables via an existing databricks catalog in the hive metastore structure for example? Is there a way to do that?
Hi Raja's, I am following this tutorial step by step but I got an error while running the 2nd cell of getting product table. the error is " java.sql.SQLException: No suitable driver", can you please help in this case.
Jdbc connection has performance issue while handling huge amount of data. But there are options to improve the performance which can be applied depending on the use case