Connecting pyspark to CrateDB inside Jupyter Notebooks

[hammerhead]

Hi @suchrandomstuff,

can you please try adding an option call setting the driver class (.option("driver", "io.crate.client.jdbc.CrateDriver")?

You can also use a standard PostgreSQL JDBC driver instead, we have a Spark-based example of how to connect in this post:

Introduction to Azure Databricks with CrateDB

This is a quick intro into getting started with Azure Databricks and CrateDB. Setup Azure Databricks Add a new Databricks service to your Azure Subscription Once this is done use “Launch Workspace” After you are signed into Azure Databricks use the common task “New Cluster” to start a cluster for your Spark jobs execution Install the pgjdbc library (as of time of publishing org.postgresql:postgresql:42.2.23) from Maven for your cluster [azure-databricks-server-install-library] [azure-dat…