Configure the use of sample data via Edge

You must configure your Collibra environment if you want to display sample data for data sources registered via Edge.

Tip Sample data for data sources registered via Edge is temporarily cached on the Edge site. In the cache, the sample data is encrypted. The data is available in the Edge cache for 24-48 hours.

  Configuration step More details
1 Ensure your Edge site meets the memory, CPU and hard disk requirements. Edge hardware requirements to show sample data
2 Ensure the users have the required permissions. Required permissions to view sample data.

Important Several out-of-the-box roles already include the required permissions.
3

In the Service Configuration settings,

  • Set the Data Profiling setting Maximum number of samples to a value higher than 0.
  • Define the maximum number of characters that you want to collect per sample in Maximum value length.
Important The Maximum number of samples value applies to both Jobserver and Edge. In mixed environments, if this number was set to 0 for Jobserver and you increasing the value for Edge, this can result in sample data extraction for data sources registered via Jobserver.

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

Prerequisites

Steps

  1. Open the Services Configuration page.
    1. On the main menu, click , and then click Settings.
      The Settings page opens.
    2. In the tab pane, 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. Go to the Data profiling section.
  3. Make sure the setting Maximum number of samples is higher than 0.
    The default value is 100. The maximum value is 1,000.
    For more information, go to DGC service configuration: options.
  4. In Maximum value length, define the maximum number of characters that you want to collect per sample.
    We don't recommend increasing this number as it may affect the stability of the system.
  5. Click Save all.
4 For each data source, add the Catalog JDBC Sampling capability to Edge.

Add the Catalog JDBC Sampling capability for your data source Edge connection.

  • The Catalog JDBC Sampling capability consists of two possible operations:
    • Extracting the sample data, which collects the data from a data source and caches the data on the Edge site.
    • Reading the sample data, which reads sample data from the Edge cache and returns it as a result of an API call or displays it in an asset page.
  • Once the capability is selected, define the JDBC connection to which the capability applies.

For detailed information on the sample data process, go to Understanding the process to display sample data.