Limiting schemas

Limiting schemas allows you to manage usage and restrict visibility to only the necessary schemas of JDBC connections in the Explorer tree. This helps to reduce the clutter from excess schemas, which allows you to access the data you need more quickly.

Note When you include a restricted schema in the query of a DQ Job, the query scope may be overwritten when the job runs. While only the schemas you selected when you set up the connection are shown in the Explorer menu, users are not restricted from running SQL queries on any schema from the data source.

In this topic

Prerequisites

You have:

  • ROLE_ADMIN or ROLE_CONNECTION_MANAGER

Limiting schemas on new connections

Note 
  • Limiting schemas on connections limits the available schemas in Explorer and the Connections step when setting up an integration with Collibra Data Intelligence Platform.
  • If you plan to use the limit schemas option, avoid replacing or modifying schemas in your connection after running a job. Doing so may result in an expected scenario where the selectable columns in the Rule Workbench reference the new schema instead of the schemas of the original job.
  1. On the main menu, click , then click Connections.
  2. Click Connections.
    3. The Connection Management page opens.
  3. Click Add Connection on the upper right side of the page.
    The Add New Connection dialog opens to the JDBC Connections tab with a list of supported JDBC data sources.
  4. Click a data source.
    The Add Connection template appears.
  5. Enter the required information, and select the Limit Schemas option on the Details tab.

    6. Important The required information in the connection may vary depending on your connection type. However, you must enable the Limit Schemas option to limit schemas from your connection.

  6. Click Submit.
  7. From the Connections page, on the far right side of the row containing your newly created connection, click Actions, then click Limit Schemas.
    8. The Limit Schema Mapping dialog appears.
  8. Limit schemas by moving them from the Included box to the Not included box. To do this, select the schema(s) you wish to limit, then click . You can also use the search fields to filter schemas.

    Note You can remove included schemas by selecting them from the Included box, then clicking to move them to the Not included box.

    screenshot of the limit schema mapping dialog

  9. Click Submit.
    10. The schemas you added to the "Not included" box in the Limit Schema Mapping dialog are no longer visible in the Explorer tree.

Limiting schemas on existing connections

Note 
  • Limiting schemas on connections limits the available schemas in Explorer and the Connections step when setting up an integration with Collibra Data Intelligence Platform.
  • If you plan to use the limit schemas option, avoid replacing or modifying schemas in your connection after running a job. Doing so may result in an expected scenario where the selectable columns in the Rule Workbench reference the new schema instead of the schemas of the original job.
  1. On the main menu, click , then click Connections.
  2. Click Connections.
    3. The Connection Management page opens.
  3. On the far right side of the row containing an existing JDBC connection, click Actions, then click Edit.
    4. The Edit Connection template appears.
  4. Select the Limit Schemas option.

    5. Important You must enable the Limit Schemas option on the Details tab to limit schemas from your connection.

  5. Click Submit.
  6. On the far right side of the row containing an existing JDBC connection, click Actions, then click Limit Schemas.
    7. The Limit Schema Mapping dialog appears.
  7. Limit schemas by moving them from the Included box to the Not included box. To do this, select the schema(s) you wish to limit, then click . You can also use the search fields to filter schemas.

    Note You can remove included schemas by selecting them from the Included box, then clicking to move them to the Not included box.

    screenshot of the limit schema mapping dialog

  8. Click Submit.
    9. The schemas you added to the "Not included" box in the Limit Schema Mapping dialog are no longer visible in the Explorer tree.