Prerequisites¶

Alation Cloud Service Applies to Alation Cloud Service instances of Alation

Customer Managed Applies to customer-managed instances of Alation

ACS Customers¶

If you are an Alation Cloud Service customer, ensure you have Alation Agent installed and running. The Agent is mandatory for this connector in ACS deployments.

On-premise / Self-managed Alation Customers¶

Check Alation Connector Manager (ACM) is installed and running. ACM is mandatory for OCF connectors.

Firewall Configuration¶

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

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;