@VCA50380 Have you explored Notebooks functionality in Databricks

1. Widgets provide a way to capture interactive input in your notebook.
2. Using that input, you can build SQL statements to update your backend Oracle database.
3. Connectivity Options:
   • Use Spark’s JDBC connector for bulk operations.
   • Use a Python connector like cx_Oracle for executing individual SQL commands, which is more straightforward for interactive, one-off updates.
   • Then you can build Interactive dashboards based on the updates

This approach allows you to combine the interactivity of Databricks notebooks with the power of programmatically updating your Oracle database based on real-time user input.