Connect Catalogs

Connect your data catalogs to Granica to discover, onboard, and manage tables for automated optimization.

Catalog Connections is how Granica discovers the tables in your data lakehouse. Once a catalog is connected, Granica continuously syncs table metadata and makes those tables available for compaction, compression, vacuum, partition expiration, and query acceleration policies.

Granica Catalog Connections — Add Connection dialog

Supported catalogs

Granica supports the following catalog types today, with more on the way.

Unity Catalog (Databricks)

Connect Granica to a Databricks workspace via a service principal. Granica integrates with Unity Catalog to discover all catalogs, schemas, and tables in the workspace.

Required credentials:

FieldDescription
Workspace URLYour Databricks workspace URL, e.g. https://workspace.cloud.databricks.com
Client IDService principal client ID
Client SecretService principal client secret

After providing credentials, click Test Connection to discover available catalogs, then select the catalog you want to manage.

Hive Metastore (HMS / Iceberg)

Connect Granica to a Hive Metastore for HMS-managed tables, including Apache Iceberg tables registered in HMS. This covers self-managed Hive deployments as well as managed HMS instances (e.g. Amazon EMR, CDH).

Required credentials:

FieldDescription
Metastore URIThrift URI of the Hive Metastore, e.g. thrift://10.123.64.35:9083
UsernameMetastore username (if authentication is enabled)
PasswordMetastore password (if authentication is enabled)

Polaris

Granica supports Apache Polaris as a catalog source for Iceberg tables managed via the Polaris REST catalog API.

Required credentials:

FieldDescription
Catalog URLPolaris REST catalog endpoint
Client IDOAuth2 client ID for Polaris access
Client SecretOAuth2 client secret

Coming soon

Granica is actively expanding catalog support. AWS Glue is next on the roadmap, enabling discovery of tables registered in the AWS Glue Data Catalog across S3-backed lakehouses. Additional catalogs will follow.

Add a connection

  1. Navigate to Catalog Connections in the Granica Console sidebar.
  2. Click + Add Connection.
  3. Select your Catalog Type (Unity Catalog or Hive Metastore).
  4. Enter a Connection Name — a friendly label used to identify this connection in the console.
  5. Fill in the catalog-specific credentials (see above).
  6. Click Test Connection to verify credentials and discover available catalogs.
  7. Select the catalog to sync (Unity Catalog only — HMS syncs all available databases).
  8. Click Create Connection.

Granica immediately begins an initial metadata sync. Depending on the size of your catalog, this may take a few minutes.

Table sync and eligibility

Only tables 0.1 GB and above are synced from the catalog by default. Smaller tables are excluded to focus optimization on high-impact workloads. If tables you expect to see are missing, ask your admin to adjust the threshold in Platform Settings.

Synced tables appear in the Table Manager, where you can onboard them for automated optimization.

Manage connections

From the Catalog Connections page you can:

  • Sync — Trigger a manual metadata sync for a connection to pick up newly added tables.
  • Edit — Update connection credentials or settings.
  • Delete — Remove a connection. This cascades to all synced table metadata. Managed tables with active policies are flagged before deletion.

Each connection shows its sync status (idle, running, completed, or failed), the last synced timestamp, and whether the connection is Active or Inactive.

Was this page helpful?

On this page