How Can I Sync Compressed File Contents to Separate Tables?

Question

How can I sync individual files within a .zip file to separate tables in the destination?

File connectors

You can sync files inside a compressed archive as separate destination tables only with connectors that support the Merge Mode sync method.

To sync each file in a .zip archive as its own table:

Go to your connection overview page.
Select the Setup tab.
Under Files, click + Files.
Specify the Table name for the data in your destination.
Leave the File pattern (optional) field blank or specify the .zip file name.
In the Archive File Pattern (optional) field, use a regular expression that matches the specific file inside the archive. For example, to sync file1.csv, specify (?i)file1\.csv.

Repeat the above steps for each file you want to sync as a separate table, using different archive file patterns and table names.