​

Query Mode

​

Two Scopes, One Console

​

The SPARQL Console

​

The Query Rail

• Ontology — context-aware starter queries generated from the model you have selected. New query starts from a blank scaffold:
  PREFIX om: <https://open-metadata.org/ontology/>
  
  SELECT ?conceptFqn WHERE {
    ?concept a om:GlossaryTerm ;
             om:fullyQualifiedName ?conceptFqn .
  }
  LIMIT 100
  
• Installation queries — shared templates curated for the whole deployment. Everyone authenticated can read and run them; only admins can create, edit, or delete them (Save as sample query). OpenMetadata seeds three: All glossary terms, Glossary term relationships, and Isolated glossary terms.
• Saved queries — your private library. Save query stores the current editor contents against your user.

​

Running and Reading Results

• Read-only — the console rejects INSERT, DELETE, DROP, LOAD, CLEAR, and CREATE. Writes go through the admin-only POST /api/v1/rdf/sparql/update endpoint, deliberately not exposed in the UI.
• Format — SELECT/ASK results as JSON (default), CSV, TSV, or XML; CONSTRUCT/DESCRIBE results as Turtle, JSON-LD, N-Triples, or RDF/XML.
• Inference level — none, rdfs, owl, or custom. See Reasoning & Validation.

​

Limits

​

The Visual Builder

• Find — the starting set, drawn from the current model.
• where — a relationship type and a target concept: the edge to traverse and where it lands.
• Generated SPARQL — the compiled query, updated as you change the chips, with a live N concepts match count.

• Run query — execute it in place.
• Edit as SPARQL — hand the generated query to the console. This is the fastest way to learn SPARQL against your own model: build it visually, then read what it produced.

​

The Standalone SPARQL Playground

​

Starter Queries

# Concepts with no relationships to any other concept
PREFIX om: <https://open-metadata.org/ontology/>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>

SELECT ?conceptFqn WHERE {
  GRAPH <https://open-metadata.org/graph/knowledge> {
    ?concept a om:GlossaryTerm ;
             om:fullyQualifiedName ?conceptFqn .
    FILTER NOT EXISTS { ?concept ?p ?t . ?t a om:GlossaryTerm . FILTER(?p != rdf:type) }
    FILTER NOT EXISTS { ?s ?p2 ?concept . ?s a om:GlossaryTerm . FILTER(?p2 != rdf:type) }
  }
}
ORDER BY ?conceptFqn
LIMIT 100

# Every typed relationship between concepts
PREFIX om: <https://open-metadata.org/ontology/>
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>

SELECT ?sourceFqn ?relationship ?targetFqn WHERE {
  GRAPH <https://open-metadata.org/graph/knowledge> {
    ?source a om:GlossaryTerm ;
            om:fullyQualifiedName ?sourceFqn ;
            ?relationship ?target .
    ?target a om:GlossaryTerm ;
            om:fullyQualifiedName ?targetFqn .
    VALUES ?relationship {
      om:relatedTo om:antonym om:partOf om:hasPart
      om:calculatedFrom om:usedToCalculate
      skos:broader skos:narrower skos:exactMatch
    }
  }
}
LIMIT 100

​

Next