Importing

The import functionality allows you to create or edit data in bulk in Collibra Data Intelligence Platform.

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, see 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:

  1. Create a view that contains all the assets and characteristics that you want to edit.
  2. Export the assets from that view.
  3. Edit the exported file.
  4. 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.
Note 
  • 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.
  • 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.