​

Import and Export Data Assets

Collate lets you bulk import or export data assets as CSV files instead of editing them one at a time in the UI. Update metadata for many assets in a single operation, or pull an asset’s current metadata into a spreadsheet to review or hand off.

​

What You Can Do

• Bulk import: Create or update Database Services, Databases, Database Schemas, and Tables in a single CSV upload, from the UI or the API.
• Bulk export: Download the current metadata for any of those asset types as a CSV, from the UI or the API.
• Round-trip editing: Export an asset as a CSV, edit it in a spreadsheet, then import it back to apply the changes in bulk.
• Validate before you commit: The import flow previews every row with a Passed/Failed count, and lets you fix errors inline before finalizing.

​

How It Works

Both import and export follow the same pattern for every asset type:

1. Open the asset (or its parent service) and select Import or Export from its ⋮ menu (Database Services use Settings instead).
2. For import, upload a CSV, or export an existing asset first to use as a starting template.
3. Review the preview and fix any failed rows, then confirm to apply the changes.

See Import Data Assets for the exact CSV fields each asset type expects, and both guides for API endpoints if you’d rather script it.