About import

The import functionality allows you to create or edit data in bulk in Collibra. By importing, you can create and edit communities, domains, assets, or complex relations and their characteristics such as attributes, relations, responsibilities, and tags from a view.

Tip

For importing complex relations using an Excel file, go to the knowledge base on the Collibra Support Portal.

If you want to edit a large amount of assets in one go, you can perform an export-import round trip:

Create a view that contains all the assets and characteristics that you want to edit.
Export the assets from that view.
Edit the exported file.
Import the assets back into the same view. Collibra automatically maps the characteristics during the import, implementing your changes.

You can also use the import functionality for integrations and synchronization with external systems. Instead of manually importing and exporting assets, you can use the Import REST API to automate the workflow. Visit the Developer Portal to learn more.

For example, you can use the import functionality to do the following:

Create assets in a new or existing domain.
Add and edit characteristics of existing assets.
Edit the display name or full name of existing assets.
Move assets to a new or existing domain.

For example, you can use the import functionality to do the following:

Create assets in a new or existing domain.
Add and edit characteristics of existing assets.
Edit the display name or full name of existing assets.
Move assets to a new or existing domain.

Note

You must have resource responsibilities that allow you to add or update assets or responsibilities for each community and domain where you want to perform the import operation. For complex relations, the permissions extend to the communities or domains that contain the assets referenced by the complex relation.
Importing assets and complex relations is restricted by the file upload settings, which define the maximum file size, allowed file extensions, and maximum amount of uploads and downloads per day. Contact Collibra Support to change the file upload settings. The default maximum file size is 512 MB. You can edit file upload settings in Collibra Console. The default maximum file size is 10 MB.
When importing Excel files, you may encounter an error with the file being too large. If this is the case, split the file into multiple smaller files or use CSV.
Importing data from a large Excel file can consume a lot of memory. To overcome this, you can:
- Import from CSV instead of Excel.
- Limit the Excel file to only contain the data you really need.
- Avoid using Excel formulas, such as such as COUNT or COUNTIF.