Federation
Federation
Query data from other databases and data warehouses.
Federation lets you query data directly from external sources without copying or moving it.
Benefits
Unified view of your data
Provides a single, unified view of your data from various sources without complex data integration.
Improved data discovery
Simplifies finding and accessing data across the organization.
Reduced data duplication
Eliminates the need for time-consuming data ingestion by querying data directly from external sources.
Enhanced governance
Extends Propel’s data governance and security features to federated data sources.
Key Features
- Federated querying: Query data from multiple sources at once, combining data from different databases and data warehouses in a single query.
- Fine-grained access control: Access Policies enforce row and column-level access controls as well as multi-tenant JWT tokens.
- Logs and observability: The platform provides tools for tracking data usage across all sources and facilitates easy data discovery.
- Integration with Propel APIs and Embeddable UI: Works seamlessly with Propel’s Query APIs and Embeddable UI.
Supported data sources
Limitations
- Queries are read-only.
- The speed of queries is limited by the speed of the underlying data source.