Until our team can build proper connectors, exporting CSV to import is a great stepping stone to get the data into our Data Store. The issue is with larger tables, where appending to a CSV every refresh is a painful operation where it'd be easier to add a new file to a folder for the refresh period which then in turn updates a single table in the destination, shared by all files in the folder.
As of today this connector has each file as it's own table in the destination source which isn't how we'd use it. For now we are completing a manual merge prior to upload and hoping our local CPUs can handle it for now. While we can build scripts, hoping to have this operation completable by non-technical users.