Load data from Aurora to Databricks directly

[creditorwatch]

Hi,

Does anyone know how to link Aurora to Databricks directly and load data into Databricks automatically on a schedule without any third-party tools in the middle?

[kelvinmedina]

The same doubt here.

[MariuszK]

AWS Aurora supports PostgreSQL or MySQL, did you try to connect using JDBC?

url = f"jdbc:postgresql://{database_host}:{database_port}/{database_name}"

remote_table = (spark.read
.format("jdbc")
.option("driver", driver)
.option("url", url)
.option("dbtable", table)
.option("user", user)
.option("password", password)
.load()
)