Our Magic Folder connectors sync any supported file from your cloud folder as a table within a schema in your destination.
You can use your cloud folder’s URL to configure the connectors. Fivetran automatically syncs the files from your folder as unique tables to your destination. That is, each file in your source becomes a table in your destination. Fivetran detects the changes you make to the existing files in your cloud folder and syncs and updates your destination tables.
- Box BETA
- Consumer Dropbox BETA
- Google Drive BETA
- OneDrive PRIVATE PREVIEW
- SharePoint PRIVATE PREVIEW
We use the file name (without the extension) as the destination table name. For example, we sync a file named
account_details.csv as the
NOTE: For our SharePoint connector, we use the file name along with the parent folder name as the destination table name. For example, a file
folder1/folder2/folder/sample.csvis synced as
We do not sync files inside nested folders in your cloud folder. We do not sync empty folders or unsupported file types.
IMPORTANT: Our SharePoint connector syncs files from multiple folders. We can sync files from subfolders and nested folders in your SharePoint site.
Supported file formatslink
Magic Folder connectors support the following file formats:
- Separated Value Files (CSV*, TSV, etc.)
- JSON text files delimited by new lines
- JSON Arrays
Magic Folder connectors support the following file encodings:
- UTF-8, UTF-16, and UTF-32, with big or little endian order
- UTF-8 encoding is assumed if no Byte-Order Mark is present at the beginning of a file