Palantir has made Ontology SQL and Ontology SQL functions generally available on all Foundry enrollments as of the week of November 9. The company announced the change on its Foundry announcements page on November 12, 2026.

Ontology SQL lets users query the Ontology through a subset of the Spark SQL dialect. Palantir describes it as Foundry's SQL engine for querying Ontology object types, interfaces and many-to-many links.

How it works

Palantir says queries execute directly against object storage. It says an in-memory compute path gives fast response times on supported query shapes. More complex queries are automatically routed to Spark, according to the announcement.

Ontology SQL functions are parameterized SQL queries over the Ontology that can be published as Foundry functions. The announcement shows a query being published as a SQL function and managed from Ontology Manager. Its published versions can be explored there.

Where it can be used

Palantir says SQL functions can be used in Workshop, Actions, Automate and the Ontology SDK. Ontology SQL itself is also available in Workshop, Insight, Quiver and AIP products, the company said.

The announcement also points to SQL Studio, which Palantir calls Foundry's dedicated application for writing and running SQL queries. It describes SQL Studio as an interactive, AI-assisted interface for SQL analysis of tabular data and Ontology objects.

What comes next

Palantir says Ontology SQL is under active development. Its near-term plans are:

  • better support for Spark SQL functions
  • execution optimizations to reduce query latency
  • better observability on planning and execution

The company asks for feedback through Palantir Support channels or its Developer Community.

What is not disclosed

The announcement does not say which Spark SQL functions or syntax are supported. It does not define "supported query shapes". It gives no latency figures, benchmarks or pricing.

It does not say what stage the feature was in before general availability, or when each enrollment received it. The announcement gives the date only as "the week of 9 November". The year is taken from the page's November 2026 listing.

This story is based solely on Palantir's announcement. The linked product documentation was not reviewed.