Goal (cf. picture): OD als ETL Tool:
- OD picks up data from SFTP
- OD does some ETL
- OD saves as .parquet on the cluster.
- OD provides the parquet impala-ready for microstrategy (tableau, PowerBI, …)
While 1-3 is possible, is it currently possible to connect OD to a SFTP, more concreteley:
I know from other customers, that we can use mounted volumes to use the Filesystem R/W Feature.
- Can we use that feature as well for SFTP?
- If not, can we mount an SFTP to OD such that we can use the feature?
- If not, is the feature planned?
If 1 to 3 are positive, how do I use it?