Connect to Your Data Warehouse(s)¶
Numbers Station begins by securely integrating with your existing data platforms, including Redshift, BigQuery, Snowflake, and Databricks. This establishes a controlled pipeline that ensures reliable, on-demand access to structured data.
Data Warehouse Integration¶
Direct connections to major cloud data warehouses and lakehouses (Redshift, BigQuery, Snowflake, Databricks) enable on-demand querying. No data is extracted or stored outside your controlled environment.
Automated Business Context Enrichment¶
Once connected, the system automatically ingests schemas, existing semantic definitions, and historical SQL query logs. As it processes these sources, Numbers Station identifies business-relevant metrics, entities, dimensions, and relationships, building an enriched metadata layer that captures the full context of your data landscape.
Knowledge Layer Foundation¶
This curated metadata is then consolidated into the Numbers Station dataset, an AI-driven semantic repository that extends beyond traditional semantic layers. The dataset is part of Numbers Station Knowledge Layer that stores relationships between data elements, keeps track of common metrics, and aligns technical schemas with the business domain. By doing so, it sets the stage for high-accuracy querying and prepares the environment for more intuitive analytics.
Summary¶
The data warehouse connection provides Numbers Station the anchor to build the knowledge layer along with the ability to run SQL commands. This enables all downstream analytics operations—whether it is creating new insights, surfacing key metrics, or embedding answers directly into applications—to be executed within a single, consistent framework.