Edit CSV export configuration

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

Depending on your environment, follow this procedure either in Collibra Console or on the Services Configuration tab of the Collibra settings:

Important You can't edit the service configuration from the Settings page in the latest UI. If you use the latest UI, you can edit the service configuration only in Collibra Console. For more information, go to DGC service configuration settings.

Prerequisites

Steps

  1. Open the Services Configuration tab:
    1. On the main toolbar, click Products icon → Cogwheel icon Settings.
      The Settings page opens.
    2. Click Services Configuration.
    3. Click Edit configuration.
    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 CSV export configuration section, make the necessary changes.
    SettingDescription
    Always use quotes
    • True: Use quotes for every cell in the CSV.
    • False (default): Only use quotes when necessary.

    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.