File to Dataframe support - GCS/S3 to Pandas Dataframe

[sunank200]

Please describe the feature you'd like to see

• Define interfaces

  • Use Airflow 2.4 Dataset concept to build more types of Datasets:
    • Dataframe
  • Dataframe DataProviders
    • Add interface for Dataframe DataProvider.
    • Add interface for DataframeProviders.
    • Add read and write methods in DataframeDataProviders with the context manager.

• Non-native transfers

  • Add a transfer workflow for S3 to Pandas Dataframe using a non-native approach.
  • Add a transfer workflow for GCS to Pandas Dataframe using a non-native approach.
  • Add example DAG for S3 to Pandas Dataframe implementation.
  • Add example DAG for GCS to Pandas Dataframe implementation.

Acceptance Criteria

• All checks and tests in the CI should pass
• Unit tests (90% code coverage or more, once available)
• Integration tests (if the feature relates to a new database or external service)
• Example DAG
• Docstrings in reStructuredText for each of methods, classes, functions and module-level attributes (including Example DAG on how it should be used)
• Exception handling in case of errors
• Logging (are we exposing useful information to the user? e.g. source and destination)
• Improve the documentation (README, Sphinx, and any other relevant)
• How to use Guide for the feature (example)