使用Scala spark读写Redshift的最佳方式是什么，因为Databricks不公开支持spark-redshift lib

import java.sql.{Connection, DriverManager, ResultSet}

import org.apache.spark.sql.{DataFrame, SaveMode, SparkSession}

val spark = SparkSession.builder()
  .appName("RedshiftExample")
  .getOrCreate()

val jdbcHostname = "your-redshift-hostname"
val jdbcPort = 5439
val jdbcDatabase = "your-redshift-database"
val jdbcUsername = "your-redshift-username"
val jdbcPassword = "your-redshift-password"

val jdbcUrl = s"jdbc:redshift://${jdbcHostname}:${jdbcPort}/${jdbcDatabase}?user=${jdbcUsername}&password=${jdbcPassword}"

val df = spark.read
  .format("jdbc")
  .option("url", jdbcUrl)
  .option("dbtable", "your-redshift-table")
  .load()

df.write
  .format("jdbc")
  .option("url", jdbcUrl)
  .option("dbtable", "your-redshift-table")
  .mode(SaveMode.Append)
  .save()