Aeion BI + External Data Warehouses — Not Yet Implemented
Aeion BI queries Aeion's own collections — fast, fresh, no ETL. It does not currently connect to Snowflake, BigQuery, Redshift, Databricks, ClickHouse, or any other external warehouse: there's no warehouse-specific connector, no query-federation layer, and no cross-source join engine in the codebase today. If your organization has historical data in one of those systems, the practical path today is to import it into Aeion via [Singularity](/platform/singularity) (which does have real connectors for many SaaS sources) rather than querying it in place. The architecture below describes what a federation layer would look like if built — read it as a design sketch, not a shipped feature.
Supported Warehouses — Design Sketch, Not Implemented
None of the connectors below exist today; modules/bi's data_sources collection supports only Aeion-native collections, a generic "custom query," and a generic "external" source type — with no warehouse-specific driver behind any of them, and no code path that branches on source type when a report actually executes. Treat the list below as what a future warehouse-federation feature might cover, not a compatibility matrix.
Hybrid Query Architecture — Design Sketch, Not Implemented
This is illustrative of how a federation layer could work, not a description of running code — there's no predicate-pushdown, multi-source join, or cross-warehouse cost-tracking logic in Aeion BI today.
Setup Walkthrough — Snowflake Federation (Not Implemented)
There's no "Add Snowflake" flow in the admin UI, no Snowflake driver, and no schema-introspection code for warehouses in Aeion BI. Don't follow the steps below expecting them to work — they illustrate what such a setup flow would need to do if built.
Per-Tenant Security Considerations — Design Sketch, Not Implemented
These are the isolation patterns a warehouse-federation feature would need to consider, not controls Aeion enforces today (since there's no warehouse connection to secure yet).
Performance Optimization — Design Sketch, Not Implemented
Same caveat as above — these are the optimization strategies a federation layer would need, not shipped Aeion BI features.
FAQ
No — there's no connector for any of them yet. Aeion BI queries Aeion's own collections.
Import it via Aeion Singularity, which has real connectors for many SaaS and database sources, then report on it as an Aeion collection like any other data.
It's not built today. Talk to your Aeion contact if this is a hard requirement so it can be scoped and prioritized.
No — with no warehouse connection, there's no ML-model invocation against those platforms either.