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.
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
We do not sync files inside nested folders in your cloud folder. We do not sync empty folders or unsupported file types.
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