Wherobots Data Hub

The Wherobots Data Hub is the central interface for reviewing catalog schemas and adding new data sources. While the actual queries are run in Wherobots Notebooks, Job Runs, or SQL Sessions, the Data Hub is where you organize all your data as Havasu tables. In Wherobots Data Hub, you can:

• Add external data sources from Databricks Unity Catalog, AWS Glue Catalog, or Amazon S3 buckets.
• Browse all connected catalogs and their schemas.
• Inspect detailed table metadata, including location, format, and ownership.

​

Before you start

Before using this feature, you need the following:

• An Account within a Professional, Innovation, or Enterprise Edition Organization. For more information, see Create a Wherobots Account.
  • While only a Wherobots Admin can add a new catalog, a Wherobots Organization member with a User role can access already-integrated catalogs.

​

View table details

When you select a table in the Data Hub, you can view key details, including:

• Column Schema
• Table Owner
• Table Location
• Table Format
• Update Time
• Record Count

​

Review catalog audit logs

Review your Audit Logs for SpatialCatalog events in your Organization.

​

Catalog Types

The Data Hub supports two types of catalogs: Managed and Foreign.

​

Foreign catalog

A foreign catalog utilizes a zero-copy architecture, enabling you to query data directly where it resides without the need to move or copy it. These external tables are also integrated into the Wherobots Data Hub for unified browsing alongside your other catalogs.

​

Create a foreign catalog

Foreign catalogs are created by configuring access to the external source. Some sources use a Wherobots-managed connection object, while Databricks Unity Catalog uses direct authentication against the Databricks workspace URL. To add a foreign catalog in the Wherobots Data Hub, follow the step-by-step guide for your data source:

• Databricks Unity Catalog: direct authentication with either a PAT for Delta or OAuth client credentials for Iceberg. No Wherobots Cloud connection is used.
• AWS Glue Catalog: uses a Wherobots Cloud Connection.
• Connect to Databricks’ Unity Catalog
• Connect to AWS Glue Catalog

​

Managed catalog

For Managed Catalogs, Wherobots manages and optimizes the catalogs’ metadata. Examples of Managed Catalogs are our built-in curated datasets and any catalogs you create from an S3 storage integration.

​

Review curated Datasets

For more information on reviewing Wherobots’ built-in datasets, see Curated Datasets.

​

Create a Managed catalog

To create a Managed Catalog, follow the step-by-step guide for your data source:

• Create a catalog from an S3 Bucket Integration

​

Delete a catalog

To delete a catalog that you’ve integrated into your Wherobots Organization do the following:

1. Confirm that you are an Admin within your Wherobots Organization.
2. Go to the Wherobots Data Hub.
3. Select the catalog you wish to delete.
4. Click Delete.