Error: Unity Catalog Quota Exceeded

Issue

Destination setup tests fail. The following error appears:

QUOTA_EXCEEDED.UC_RESOURCE_QUOTA_EXCEEDED

Environment

Destination: Databricks

Resolution

To resolve this issue, check your current table usage and quota limits using the Unity Catalog Resource Quotas API or SQL queries. For more information, see the Databricks documentation on monitoring your Unity Catalog usage.

If you confirm that the quota has been reached, choose one of the following options:

Request a quota increase

If the required number of tables is expected for your workload, contact your Databricks account team or Databricks Support to request a quota increase.

Reduce the number of tables

To reduce the total table count in Databricks, you can:

• Drop unused tables, especially in test or development schemas, or deprecated outputs in the metastore.
• Remove stale ingestion outputs, such as old sync versions or abandoned pipelines.
• Use partitioning techniques to consolidate multiple small tables into fewer, larger tables.
• Query information_schema.tables to identify and clean up schemas with a high table count.

To reduce unnecessary tables from your connection schema in Fivetran:

1. Go to the relevant connection page.
2. Select the Schema tab.
3. Deselect the checkbox next to each table you want to exclude.
4. Click Save changes.

Cause

Unity Catalog enforces limits on the number of tables per metastore. This issue occurs when the table count reaches the quota, and Databricks prevents us from creating new tables.