cony2025
New Contributor II

Hi @Advika_ 

Thanks for your answer. I modified to the below according to your recommendation. Howerver, I still received column names, instead of the data, as the result. 

 

df = (spark.read.format("jdbc")
    .option("url", jdbc_url)
    .option("dbtable", query)
    .option("user", "token")
    .option("password", access_token)
    .option("driver", "com.databricks.client.jdbc.Driver")
    .option("fetchsize", "10000")
    .load())

 

I saw a solution recommending to import and register the dbsqlDialectClass to the JAR file, but I can't figure out how to do it properly. I appreciate any guidance!