Yes, this is possible but you need to enable a specific file transfer type through your account executive first.
Then you create an automation with the following steps:
- Data Extension Extract
- File transfer from safehouse to export folder
- Move or Copy File Transfer (the one you need to activate)
- Import to your data extension
Due to the wild card limitations your automation should be set to daily or a longer interval as you will run into issues with your files otherwise.
It might be possible to import your extracted file directly from the safehouse, which would reduce the automation to steps 1 and 4. You should try that first to avoid the hassle of getting the activity type enabled.
I haven't tried that, however. Possibly someone from the community can confirm if this works