← Back to library
ESNative2 min readVIDEO

Exasol Virtual Schema × Snowflake × NexusIQ — Live Federated Query Demo

3 June 2026

How Exasol Virtual Schema Powers AI-Native Data Federation

I explored Exasol's Virtual Schema in the NexusIQ platform. Through this I connected Exasol SaaS to a live Snowflake warehouse and queried both databases through NexusIQ — an AI-native data platform I built from scratch.

No ETL. No pipelines. No data movement. One plain English question. Two databases. One federated answer.

What is Virtual Schema?

Virtual Schema is Exasol's approach to data federation. Instead of moving data between systems, it creates a virtual representation of external tables inside Exasol's SQL engine — allowing you to query remote databases as if they were local.

This means:

  • Snowflake tables appear as native Exasol tables
  • Cross-database JOINs execute in a single SQL query
  • Query optimization happens at the Exasol engine level
  • Zero data duplication — data stays where it lives
  • The NexusIQ Demo

    In this walkthrough, I demonstrate the full flow:

  • Connected Exasol SaaS to a live Snowflake Enterprise warehouse
  • Created Virtual Schemas mapping Snowflake tables into Exasol
  • Asked a plain English question in NexusIQ
  • NexusIQ generated federated SQL that queried both databases
  • Results returned in seconds — unified, governed, and audited
  • The user never knows which database answered the question. That's the point.

    Why This Matters for Enterprise AI

    Most enterprise AI systems fail not because of model quality — but because data is scattered across platforms. Federation solves this at the infrastructure level.

    With Virtual Schema + NexusIQ:

  • Business users ask questions in plain English
  • The AI layer generates optimized federated SQL
  • The data layer executes across Snowflake, Exasol, and more
  • Governance is applied consistently regardless of source
  • This is what AI-native data federation looks like in practice.

    Watch the Full Walkthrough

    Continue exploring

    More articles, videos, and architecture diagrams in the library.

    Back to library →