> ## Documentation Index
> Fetch the complete documentation index at: https://docs.getcollate.io/llms.txt
> Use this file to discover all available pages before exploring further.

# Unity Catalog Connector Troubleshooting

> Resolve Unity Catalog connector issues quickly with Collate's comprehensive troubleshooting guide. Fix common errors, configuration problems, and connection issues.

## Troubleshooting

### Workflow Deployment Error

If there were any errors during the workflow deployment process, the
Ingestion Pipeline Entity will still be created, but no workflow will be
present in the Ingestion container.

* You can then Edit the Ingestion Pipeline and **Deploy** it again.
* From the Connection tab, you can also Edit the Service if needed.

## Connector Debug Troubleshooting

This section provides instructions to help resolve common issues encountered during connector setup and metadata ingestion in Collate. Below are some of the most frequently observed troubleshooting scenarios.

## How to Enable Debug Logging for Any Ingestion

To enable debug logging for any ingestion workflow in Collate:

1. **Navigate to Services**
   Go to **Settings > Services > Service Type** (e.g., Database) in the Collate UI.

2. **Select a Service**
   Choose the specific service for which you want to enable debug logging.

3. **Access Ingestion Tab**
   Go to the **Ingestion tab** and click the three-dot menu on the right-hand side of the ingestion type, and select Edit.

4. **Enable Debug Logging**
   In the configuration dialog, enable the **Debug Log** option and click **Next**.

5. **Schedule and Submit**
   Configure the schedule if needed and click **Submit** to apply the changes.

## Permission Issues

If you encounter permission-related errors during connector setup or metadata ingestion, ensure that all the prerequisites and access configurations specified for each connector are properly implemented. Refer to the connector-specific documentation to verify the required permissions.

## Unity Catalog connection details

```
source:
  type: unitycatalog
  serviceName: local_unity_catalog
  serviceConnection:
    config:
      catalog: hive_metastore
      databaseSchema: default
      token: <databricks token>
      hostPort: localhost:443
      connectionArguments:
        http_path: <http path of databricks cluster>
  sourceConfig:
    config:
      type: DatabaseMetadata
sink:
  type: metadata-rest
  config: {}
workflowConfig:
  openMetadataServerConfig:
    hostPort: http://localhost:8585/api
    authProvider: no-auth
```

Here are the steps to get `hostPort`, `token` and `http_path`.

First login to Azure Databricks and from side bar select SQL Warehouse (In SQL section)

<img src="https://mintcdn.com/collatedocs/VqDQzKrztCMb5uhb/public/images/connectors/unity-catalog/select-sql-warehouse.png?fit=max&auto=format&n=VqDQzKrztCMb5uhb&q=85&s=603634ce8e25597636cfc3327a4884c6" alt="Select Sql Warehouse" width="1848" height="1358" data-path="public/images/connectors/unity-catalog/select-sql-warehouse.png" />

Now click on sql Warehouse from the SQL Warehouses list.

<img src="https://mintcdn.com/collatedocs/VqDQzKrztCMb5uhb/public/images/connectors/unity-catalog/Open-sql-warehouse.png?fit=max&auto=format&n=VqDQzKrztCMb5uhb&q=85&s=85f4943e0142aa95df763bbdf2e65913" alt="Open Sql Warehouse" width="1420" height="1402" data-path="public/images/connectors/unity-catalog/Open-sql-warehouse.png" />

Now inside that page go to Connection details section.
In this page Server hostname and Port is your `hostPort`, HTTP path is your `http_path`.

<img src="https://mintcdn.com/collatedocs/VqDQzKrztCMb5uhb/public/images/connectors/unity-catalog/Connection-details.png?fit=max&auto=format&n=VqDQzKrztCMb5uhb&q=85&s=34f2a7bcb764b908098e32c5d6699c11" alt="Connection details" width="2860" height="1338" data-path="public/images/connectors/unity-catalog/Connection-details.png" />

In Connection details section page click on Create a personal access token.

<img src="https://mintcdn.com/collatedocs/VqDQzKrztCMb5uhb/public/images/connectors/unity-catalog/Open-create-token-page.png?fit=max&auto=format&n=VqDQzKrztCMb5uhb&q=85&s=8f2b0f3153810b4b10a93685d9804d96" alt="Open create token" width="2860" height="1338" data-path="public/images/connectors/unity-catalog/Open-create-token-page.png" />

Now In this page you can create new `token`.

<img src="https://mintcdn.com/collatedocs/VqDQzKrztCMb5uhb/public/images/connectors/unity-catalog/Generate-token.png?fit=max&auto=format&n=VqDQzKrztCMb5uhb&q=85&s=9b6639fdda0545e93db0c870b6972048" alt="Generate token" width="2748" height="1068" data-path="public/images/connectors/unity-catalog/Generate-token.png" />