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.

  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.
  • If you want, enable the optimization feature for sampling (beta).
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 are 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 on the Services Configuration tab of the Collibra settings or in Collibra Console:

Important Editing the Services Configuration from the Settings page isn't available in the latest UI (beta). If you use the latest UI, you can configure these settings only in Collibra Console. For more information, go to DGC service configuration settings.

Prerequisites

Steps

  1. Open the Services Configuration page.
    1. On the main toolbar, click Products icon, and then click Cogwheel icon Settings.
      The Collibra 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. 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.
  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. If you want to enable the sampling optimization, go to the Beta section and set the Sampling optimization enabled setting to True. By enabling this setting, the process of checking the Edge cache for samples is much faster.
  6. Click Save all.

For more information, go to DGC service configuration: options.
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.