I have spent way too much time to find a solution to the problem of efficiently writing data to Databricks via JDBC/ODBC. I have looked into countless docs, blogs and repos and I cannot find one example where someone is setting some kind of batch/bulk/buffer option to tell the jdbc driver to not write/insert data row-wise into a delta table. Is anyone aware of a solution? Many jdbc drivers to other destinations offer bulk/batch writes, even the Databricks MS SQL connector supports a bulkCopyToSqlDB method and similar for snowflake. Why can I not find anything when writing to Databricks. I looked into many things incl below. Any pointer is much appreciated.

• https://learn.microsoft.com/en-us/azure/databricks/dev-tools/python-sql-connector
• https://learn.microsoft.com/en-us/azure/databricks/dev-tools/pyodbc
• https://learn.microsoft.com/en-us/azure/databricks/external-data/jdbc