Skip to main content
Wherobots Data Federation enables users to query external data sources in place, eliminating the need for data migration. This is achieved by creating a Connection, which stores the access credentials and path to the data source. Once connected, Wherobots presents the external data as a foreign catalog in the Data Hub. You can then query this external catalog’s data in a Wherobots Notebook and write your results.
When you connect to a foreign catalog, Wherobots acts as a client and data governance takes place at the data’s source. With a foreign catalog you can mirror and manage data from external data systems within Wherobots.
  • External Source of Truth: The external system (such as Unity Catalog) is the authoritative source for metadata. Wherobots does not own or control that metadata.
  • Read-Only Connection: Wherobots reads metadata from the foreign catalog to understand available tables and schemas but does not write to that specific table or manage its lifecycle.
  • No Data Discovery: The external system (e.g., Databricks Unity Catalog) is responsible for discovering data and keeping its own catalog up to date. Wherobots simply reflects the current state of that external catalog.

Benefits of Wherobots Data Federation

  • Zero-Copy architecture: Read tables managed by external cloud providers, like Databricks, without moving or duplicating data.
  • Secure federation: Set up access to an external data source once by creating a single, secure connection.
  • Get a unified view of all your Organization’s data: All connected tables appear side-by-side in the Wherobots Data Hub. This allows your team to browse, query, and even join data from different sources as if it were all local, dramatically simplifying data discovery and analysis.
  • Accelerated innovation on the lakehouse: Take spatial ideas to market faster using Wherobots’ 300+ spatial functions, raster inference, and compute for physical world data on your Unity Catalog data.

Create a catalog Connection

To create a catalog Connection in the Wherobots Data Hub, select your data source from the list below and follow the step-by-step guide: