Improve User Experience by Combining Pipeline Execution and SQLite Query Results in a Single Button Click

[espin086]

Currently, our application requires users to perform two separate actions to execute a pipeline and view the results. This two-step process can be time-consuming and negatively impacts the user experience. To enhance usability, we propose modifying the front-end streamlit code in the main.py function to consolidate these actions into a single button click.

Objective: The objective of this issue is to streamline the user experience by implementing a single button that triggers both the pipeline execution and the display of SQLite query results.

Proposed Solution:

1. Update the front-end streamlit code in the main.py function to include a single button labeled "Run Pipeline and Show Results".
2. When the user clicks on this button, the application should initiate the pipeline execution process.
3. Once the pipeline execution is complete, the application should automatically retrieve the results of the SQLite query.
4. The retrieved results should be displayed to the user in a clear and intuitive manner.

Expected Outcome: By implementing this change, users will no longer need to perform two separate actions, resulting in a more efficient and seamless user experience. The consolidated button will simplify the process and reduce the time required to execute the pipeline and view the query results.

Additional Information:

• The application is built using streamlit and utilizes SQLite for querying data.

Please view the CONTRIBUTING.md for instructions on how to contribute and take on this issue.

Thank you!

[espin086]

@AtharvaJadhav7 - here is another straight forward one to update the main.py to only have one button to push, let me know if you can help. Thank you!!!

[AtharvaJadhav7]

Yes I'll do this

[espin086]

Thank you!!!