How to ingest CSV file extract from object storage to oracle ADW database using OOTB features in oracle FDI. we do not any ETL tool in place to meet this requirement
@User_7AIAG As a service administrator, you can use the Fusion Data Intelligence extract service to acquire data from Oracle Object Storage Service and use it to create data augmentations.
Refer: Load Data from Oracle Object Storage into Fusion Data Intelligence
https://docs.oracle.com/en/cloud/saas/analytics/24r4/fawag/managing-data-connections.html#GUID-3DA25647-02FF-455C-A608-C5C92DF05FB8
Refer: Connect with Cloud File Storage Sources
https://docs.oracle.com/en/cloud/saas/analytics/24r4/fawag/managing-data-connections.html#GUID-A0AF2E40-3828-474C-9FF2-7A3C1D64A128
You can also refer the below blog.
https://blogs.oracle.com/analytics/post/loading-data-from-oss-into-oracle-fusion-analytics