Importing

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

By importing, you can create and edit communities, domains, assets, mappings or complex relations and their characteristics such as attributes, relations 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 lot of assets in one go, you can perform the so-called export/import roundtrip. First create a view that contains all the assets and characteristics that you want to edit, then export the assets from that view. You can then edit the exported file, and import the assets back into the same view. Collibra will automatically map 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 
  • Exporting and 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 if you want to change the file upload settings. The default maximum file size is 512 MB.
  • When importing a very large Excel file, you may encounter an error with the file being too large. If this is the case you will need to split the file into multiple smaller files or use CSV.
  • Importing data from a large Excel file can consume a lot of memory. We advise you to import from CSV instead of Excel, or to limit the Excel file to only contain the data you really need.