Thanks for weighing in and proving an interesting insight. Here are some questions coming to my mind upon reviewing this thread.

1) .write.format("jdbc") has .option("dbtable", "SCHEMA.TARGET_TABLE"). Where to specify Databricks table and SCHEMA.TARGET_TABLE columns mapping. Do we need to make Databricks table and Oracle SCHEMA.TARGET_TABLE structures as mirror?

2) If we have many tables to process, do you need to make these for each table in notebook separate cell or there a way to make generic one script and pass tablename/structures as parameter. If we can , how do we that?

3) option("user", "<user>") , .option("password", "<password>") work for own account. If we use service principal account to prod env. How do we configure these credentials as hidden?

4) I was refering to “Lakebridge.” 

Thanks for your guidance.