Virtual Tables are a new addition to Foundry that let you access data in external source systems without needing to transfer either data or logic into Foundry. This tutorial covers how to set up and use Virtual Tables, how they're different from Datasets, and when you should consider using them.

All data shown in this tutorial is notional data created for teaching purposes.

Ontologize
Ontologize was founded by Taylor Gregoire-Wright, a former Palantir implementation engineer. Ontologize offers live trainings for Palantir Foundry. Visit ontologize.com/ or connect on LinkedIn: www.linkedin.com/in/tgregoirewright/.

Chapters
00:00 Intro
01:08 Setting up Virtual Tables
02:09 Analyzing Virtual Tables in Contour
02:44 Query push-down
03:04 Using Virtual Tables in Pipeline Builder to back the Ontology
04:12 Using Virtual Tables in Pipeline Builder for data engineering
04:40 Differences between Datasets and Virtual Tables
06:00 Keep egress costs in mind for certain external systems
06:20 When to use Virtual Tables
06:46 Auto-registering tables in Foundry
07:03 Using Virtual Tables in regular data pipelines
07:20 Creating downstream Datasets or replacing Virtual Tables
07:30 Using Virtual Tables for storage cost or architectural reasons
08:00 Outro