Create virtual table to native table relationships

Enabled for	Public preview	General availability
Users by admins, makers, or analysts	Aug 20, 2024	Oct 4, 2024

Business value

With this feature, you can build applications that use virtual tables for lookups and filtering. You can create complex applications that use relationships between virtual tables and native tables.

Feature details

This feature support relationships between virtual tables and native tables. The feature includes the following capabilities:

Simple lookup operations:

• Filters with AND and OR operators, plus all condition operators
• Order by lookup field
• Multiple lookups with CRUD operations, filters, conditions, and ordering
• Paging

Expansion operations with types of join inner and left outer:

• Link without relationship
• Retrieve all attributes
• Order by expanded field and combined clauses
• Filters with AND and OR operators plus all condition operators
• Paging
• Multi-level expand
• One-to-many expand scenarios

Geographic areas

Visit the Explore Feature Geography report for Microsoft Azure areas where this feature is planned or available.

Language availability

Visit the Explore Feature Language report for information on this feature's availability.

Additional resources

Set up a virtual table relationship (docs)