Edit Excel export configuration

In Collibra Platform, you can export Collibra data to CSV or Excel files.

Prerequisites

  • You have the ADMIN or SUPER role in Collibra Console.

Steps

  1. Open the DGC service settings for editing:
    1. Open Collibra Console.
      Collibra Console opens with the Infrastructure page.
    2. In the tab pane, expand an environment to show its services.
    3. In the tab pane, click the Data Governance Center service of that environment.
    4. Click Configuration.
    5. Click Edit configuration.
  2. In the Excel export configuration section, make the necessary changes.
    SettingDescription
    The default CSV separator characterThe default separator character of the CSV fields for complex relations.
    The default CSV quote characterThe default quote character of the CSV fields for complex relations.

    Number of rows per chunk of data

    When exporting views, the database is called repeatedly, each time fetching a chunk of data to build the export file. This option defines how many rows each chunk of data can contain.

    Lower values reduce the burden on memory. Higher values require more memory, but may slightly increase the speed of the export.

    The default value is 5,000.

  3. Click Save all.