Data source-specific permissions

Before you can start ingesting metadata, ensure that you meet the required permissions for your specific data source.

These permissions apply regardless of whether you're using Edge or the lineage harvester.

Select a data source, to show the required permissionsthe enablement steps.

Currently, information is shown for:

Important 
Ensure that you meet the Azure Data Factory-specific permissions described in Set up Azure Data Factory.
You need read access on information_schema. Only views that you own are processed.
You need read access on the SYS schema.
If you are using the lineage harvester, you need read access on information_schema:
  • bigquery.datasets.get
  • bigquery.tables.get
  • bigquery.tables.list
  • bigquery.jobs.create
  • bigquery.routines.get
  • bigquery.routines.list

If you are using Edge, you also need:

  • resourcemanager.projects.get
  • bigquery.readsessions.create
  • bigquery.readsessions.getData
  • SELECT, at table level. Grant this to every table for which you want to create a technical lineage.
  • SHOW VIEW, at table level. Grant this to every table for which you want to create a technical lineage.
  • Read access to the SYS schema or the tables in the schema.
  • VIEW DEFINITION on the SYS schema.
  • VIEW DEFINITION on all relevant views and procedures.
Ensure that your service account token has the Read-Only permission.
Ensure that you have the permission to copy the target/ directory, which is generated by running the dbt compile command, to a local folder.

You need Monitoring role permissions.

To create technical lineage from calculated views in SAP HANA Classic on-premises, you need the following permissions: 

  • SELECT on the following views:
    • _SYS_REPO.ACTIVE_OBJECT
    • _SYS_REPO.ACTIVE_OBJECTCROSSREF
    • SYS.OBJECT_DEPENDENCIES
  • The CATALOG READ system privilege

To create technical lineage from calculated views in SAP HANA Cloud/Advanced, you need the following permission: 

  • The CATALOG READ system privilege

A role with the LOGIN option.
SELECT WITH GRANT OPTION, at Table level.
CONNECT ON DATABASE
You need read access on the SYS schema and the View Definition Permission in your SQL Server.
You need read access on definition_schema.
  • GRANT SELECT, at table level. Grant this to every table for which you want to create a technical lineage.
  • The role of the user that you specify in the username property in lineage harvester configuration file must be the owner of the views in PostgreSQL.
You need read access on the DBC.
You need read access to the following dictionary views:
  • all_tab_cols
  • all_col_comments
  • all_objects
  • ALL_DB_LINKS
  • all_mviews
  • all_source
  • all_synonyms
  • all_views
Note By default, the lineage harvester queries the all_source table to retrieve Package bodies. However, this requires the EXECUTE privilege. As an alternative, you can direct the harvester to query the dba_source table, which requires the SELECT_CATALOG_ROLE role. To do so, you need to:
  • If via Edge: Replace all_source by dba_source in the Other Queries field in your Edge capability.
  • If via the CLI lineage harvester: Replace all_source by dba_source in the file ./sql/oracle/queries.sql, which is included in the ZIP file when you download the lineage harvester.
  • Your user role must have privileges to export assets.
  • You must have read permission on all assets that you want to export.
The following permissions are required, regardless of the ingestion mode: SQL or SQL-API.
  • Ensure that the Snowflake user has the appropriate allowed host list. For details, go to Allowing Hostnames in Snowflake documentation.
  • You need a role that can access the Snowflake shared read-only database. To access the shared database, the account administrator the account administrator must grant the OBJECT_VIEWER and GOVERNANCE_VIEWER database role on the shared database to the user that runs the lineage harvester. The username of the user must be specified in the JDBC connection that you use to access Snowflake.
Before you start the Power BI integration process, you have to perform a number of tasks in Power BI and Microsoft Azure. These tasks, which are performed outside of Collibra, are needed to enable the lineage harvester to reach your Power BI application and collect its metadata. For complete information, go to Set up Power BI.

Collibra Data Lineage supports:

  • Power BI on the Microsoft Power Platform.
  • Power BI on Fabric.
The configuration requirements and the integration are the same, regardless of your setup.

Before you start the Tableau integration process, you have to perform a number of tasks in Tableau. For complete information, go to the following topics:

You need the following roles, with user access to the server from which you want to ingest:

  • A system-level role that is at least a System user role.
  • An item-level role that is at least a Content Manager role.

We recommend that you use SQL Server 2019 Reporting Services or newer. We can't guarantee that older versions will work.

Before you start the Looker integration process, you need to set up Looker.

  • You need the following Admin API permissions:
    1. The first call we make to MicroStrategy is to authenticate. We connect to:
      <MSTR URL>:<Port>/MicroStrategyLibrary/api-docs/ and use GET api/auth/login.
      For complete information, see the MicroStrategy documentation.
      If this API call can be made successfully, you can ingest the metadata.
    2. The same connection:
      <MSTR URL>:<Port>/MicroStrategyLibrary/api-docs/, but with GET api/model/tables/<tableId>.
      For complete information, see the MicroStrategy documentation.
      This endpoint is needed to create lineage and stitching.
  • You need permissions to access the library server.
  • The lineage harvester uses port 443. If the port is not open, you also need permissions to access the repository.
  • You have to configure the MicroStrategy Modeling Service. For complete information, see the MicroStrategy documentation.
Warning 

Collibra Data Lineage uses the API 4.0 endpoints. Some of these endpoints require that your Looker user has the Admin role, because the Admin role has the Administer permission, which is not available in the custom permission set. Your Looker user needs the Admin role for the following endpoints:

  • /connection
  • /projects
  • /users
  • /dashboard_elements/search

Due to a security update by Looker, you also need to select the "Disallow Numeric Query IDs" option in Looker. For complete information, see the Looker Query ID API Patch Notice.

Collibra Data Lineage only performs read operations (GET) on the API endpoints, with the exception of obtaining the access token, which requires a POST request.

Note Column-level lineage is not generated for tables that are created by SQL statements, unless you provide the SQL statements via the following means:
  • By creating a shared storage connection (if you are using Edge).
  • By using the folder connection method (if you are using the lineage harvester).

There are no specific permission requirements for this data source type.

There are no specific permissions requirements for downloaded SQL files.