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
After the first successful sync, you can view this mapping information in the Schema tab on your connector dashboard.
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.)||RFC-4180|
|JSON text files delimited by new lines||RFC-7159|
|Avro||Apache Avro 1.8.2|
|Excel (XLS, XLSX, and XLSM) Private Preview||Microsoft Excel|
NOTE: The worksheets in your Excel workbook become separate tables in your destination. We use the values present in the first row of your worksheet as the column names in the destination table. We don’t create a destination table if the entire first row of the sheet is empty. We don’t sync a column if its first row is empty. We also don’t sync empty worksheets.
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