Prerequisites

Alation Cloud Service Applies to Alation Cloud Service instances of Alation

Customer Managed Applies to customer-managed instances of Alation

Before installing and configuring the Dremio OCF connector, ensure that you configure the network connectivity and set up the service account.

Firewall Configuration

Open the Flight SQL outbound port to Dremio.

• Dremio default Flight SQL port is 32010. Note this differs from the port used by the legacy Dremio JDBC driver.

Driver

The Dremio Connector includes the Flight SQL JDBC driver by default. No driver installation is necessary.

Create a Service Account

It is recommended that a Dremio service account is created for use by the Dremio Connector.

Instructions to do so are located in the Adding Users section of the Dremio documentation.

Permissions

While logged in to Dremio as a user with the “admin” role, grant the following permissions to the service account.

All subsequent examples assume the service account username is ‘alation’.

Permissions for Metadata Extraction & Query Log Ingestion

GRANT SELECT ON SYSTEM TO USER alation;

Permissions for Sampling and Profiling

Grant SELECT to all datasets to be profiled. This can be done at the folder, schema, source, and/or space level. More information can be found in the Privileges section of the Dremio documentation.

GRANT SELECT ON ALL DATASETS IN <FOLDER|SCHEMA|SOURCE|SPACE> <object_name> TO USER alation

Example that grants SELECT to all datasets in the SOURCE foo:

GRANT SELECT ON ALL DATASETS IN SOURCE foo TO alation;