Exclude Schemas From Lineage Charts Globally

Alation Cloud Service Applies to Alation Cloud Service instances of Alation

Customer Managed Applies to customer-managed instances of Alation

Available from version 2024.3.5

Important

You are viewing documentation for Classic Alation.

As a Catalog Admin or Server Admin, you can exclude specific schemas from the Compound Layout view of lineage charts globally through lineage settings in Admin Settings. Tables and views from the schemas that have been excluded via lineage settings won’t appear in any lineage charts.

Note

Users interacting with lineage charts also have the ability to exclude schemas from the chart to adjust the number of lineage nodes to be displayed. See more in Exclude Schemas. Unlike that filtering by users, this global filter will apply to all charts.

Select Schemas to Exclude

To exclude schemas globally:

  1. Click the gear icon in the top right corner of the page. The Admin Settings page will open.

    ../../_images/TopNavigationBar_Gear_Neo.png

  2. In the search bar on top of the Admin Settings page, search for Lineage Settings. Alternatively, locate the Lineage Settings tile under Platform Settings. Click Lineage Settings to open that page.

  1. Click the Settings icon (the three gears) in the top right corner of the page.

    ../../_images/TopNavigationBar_Gear.png

    • Catalog Admins: A dropdown menu appears. Click Customize Catalog.

    • Server Admins: The Admin Settings page appears. Under the Catalog Admin section, click Customize Catalog.

  2. The Customize Catalog page appears. Click the Lineage tab to open Lineage Settings.

  1. Click the Default Filters sub-tab to open it.

  2. Click the Search icon at the far right of the Select Schemas To Exclude (Compound layout) field to open a list of data sources relevant to the current chart.

    ../../_images/Lineage_GlobalExcludeSchemas_SelectSchemas.png

    Important

    Make sure to click on the Search icon exactly and not on the field. Clicking on the field won’t work.

  3. Use the search bar under Select Data Sources to find a specific data source.

  4. Select a data source to view its associated schemas. You can change the data source later using the dropdown menu.

  5. After selecting a data source, you will see a list of schemas in this data source that are relevant to this lineage chart. Choose one or more schemas to exclude from the lineage chart by selecting the corresponding checkboxes. Select the Select All check box to select all schemas in this data source.

    ../../_images/Lineage_GlobalExcludeSchemas_SchemasList.png

  6. You can select multiple schemas across different data sources. To select more schemas from a different data source, change the data source in the data source dropdown list and select more schemas.

  7. Click Done on top right of the Select Schemas widget to apply your selection of schemas. The information about selected schemas appears in the Select Schemas To Exclude (Compound layout) field, displaying the number of selected schemas per data source.

  8. Click Save under the field to apply the configuration.

Update the Exclude Schemas Filter

To update an existing Select Schemas To Exclude default filter:

Remove All Schemas for a Data Source

  1. Click the delete icon (X) for schemas in the Select Schemas To Exclude (Compound layout) field to deselect all schemas for a data source.

  2. Click Save.

Remove or Add Specific Schemas

  1. Click the search icon under Select Schemas To Exclude (Compound layout) to open the list of data sources.

  2. Select a data source.

  3. Select or deselect schemas in this data source by selecting the corresponding checkboxes.

  4. Click Done on top right of the Select Schemas widget to update your selection of schemas.

  5. Click Save under the field to apply the updated schema filter to the chart.

Schema Filter and Schema Access Permissions (Beta)

Alation Cloud Service on the cloud-native architecture

Applies from Backend version 2024.3.5

Starting in version 2024.3.5, your Data Source Admins can set up specific access permissions on schemas. The permissions can be quite restrictive: certain objects can only be accessible by specific users and inaccessible by most users. This feature is beta and disabled by default. It requires server configuration to be enabled. Find more information in Data Source Privacy Settings.

Currently, restricted permissions on schemas don’t have an impact on your ability to exclude schemas from lineage charts.