I need to understand if it's possible to read and write data to a Databricks table with Power Apps.
So far, I understand that:
- Dataflows allow ETL operations and can only read data.
- Custom connectors allow both reading and writing.
- The HTTP action in Power Automate allows reading/writing.
Which one would you recommend? I would like to avoid the custom connector, and so far, the HTTP action seems the most functional.
Do you have any other ideas/suggestions?
Thank you very much